SQL

Sometime you want to identify the tables which could not reindex online. For this you had to scan all tables in SQL Server database and li...

I was trying to modify a table of approx 5 million records setting a field on the table to not allow null values. However, while saving cha...

You may receive below error while running third party application with backend SQL Server. Record Retrieval Error Error: (Connection Read...

Sometime you may get below error while attaching a database: Attach database failed for Server 'SERVERNAME\SQLEXPRESS'. (Microsof...

Use below query to get details of permissions on Database objects SELECT ulogin.name AS [User Name], CASE princ.type WHEN 'U' TH...