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
Category: Administration
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
How do I calculate database growth 12 months from now?
How to calculate database growth over 12 months?