-
Recent Posts
Recent Comments
- Jon Lewis on A Busy/Accidental DBA’s Guide to Managing VLFs
- Arnold Lieberman on A Busy/Accidental DBA’s Guide to Managing VLFs
- Update Statistics fails with Error Number:–1073548784 “Could not allocate space for object ‘dbo.SORT” – ReplTalk on Stored Procedure to Sequentially Run SQL Agent Jobs
- steve kirchner on Whats a Good Rule for Max Degree of Parallelism?
- Bipin on Stored Procedure to Sequentially Run SQL Agent Jobs
Archives
Categories
Meta
Category Archives: User Management
How Do I Kill All Sessions from a Windows Group?
The stored procedure I am posting today will kill all sessions for users that are members of a given domain group. I use this stored procedure to keep ad-hoc (write down Access) users out of the way of nightly builds on my data warehouse. Continue reading
How Can I Tell if a Windows Login has Rights to My Server?
This is a great stored procedure to use for things like server dashboards where you only want people to see the dashboard for servers that they have access to without granting them all the rights that would go with the dashboard. Continue reading
How Do I Identify Invalid or Unneeded Logins?
I was looking at one of my servers and was caught off-guard by how many individual users had been granted rights. To make it worse I recognized a few user names as former coworkers. Clearly time for some house cleaning. Here is the script I came up with to do the analysis. Continue reading
Posted in User Management, Utilities
Tagged logins, sp_validatelogins, SSC, validation, xp_logininfo
Leave a comment
Get Users By Connection
Here is some TSQL to get who is connected to a SQL 2005 server by connection type, including a filter to focus on the Dedicated Administrator Connection (DAC). Continue reading
Posted in User Management
Tagged DAC, Dedicated Admin Connection, Dedicated Administrator Connection, SSC
Leave a comment