Search results for query: *

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 possible issues arising from such a deployment? Thanks, Jim Ruddy

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 run the exec sp_helplogins BUILTIN\Administrators script, but it gives back no memebership info at all.How can one investigate beforehand...

SQL Server mag had a script from Canadian GIlles Despaties that audits failed logins intelligently and emails the results in SQLMAIL. My problem is that SQLMAIL is not used in our SQL Servers, and I was wondering how to insert CDOSYS instead in the following code so that the CDOSYS utility is...

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 permissions that each login has. sp_helprotect doesn't do this for each login. Thanks in advance Jim Ruddy

To all SQL Server gurus, please help! Does anyone has a SQL script that can start at the beginning of the logins (in the Security section for that server) and list, for each login, their respective server roles and database permissions? What about checking or scanning through a whole group of...