Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Mani Singh

SQLServerCentral.com profile

   Items 1 to 8 of 8   
 

public access to extended SP's

check public access to extended stored procedures  Read more...
By Mani Singh 2008/08/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 881 reads

Find Guest user access level in all databases

Search for GUEST Access Level in all   Read more...
By Mani Singh 2008/08/06 | Source: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 1,245 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,244 reads

Grant Permission to Specific objects(e.g. SP's)

Grant permissions to specific objects in Database using dynamic SQL.  Read more...
By Mani Singh 2008/08/01 | Source: SQLServerCentral.com | Category: administrator
Rating: |  Discuss |   Briefcase | 2,489 reads

Column Level Permissions

GRANT Column Level Permissions  Read more...
By Mani Singh 2008/06/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,608 reads

Search for a String in all Stored Procedures and beyond?

Search for String Occurence with this script in your stored procedures.  Read more...
By Mani Singh 2011/10/20 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 4,832 reads

show users in NT Groups

List users in NT Groups  Read more...
By Mani Singh 2008/07/29 | Source: SQLServerCentral.com | Category: administrator
Rating: |  Discuss |   Briefcase | 1,183 reads

get users across all databases on the SQL Server instance

Quick way to get all users on all Databases  Read more...
By Mani Singh 2008/07/24 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 1,555 reads
   Items 1 to 8 of 8