usp_SecurCreation

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Pedro Lopes » usp_SecurCreation - SQL 2k5

usp_SecurCreation - SQL 2k5

Rate Topic

Display Mode

Topic Options

Author

Message

Pedro Lopes MS

Posted Wednesday, May 21, 2008 12:54 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 07, 2012 9:04 AM
Points: 84, Visits: 144

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

Post #504762

Timothy Ford-473880

Posted Thursday, June 05, 2008 2:15 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 9:07 AM
Points: 1,004, Visits: 424

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 MVP
http://www.sqlcruise.com
http://www.thesqlagentman.com
http://www.linkedin.com/in/timothyford

Post #512484

Pedro Lopes MS

Posted Wednesday, June 11, 2008 3:13 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 07, 2012 9:04 AM
Points: 84, Visits: 144

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

Post #515021

Timothy Ford-473880

Posted Wednesday, June 11, 2008 7:47 AM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 9:07 AM
Points: 1,004, Visits: 424

Absolutely Pedro!

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

Post #515177

enzoferrari

Posted Friday, December 18, 2009 11:02 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, December 18, 2009 10:59 AM
Points: 1, Visits: 2

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.

Post #836512

Pedro Lopes MS

Posted Saturday, December 19, 2009 3:58 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 07, 2012 9:04 AM
Points: 84, Visits: 144

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

Post #836851

jmusy

Posted Wednesday, June 02, 2010 8:25 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 01, 2013 8:59 AM
Points: 1, Visits: 58

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

Post #931395

Pedro Lopes MS

Posted Thursday, June 03, 2010 1:05 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 07, 2012 9:04 AM
Points: 84, Visits: 144

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

Post #932358

« Prev Topic | Next Topic »

Permissions