<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Alejandro Pelc
»
List all permission in all databases
12 posts, Page 1 of 2
1
2
»»
List all permission in all databases
Rate Topic
Display Mode
Topic Options
Author
Message
Ale Pelc
Ale Pelc
Posted Sunday, March 15, 2009 6:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 10:59 AM
Points: 1,109,
Visits: 523
Comments posted to this topic are about the item
List all permission in all databases
Alejandro Pelc
Post #676084
hmbtx
hmbtx
Posted Thursday, April 16, 2009 9:19 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Thursday, June 13, 2013 9:12 AM
Points: 145,
Visits: 716
I get the following sql error message when running the script in SQL Server 2000 Query Analyzer or 2005 SQL Server Management Studio Express.
Server: Msg 197, Level 15, State 1, Line 64
EXECUTE cannot be used as a source when inserting into a table variable.
Thanks,
Howard
Post #698579
Glynne Smith
Glynne Smith
Posted Thursday, April 16, 2009 1:12 PM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Wednesday, January 12, 2011 8:28 AM
Points: 162,
Visits: 180
The script is only for SQL 2005...
Post #698808
ken.trock
ken.trock
Posted Thursday, April 16, 2009 2:48 PM
Old Hand
Group: General Forum Members
Last Login: Tuesday, June 11, 2013 1:49 PM
Points: 315,
Visits: 1,364
I made a slight change in mine to take into account an Offline DB:
insert into @dbs
select name from sys.databases
where state_desc <> 'offline'
order by name
Ken
Post #698914
J-983369
J-983369
Posted Thursday, April 30, 2009 5:25 AM
Grasshopper
Group: General Forum Members
Last Login: Thursday, December 10, 2009 1:50 AM
Points: 19,
Visits: 132
Hi,
Sorry I'm new to sql server 2005 and coding is not my strongest point. Can you please point me to exactly which line that I will need to change if I want to run this script for a specific db?
Thanks
J
Post #707577
Ale Pelc
Ale Pelc
Posted Thursday, April 30, 2009 5:37 AM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 10:59 AM
Points: 1,109,
Visits: 523
Hi there,
the simplest way is replacing this line
insert into @dbs
select name from sys.databases order by name
with this one
insert into @dbs
values ('
Name_of_DB
')
The nicest way will be removing the whole loop, but if you want to all DBs in the future, then you should add the loop again
cheers
Alejandro Pelc
Post #707583
jensbjpersson
jensbjpersson
Posted Friday, October 02, 2009 4:52 AM
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:58 PM
Points: 3,
Visits: 12
Thx for a nice script without errors
Keep up the good work, mate!
Post #796814
cutiekatrinakaif
cutiekatrinakaif
Posted Thursday, December 10, 2009 11:31 PM
Forum Newbie
Group: General Forum Members
Last Login: Monday, June 07, 2010 3:34 AM
Points: 1,
Visits: 5
Hi Everyone,
I am new to scripting and I want to fetch the security information on a wide set of servers and databases including Production environment. Could you please confirm if this script creates the three variables permanently or are they meant to be temporary variables?
Many thanks in advance
Katrina
Post #832735
Tom Powell-334692
Tom Powell-334692
Posted Wednesday, May 18, 2011 9:21 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:36 PM
Points: 20,
Visits: 86
Very nice, thanks. I forwarded to my team.
Tom Powell
http://philergia.wordpress.com/
Post #1111091
deanroush
deanroush
Posted Wednesday, May 18, 2011 9:24 AM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, May 02, 2013 9:10 PM
Points: 26,
Visits: 263
Katrina, these variables were meant to be temporary.
Post #1111093
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
