Category Archives: Dynamic SQL

  1. Using sp_DBPermissions and sp_SrvPermissions v6.0

    1

    February 25, 2015 by Kenneth Fisher

    It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
    Continue reading

  2. Generating a restore script

    8

    August 18, 2014 by Kenneth Fisher

    In order to speed up our backups on a large database our team decided to stripe the backup files. In …
    Continue reading

  3. sp_SrvPermissions & sp_DBPermissions V5.0

    2

    June 23, 2014 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures …
    Continue reading

  4. sp_SrvPermissions & sp_DBPermissions V4.0

    Leave a comment

    January 15, 2014 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
    Continue reading

  5. sp_SrvPermissions & sp_DBPermissions V3.0

    Leave a comment

    November 4, 2013 by Kenneth Fisher

    These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data …
    Continue reading

  6. sp_DBPermissions V2.0

    1

    September 18, 2013 by Kenneth Fisher

    Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
    Continue reading

  7. sp_SrvPermissions V2.0

    1

    September 18, 2013 by Kenneth Fisher

    Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
    Continue reading

  8. sp_SrvPermissions

    Leave a comment

    August 19, 2013 by Kenneth Fisher

    Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
    Continue reading

  9. sp_DBPermissions

    3

    August 14, 2013 by Kenneth Fisher

    Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last …
    Continue reading

  10. Database Permissions Queries

    3

    August 5, 2013 by Kenneth Fisher

    Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,223 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,223 other followers