Problem Sometimes, while working on SQL Server, users receive various error messages like SQL Server Error 5172 due to encounter of suspect or corruption in
Category: Administration
Help! I have -2, -3, or -4 Session ID!
We can kill a session by using KILL command. However, KILL command requires a positive number; executing KILL with negative number returns an error: Msg
Know How to Resolve Microsoft SQL Server Error 5172
Overview SQL Server is a relational database management system, developed by Microsoft that is used for storage and retrieval of data whenever required. Database on
How to get orphaned logins for all databases?
Following script gives you all user database users, that do not have a server login mapped or where database user name does not match server
sys.foreign_keys does not have matching row in sys.indexes
Running DBCC CHECKDB you are getting following error message: Check Catalog Msg 3853, State 1: Attribute (referenced_object_id=194099732,key_index_id=7) of row (object_id=2040565179) in sys.foreign_keys does not have
SQL Canada (SQLCAN) 