Browse by Tags

All Tags » login   (RSS)
SP_HELP_REVLOGIN for SQL Server 2005
04 September 07 06:54 AM | SQL Master | 2 Comments   
SP_HELP_REVLOGIN stored procedure helps you to generate a script that can be used to recreate the logins that exist on a server at a specific point in time script the logins along with password. I'm not sure how many DBA are aware of this Stored Procedure Read More...
Disable SA account on a live SQL Server2005 instance, any drawbacks?
13 August 07 02:03 AM | SQL Master | 2 Comments   
Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more 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...
Trigger a trigger event when a new trigger is created
29 May 07 02:50 AM | SQL Master | 1 Comments   
Trigger a trigger event when a new trigger is created, for a moment I was muffled with number of times you need to mention to call the subject. So looking at the need you will have to ask whether it is possible or not. Coming to the subject, yes it is 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: , , ,