Showing posts from November, 2014

SQL SERVER – Error: SSMS Database Compatibility Level Drop Down is Empty

I recently installed SQL server 2014 on my machine; I was using the SSMS for SQL 2012 as it as all the pluggins installed for my daily use.  Now for testing an application, i have restored a database…

Could not update the metadata that indicates database is enabled for Change Data Capture. The failure occurred when executing the command SetCDCTracked(Value = 1)

I got this  error message when I was trying to enable CDC on a SQL Server  database for “ Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal, Line 193 Could not update the meta…

How to list role members in SQL Server

Below is the query to list the users in a specific role.  if you are looking for the users who can manage the sql server agent jobs, use the filter ( Where rp.name = ‘SQLAgentRole’)  and run this…

Restrict user from connecting to the database from SSMS

The following logon trigger will restrict a user from connecting thru SQL Server management studio. As always, test this first before implementing. This will deny all the connections made by the us…

DBCC PAGE to Examine SQL Server Table and Index Data

I was writing another article on the smallest dataset possible in sql server, and i came across a situation where I need to use DBCC PAGE () statement for a table. DBCC PAGE () statement, uses data…

When statistics was updated ?

Statistics are very important for sql server engine,  it is  used by the SQL Server optimizer to choose the most efficient plan.  When we don’t have up to date statistics it may end with SQL serve…
Subscribe Our Newsletter