August, 2009

There are a lot of Changes in the Transaction Log Architecture of SQL 2000 and SQL 2008. There is a huge difference in the way the log records are maintained in SQL 2000 vs SQL 2005/2008. We keep more information in the Transaction Log in SQL 2005...

While installing SQL Server 2005 on a windows server 2003 cluster the installation fails. After you select the Components to Install and click next we get the following error: Error Massage: TITLE: Microsoft SQL Server Setup -------------...

Sometimes you do not see the proper event description of SQL Server events in the application log. For Eg: 29/07/2009 12:00:00 MSSQLSERVER Information System Event 17055 <SQL server Instance Name > "The description for Event ID ( 17055...

We can query the results from the Microsoft search through SQL server. If we create a linked server with Search.CollatorDSO provider and try to query the SYSTEMINDEX to read the Microsoft search results. We get an error in SQL server 2008 Below...

In SQL Server 2008, sometimes the product name and the data source information goes blank in Linked server properties window for a Linked server of provider type Microsoft OLEDB provider for SQL Server or SQLOLEDB . When we create a Linked Server...

The problem is that we have a Named instance of SQL Server 2005 in a 2 node cluster. While trying to bring the SQL Services online we get these error messages in the Application Event Log. Application Event Log: Event Type: Error Event Source...

The error message we get is as below, <Error Message> 02/04/2009 14:33:20.418 02/04/2009 14:33:20.419 Setup launched 02/04/2009 14:33:20.420 Attempting to determine media source 02/04/2009 14:33:20.421 Media source value not specified...

Good morning Folks! Today I will take you through a setup issue that many of you might have run into when trying to install SQL Server 2005 (especially on a cluster). I’ve tried to list down all possible solutions to the following errors one faces while...

We have observed a number of cases where in the dts package fails to open from the enterprise manager in sql 2000 or management studio in sql 2005. We are able to create a new DTS package and save them but when we try to open them, it fails with below...

Q: What is Preallocate Setting? Answers: Preaallocate Setting specifies a certain percentage of memory be allocated to Analysis Services when the service starts (memory preallocation). This configuration setting was introduced because the Microsoft...

We have seen that when we use a sql server 2008 profiler trace to trace RPC calls coming from an ADO.Net application and if the ADO.Net applications calls a stored procedure which accepts the parameters of datatype “datetime” which has a precision of...

Many a time there is a need to programmatically change in the SQL Server configuration settings. This can be done through the methods exposed via SQL Server’s WMI namespace. The need for this script arose due to a need to change the Port Number of multiple...

Problem Description in our scenario: ============================ We have a default instance of SQL Server 2000 Service pack 4. When we try to run a job, the job doesn’t run . We don’t see any failure messages either. When we click the job properties...