We are going to use Bindview Patch Deployment utility to automatically install SPa across a wide range of SQL Server 2000 servers. Is anyone aware of...
I ran this xp and got a single row saying account name, type, privilege,mapped login name, permission path =...
Here is a thorny problem for security: Is there any way to tell WHO is logging in and using the BUILTIN login and WHO the real members of it are? I...
SQL Server mag had a script from Canadian GIlles Despaties that audits failed logins intelligently and emails the results in SQLMAIL. My problem is...
I needed to copy the script correctly, you were right, it now runs fine. What it shows, however, when I run it on master, is simply an empty grid,...
I tried this script but I got an error <br /><br />Server: Msg 170, Level 15, State 1, Line 1<br />Line 1: Incorrect syntax near 'ENDSELECT'.<br...
What I need is a script that will go through each login in the security section login list and tell, for each, not the server roles but the database...
Does anyone has a SQL script that runs through all the logins in the security section of the server and lists the database roles permissions and...
Separate names with a comma.
