usp_SecurCreation - SQL 2k5

  • Pedro Lopes MS

    SSChasing Mays

    Points: 612

    Comments posted to this topic are about the item usp_SecurCreation - SQL 2k5

  • sqlagentman

    SSCarpal Tunnel

    Points: 4484

    Pedro, I am writing an article on the steps to prepare for rebuilding the master database and I'd like to cite your script for the securables creation process. If I include your code as-is with your credit acknowledgement embedded within it, along with a reference to this article would you allow it?

    Thank you.

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

  • Pedro Lopes MS

    SSChasing Mays

    Points: 612

    Hello, sorry for the delay.

    Go right ahead, providing you give proper credit. Also, could you send me a link to that article when it's done?

    Thank you

    PL

  • sqlagentman

    SSCarpal Tunnel

    Points: 4484

    Absolutely Pedro!

    - Tim Ford, SQL Server MVPhttp://www.sqlcruise.comhttp://www.thesqlagentman.com http://www.linkedin.com/in/timothyford

  • enzoferrari

    Grasshopper

    Points: 15

    Stupid question. I ran the query, and it was successful but what do I do now? I don't see any output tables or anything to use on the new build. In other words, how or what do I run on the new SQL server to import the security information (logins) and all their rights?

    Thanks.

  • Pedro Lopes MS

    SSChasing Mays

    Points: 612

    Run it in query analyzer, or management studio, and browse over to the "messages" tab. Ther you have the DDL.

  • jmusy

    Grasshopper

    Points: 17

    Hello When I try to create the procedure,

    I receive the error message :

    Msg 102, Level 15, State 1, Procedure usp_SecurCreation, Line 96

    Incorrect syntax near '@SCDB'.

    Msg 102, Level 15, State 1, Procedure usp_SecurCreation, Line 134

    Incorrect syntax near '@SCDB'.

    This correspond to the code

    INSERT INTO #TempSecurables2

    EXEC master..sp_executesql (@SCDB)

    May I ask you some help ?

    Thanks

  • Pedro Lopes MS

    SSChasing Mays

    Points: 612

    Hi! Thanks for the info. Just had to remove the parenthesis on both sp_executesql statements. I've uploaded the correction.

    Let me know if you'te all set. 🙂

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply