Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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...
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...
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...
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...
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...
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...
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...
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...
Date: 06/11/2008
Replication over firewall
Most of the times you would run into scenario where you have a firewall between publisher/...
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...
Date: 04/15/2008
Hypothetical Indexes
Hypothetical Indexes are created by Index tuning wizard when it checks queries & tables for...
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...
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...
Date: 02/06/2008