Create a Logon Trigger to Restrict sysadmin logins to connect to SQL Server for given Time Interval
I was struggling with unwanted modifications of SQL Server configurations by random SQL Server sysadmin logins who were part of…
8 years ago
T-SQL
How to Protect Stored Procedure Code in SQL Server?
Have you ever thought how to protect stored procedure codes deployed on your SQL Server Instance? When deploying applications to…
12 years ago
How to Disable AutoCommit in SQL Server?
Autocommit mode is the default transaction management mode of the SQL Server Database Engine. Every Transact-SQL statement is committed or…
14 years ago
How to find Total no of Traces Running on your Database Instance?
Suppose you want to find out how many traces are running on your SQL Server database instance? If you don't…
14 years ago
How to Move Table to Another Filegroup?
Suppose we had a database that has grown very large in size and located on the D drive that had…
15 years ago