usp_SecurCreation - SQL 2k5

Question

usp_SecurCreation - SQL 2k5

Pedro Lopes MS

SSChasing Mays

Points: 612
More actions
May 21, 2008 at 12:54 pm

#380654

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

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

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

sqlagentman SSCarpal Tunnel Points: 4484 More actions · Answer 1

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 More actions · Answer 2

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 More actions · Answer 3

Absolutely Pedro!

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

enzoferrari Grasshopper Points: 15 More actions · Answer 4

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 More actions · Answer 5

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

jmusy Grasshopper Points: 17 More actions · Answer 6

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 More actions · Answer 7

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