Tag Archives: dynamic sql

  1. 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

  2. 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

  3. sp_DBPermissions


    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

  4. Generic Dynamic SQL Stored Procedure


    July 22, 2013 by Kenneth Fisher

    Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle …
    Continue reading

  5. Writing Dynamic SQL (A how to)


    July 1, 2013 by Kenneth Fisher

    A little while back I wrote Best practice recommendations for writing Dynamic SQL where I made a number of suggestions …
    Continue reading

  6. Best practice recommendations for writing Dynamic SQL


    June 12, 2013 by Kenneth Fisher

    Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
    Continue reading

  7. Backup a password, change it, then restore it.


    May 30, 2013 by Kenneth Fisher

    A couple of months ago I talked about moving a login from one server to another without the password. The …
    Continue reading

  8. How do I use a variable in an IN clause?


    April 8, 2013 by Kenneth Fisher

    I see this question in one form or another a lot. I’ve seen this or something like it probably half …
    Continue reading



    February 25, 2013 by Kenneth Fisher

    When writing a script to change a piece of code, say a stored procedure or view, there are 3 basic …
    Continue reading

  10. Generating multiple SQL statements from a query


    December 17, 2012 by Kenneth Fisher

    Dynamic SQL is one of my favorite tools in the DBA toolbox. I’m big on automation and dynamic SQL can …
    Continue reading

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

Join 3,515 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013