The Complete SQL Server 2005 Permissions Report

Author	Message
Richard Lu-422582	Richard Lu-422582 Posted 8 years ago #755137
SSC-Enthusiastic Group: General Forum Members Points: 113 Visits: 70	Comments posted to this topic are about the item The Complete SQL Server 2005 Permissions Report 2
	Quote
Adam Durr	Adam Durr Posted 8 years ago #763911
Mr or Mrs. 500 Group: General Forum Members Points: 553 Visits: 884	Thanks! This is great. Do you have a version that is compatible with SQL 2008? Adam Durr Remote DBA support www.bluegecko.net 2
	Quote
nhaberl	nhaberl Posted 8 years ago #763982
SSC Rookie Group: General Forum Members Points: 47 Visits: 244	Hello! I'm using SQL Server 2005 Standard and the script is not running. Always get a syntax error on the first select statement. Any suggestions? I can't find any error... beste regards Norbert 2
	Quote
William Soranno	William Soranno Posted 8 years ago #764004
Old Hand Group: General Forum Members Points: 328 Visits: 519	I am using SQL Server 2005 Enterprise Edition (x64) and getting the following errors: Msg 102, Level 15, State 1, Line 11 Incorrect syntax near ' '. Msg 102, Level 15, State 1, Line 41 Incorrect syntax near ' '. Msg 102, Level 15, State 1, Line 68 Incorrect syntax near ' '. Msg 102, Level 15, State 1, Line 74 Incorrect syntax near ' '. Msg 102, Level 15, State 1, Line 85 Incorrect syntax near ' '. Msg 137, Level 15, State 2, Line 90 Must declare the scalar variable "@CurrentDB". Msg 137, Level 15, State 2, Line 96 Must declare the scalar variable "@CurrentDB". Msg 137, Level 15, State 2, Line 131 Must declare the scalar variable "@SQLCmd". Msg 137, Level 15, State 2, Line 133 Must declare the scalar variable "@CurrentDB". Msg 102, Level 15, State 1, Line 141 Incorrect syntax near ' '. RedGate SQLPrompt reports an error starting on line 32 ( as copied directly from the post): r.is_disabled, Bill Soranno MCP, MCTS, MCITP DBA Database Administrator Winona State University Maxwell 143 "Quality, like Success, is a Journey, not a Destination" - William Soranno '92 2
	Quote
MelS-512196	MelS-512196 Posted 8 years ago #764043
Mr or Mrs. 500 Group: General Forum Members Points: 504 Visits: 448	If you copy the script from the web page into a SQL query it contains non-printing characters that Transact-SQL does not like. If you copy the script into notepad first, you will see the non-printing characters. To make the script runnable, you can use the find/replace function in notepad to replace the non-printing characters with an empty string. 2
	Quote
odeddror	odeddror Posted 8 years ago #764053
Old Hand Group: General Forum Members Points: 330 Visits: 382	Hi there, After copy and paste into notepad it still give me an syntax error Can you type it inside sql and attach it as a script no matter what I do it still give syntax error Thanks, Ed Dror 2
	Quote
jon.malenfant	jon.malenfant Posted 8 years ago #764091
Grasshopper Group: General Forum Members Points: 15 Visits: 21	This is cleaned up. Works great. Thanks for the great script. Jon Attachments TheCompleteSQLServer2005PermissionsReport.sql.txt (141 views, 8.00 KB) 2
	Quote
odeddror	odeddror Posted 8 years ago #764102
Old Hand Group: General Forum Members Points: 330 Visits: 382	Thank you very much it works! 1
	Quote
randal.schmidt	randal.schmidt Posted 8 years ago #764135
SSC-Enthusiastic Group: General Forum Members Points: 103 Visits: 120	I am getting a bunch of syntax errors: Msg 102, Level 15, State 1, Line 11 Incorrect syntax near ' '. Msg 102, Level 15, State 1, Line 41 Incorrect syntax near ' '. Msg 102, Level 15, State 1, Line 68 Incorrect syntax near ' '. Msg 102, Level 15, State 1, Line 74 Incorrect syntax near ' '. Msg 102, Level 15, State 1, Line 85 Incorrect syntax near ' '. Msg 137, Level 15, State 2, Line 90 Must declare the scalar variable "@CurrentDB". Msg 137, Level 15, State 2, Line 96 Must declare the scalar variable "@CurrentDB". Msg 137, Level 15, State 2, Line 131 Must declare the scalar variable "@SQLCmd". Msg 137, Level 15, State 2, Line 133 Must declare the scalar variable "@CurrentDB". Msg 102, Level 15, State 1, Line 141 Incorrect syntax near ' '. Any ideas? I have tried to clean up the script but still get errors. Thanks. 1
	Quote
Adam Durr	Adam Durr Posted 8 years ago #764195
Mr or Mrs. 500 Group: General Forum Members Points: 553 Visits: 884	Thanks for the help getting this script to work. It is not apparent immediately because you cannot see the extra spaces(blocks). You have to paste the script into notepad and then you can see the extra blocks at the beginning of each line. You also have to go to line 84 and add a space after @CurrentDB so the line looks like DECLARE @CurrentDB sysname Do this and the script works! Adam Durr Remote DBA support www.bluegecko.net 2
	Quote

Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.

You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.