Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The Complete SQL Server 2005 Permissions Report


The Complete SQL Server 2005 Permissions Report

Author
Message
Richard Lu-422582
Richard Lu-422582
SSC Journeyman
SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)SSC Journeyman (85 reputation)

Group: General Forum Members
Points: 85 Visits: 70
Comments posted to this topic are about the item The Complete SQL Server 2005 Permissions Report
Adam Durr
Adam Durr
Old Hand
Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)

Group: General Forum Members
Points: 397 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
nhaberl
nhaberl
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 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
William Soranno
William Soranno
SSC-Enthusiastic
SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)SSC-Enthusiastic (150 reputation)

Group: General Forum Members
Points: 150 Visits: 517
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
MelS-512196
MelS-512196
SSC-Addicted
SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)SSC-Addicted (446 reputation)

Group: General Forum Members
Points: 446 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.
odeddror
odeddror
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 369
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



jon.malenfant
jon.malenfant
Grasshopper
Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)Grasshopper (11 reputation)

Group: General Forum Members
Points: 11 Visits: 21
This is cleaned up. Works great. Thanks for the great script.

Jon
Attachments
odeddror
odeddror
SSC Veteran
SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)SSC Veteran (226 reputation)

Group: General Forum Members
Points: 226 Visits: 369
Thank you very much it works!



randal.schmidt
randal.schmidt
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 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.
Adam Durr
Adam Durr
Old Hand
Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)Old Hand (397 reputation)

Group: General Forum Members
Points: 397 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
Go


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.

Select a forum

































































































































































SQLServerCentral


Search