Consider this scenario: - You have made a SQL Server x64 installation. - You want to connect to Oracle from SQL Server Management Studio (SSMS) or Business Intelligence Development Studio (BIDS). - You get an error like this: ORA-12154:TNS:could not resolve...

Consider this scenario. You are trying to create a new installation of SQL Server and it is failing. The first step in identifying what went wrong is to examine the setup logs of SQL Server. During installation there will be created some setup log files...

Suppose that the Onepoint database has reached a huge size for any reason. Normally you would check that all grooming jobs and the DTS tasks are running as they are supposed to. But these operations need a lot of additional disk space to be performed...

Note: I will be adding any new explanations/causes I find for cluster log errors in this post. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Error: ERR IP Address <orafssrvIP>: WorkerThread: GetClusterNotify failed with...

Recently we came across this error: Event ID : 9158 Source : Microsoft Operations Manager Type : Error Message : Failed to send SMTP message. The server rejected one or more recipient addresses. hr=-2147220977. We checked the email addresses and...

How to change the collation of TEMPDB Consider this scenario: - During installation of SQL Server you defined a certain collation e.g. (A). - You then attached a user database with a different collation e.g. (B). - You then noticed that some queries...

Consider this scenario: - You are installing SQL Server 2005 x64 on Windows 2003 x64. - Setup fails at some point with this error: "SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client...

We recently stumbled upon this error while bringing online a newly created MSMQ resource, on a Windows 2003 cluster: "Message Queuing objects cannot be created in Active Directory (Error: 0xc00e0025)" This issue is usually resolved by making...

Consider this scenario: -You are setting up a SQL Server 2005 x64 failover instance on a Windows x64 cluster. - During the setup you get error: "Error HRESULT E_FAIL has been returned from a call to a COM component" (Screenshot is saved here...

So it is this time period of the year again, when Auditors knock on your door and examine your SQL Server Security to find loopholes. In this thread I will be gathering all the strange questions Auditors ask you and what is the truth behind them... ...

Recently I was asked how to configure the Antivirus to not affect the SQL Server services. Well, most people think that the Antivirus keeps their servers safe, but if you haven't configured it appropriately it can do so much more, like crashing your SQL...

At first, you need to identify if the table needs partitioning. In order to do that, you can run this query to see which tables of the database are the biggest and if there is e.g. a table that takes half the space of the database by itself: ~~...