Browse by Tags

All Tags » sql server » security   (RSS)
SQL Server 2005 detect DAC session with TSQL
09 May 08 11:11 AM | SQL Master | 3 Comments   
SQL Server 2005 has introduce a secret-door for Admins to identify and resolve any connect lockout issues within your database instance, as on http://sqlserver-qa.net/blogs/tools/archive/2007/08/04/dedicated-administrator-console-dac-saved-an-important-day-for-a-dba.aspx Read More...
TSQL to findout blocking and locks on a SQL Server?
07 December 07 12:08 PM | SQL Master | 2 Comments   
Have you ever performed huge operations such as deleting records of a table and processing inserts on that table at the same time? This is a common task that every application will have to perform and you can avoid by fine tuning your queries (mostly Read More...
How to find all the owners of entities contained in a specified schema?
04 October 07 01:00 AM | SQL Master | 2 Comments   
How to find all the owners of entities contained in a specified schema? USE <database_name>; GO SELECT 'OBJECT' AS entity_type ,USER_NAME(OBJECTPROPERTY(object_id, 'OwnerId')) AS owner_name ,name FROM sys.objects WHERE SCHEMA_NAME(schema_id) = '<schema_name>' Read More...
SET TRUSTWORTHY ON when using SP_CONFIGURE
17 July 07 02:09 AM | SQL Master | 1 Comments   
SET TRUSTWORTHY ON, from the name itself it sounds like you are not allowing anything that cannot be trusted. SQL Server 2005 has introduced a new database property called TRUSTWORTHY that is used to indicate whether the instance of SQL Server trusts Read More...