Unlike SQL 2008, in SQL 2005 we cannot define a unique stop list (Noise Word List) for each database. As this is controlled by the
Windows 2003 Cluster: SQL Node Not able to Join Cluster after Changing MaxTokenSize
As per Cannot Generate SSPI Context article, Link, I had changed the MaxTokenSize to fix the issue. I had read various articles before jumping into
SSPI Context Cannot be generated
I am sure everyone has seen this error there are many articles on MSDN, newsgroups, etc.; but I ran into very interesting problem with these
Default Backup Path Error
I had blogged about how to set default backups for SQL Server 2005 (Link) and SQL Server 2008 (Link); but I recently ran into an
Bench Mark Logging
Bench marking also system administrators to easily see what changed between the time system went live and the current performance issue being experienced. So I
SQL Server 2005 Full Text Search services failed to Start Up
Right after setting up SQL Server 2005 cluster on Windows 2008; the FTE Services did not start up automatically. Following error gets recorded in the
SQL Canada (SQLCAN) 