Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

usp_SecurCreation - SQL 2k5 Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2008 12:54 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 7, 2012 9:04 AM
Points: 84, Visits: 144
Comments posted to this topic are about the item usp_SecurCreation - SQL 2k5
Post #504762
Posted Thursday, June 5, 2008 2:15 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 17, 2014 11:23 AM
Points: 1,019, Visits: 446
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
Posted Wednesday, June 11, 2008 3:13 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 7, 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
Posted Wednesday, June 11, 2008 7:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, October 17, 2014 11:23 AM
Points: 1,019, Visits: 446
Absolutely Pedro!

- Tim Ford, SQL Server MVP
http://www.sqlcruise.com
http://www.thesqlagentman.com
http://www.linkedin.com/in/timothyford
Post #515177
Posted Friday, December 18, 2009 11:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Saturday, December 19, 2009 3:58 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 7, 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
Posted Wednesday, June 2, 2010 8:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, November 15, 2013 6:05 AM
Points: 1, Visits: 63
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
Posted Thursday, June 3, 2010 1:05 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, June 7, 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.
Post #932358
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse