SQL Server Information

Windows Sync Manager shows error message "Microsoft SQL Server could not save the security changes" when specifying user/password for publisher/distributor

Symptoms In pull subscriptions, when you use Windows Synchronization Manager to synchronize, it will...

Author: Anurag_Sharma Date: 01/26/2010

Error: 17207, Severity: 16, State: 1. STREAMFCB::Startup: Operating system error 0xc01c0012(failed to retrieve text for this error. Reason: 317) occurred while creating or opening file '(file path)'.

Symptoms A SQL Server 2008 database having filestream enabled is in either recovery or being...

Author: Anurag_Sharma Date: 01/26/2010

Replication agents may fail with error "Server '(servername)' is not registered at server '(servername)'."

Symptoms One or more replication agents are failing with below error in verbose log <verbose...

Author: Anurag_Sharma Date: 01/26/2010

SQL Server 2000 or SP4 installation or bringing SQL resource online after install/ upgrade fails with "The specified service does not exist as an installed service"

After installing SQL Server on a cluster or upgrading it to Sevice Pack 4, if you reboot the nodes...

Author: Anurag_Sharma Date: 02/24/2009

The SQL Server FullTextSearch (MSSQLSERVER) service depends the following service: NTLMSSP. This service might not be installed.

SQL Server 2005 FullText Search on Windows 2008 [Longhorn] Cluster fails to come online. Below is...

Author: Anurag_Sharma Date: 02/24/2009

How to audit user activities from Transaction Log File

There are scenarios where you may want to find out which user deleted the data or created a table...

Author: Anurag_Sharma Date: 02/24/2009

How to manually install SQL SP4 scripts when only the binaries have been upgraded

There are times when we see that while installing Service Pack 4 for SQL Server 2000 on standalone...

Author: Anurag_Sharma Date: 02/24/2009

How to see commands with Command IDs in SQL Server 2000

Below query will help in seeing the command along with command_id. This is helpful in cases where...

Author: Anurag_Sharma Date: 06/11/2008

Replication over firewall

Most of the times you would run into scenario where you have a firewall between publisher/...

Author: Anurag_Sharma Date: 06/11/2008

A value for the parameter @host_name was specified, but no articles in the publication use SUSER_SNAME() for parameterized filtering.

When adding data partitions in merge publication sometimes below error is encountered Cannot add a...

Author: Anurag_Sharma Date: 04/15/2008

Hypothetical Indexes

Hypothetical Indexes are created by Index tuning wizard when it checks queries & tables for...

Author: Anurag_Sharma Date: 04/15/2008

Passing a GUID value from command line using DTEXEC to a variable to be used as a parameter in OLEDB Source Query in SSIS Package fails with "Invalid character value for cast specification"

I found a case where customer was using a OLE DB Source & had specified a Parameterized SQL...

Author: Anurag_Sharma Date: 02/20/2008

Not all login failures are logged in SQL Server 2005

When login attempts with a bad password for a SQL Login are done through a .Net Application which is...

Author: Anurag_Sharma Date: 02/06/2008