Browse by Tags

FIX: SQL Server Agent replaces the A_DBN token with "master" in a job that responds to a database alert in SQL Server 2005

Published 22 October 7 4:12 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: SQL Server Agent replaces the A_DBN...

Filed under: sql server, kba, token, scheduled job, a_DBN, master, database alert

Script to find out all the groups contain in the login token for every server principal

Published 17 July 7 10:44 AM | SSQA.net

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...

Filed under: sql server, security, users, login, script, token, principal