The Curious Engineer

All blogs / Databases

SQL Server Information

learn.microsoft.com/en-us/archive/blogs/anurag_sharma

DatabasesMicrosoft blogsMSDN archive

’10’15’20’25
Posts
13 from 6 Feb 2008 to 26 Jan 2010
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/anurag_sharma/feed.xml

2010 3

  1. Windows Sync Manager shows error message "Microsoft SQL Server could not save the security changes" when specifying user/password for publisher/distributor
  2. 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)'.
  3. Replication agents may fail with error "Server '(servername)' is not registered at server '(servername)'."

2009 4

  1. 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"
  2. The SQL Server FullTextSearch (MSSQLSERVER) service depends the following service: NTLMSSP. This service might not be installed.
  3. How to audit user activities from Transaction Log File
  4. How to manually install SQL SP4 scripts when only the binaries have been upgraded

2008 6

  1. How to see commands with Command IDs in SQL Server 2000
  2. Replication over firewall
  3. A value for the parameter @host_name was specified, but no articles in the publication use SUSER_SNAME() for parameterized filtering.
  4. Hypothetical Indexes
  5. 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"
  6. Not all login failures are logged in SQL Server 2005