I saw many people asking this question over and over again and today, I’d like to share with you a backdoor to SQL Server 2012 which would help you gain SYSADMIN access to your production SQL Se…
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…
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…
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…
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…
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…
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…
Since SQL Server 2012 , you can find this information in the SQL Server Error Logs. Before SQL Server 2008 R2 there used to be some properties maintained but is now unused Mode of this instance …
Today I was working on updating operator emails on SQL Server and when i ran the script it gave me given below error. SQL Server blocked access to procedure 'dbo.sp_update_operator' of c…
Here is the script that will help you the database backup and restore histories SELECT TOP 10 b.database_name , BMF.physical_device_name as BackupFileName , B.backup_f…
Here is the query that lists all the user permissions, you need to run this on proper database to list the permissions, You can also put a filter on user WITH cteUserPermissions AS ( -- P…
Variables have been available in SSIS since first introduced in. They can be used for a number of different purposes: 1. Define the path of a package 2. Hold system information, such as e…
I was recently came across a question in one of the user forums where a stored procedure that required using both temporary tables and dynamic SQL. Seems like user wasn’t aware of the fact that the…