Browse by Tags

All Tags » script   (RSS)
SQL Server SP_HELPINDEX - updated version that includes column names
03 January 08 12:46 PM | SQL Master | 2 Comments   
Here is the incentive for the SQL Server users (this new year), you may be aware then using SP_HELPINDEX or SP_HELP could give some part of information on the indexes and database objects. But to know more about depedant columns you need to query INFORMATION_SCHEMA Read More...
Script to find out all the groups contain in the login token for every server principal
17 July 07 08:44 AM | SQL Master | 1 Comments   
The following query will get you the information to find out the groups that contain user login token on that server principal: SELECT name , usage , type FROM sys.login_token ORDER BY usage , type , name go To find any Windows principal in the token Read More...
Make use of tools and utilities that are available in SQL Server - performance & tuning
08 July 07 05:19 AM | SQL Master | 1 Comments   
There are various tools available within SQL Server installation such as SQLDIag, SQLDumper, PSSDiag (to be downloaded as a seperate tool), SYSMON(PERFMON) and Profiler etc. Among these SqlDiag and Sqldumper are most important to get more information Read More...
Script to check user access on master and associated user database
28 May 07 10:16 AM | SQL Master | 0 Comments   
SELECT name , principal_id , type_desc , is_disabled , default_database_name , default_language_name FROM sys.server_principals WHERE name = 'login_name' go SELECT name , database_id , user_access_desc , state_desc , is_in_standby FROM sys.databases WHERE Read More...
Filed under: , , ,