SQLServerCentral - Scripts by Mani Singh

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 | 838 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,187 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 0001/01/01 | Source: SQLServerCentral.com | Category: administration

Rating:

|

Discuss |

Briefcase | 2,149 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,332 reads

Column Level Permissions

GRANT Column Level Permissions Read more...

By Mani Singh | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,304 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 0001/01/01 | Source: SQLServerCentral.com | Category: search

Rating:

|

Discuss |

Briefcase | 4,519 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,128 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,402 reads