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 12»»

The Complete SQL Server 2005 Permissions Report Expand / Collapse
Author
Message
Posted Friday, July 17, 2009 2:14 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, June 10, 2011 2:04 PM
Points: 65, Visits: 67
Comments posted to this topic are about the item The Complete SQL Server 2005 Permissions Report
Post #755137
Posted Monday, August 3, 2009 12:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:03 PM
Points: 363, Visits: 784
Thanks! This is great. Do you have a version that is compatible with SQL 2008?

Adam Durr
Remote DBA support
www.bluegecko.net
Post #763911
Posted Monday, August 3, 2009 5:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 1, 2014 3:16 AM
Points: 9, Visits: 184
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
Post #763982
Posted Monday, August 3, 2009 6:32 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 6:46 AM
Points: 77, Visits: 436
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
Post #764004
Posted Monday, August 3, 2009 7:25 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 9, 2013 3:52 PM
Points: 430, 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.
Post #764043
Posted Monday, August 3, 2009 7:45 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 7:27 PM
Points: 202, Visits: 292
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



Post #764053
Posted Monday, August 3, 2009 8:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, October 14, 2009 10:25 AM
Points: 11, Visits: 21
This is cleaned up. Works great. Thanks for the great script.

Jon


  Post Attachments 
TheCompleteSQLServer2005PermissionsReport.sql.txt (98 views, 8.30 KB)
Post #764091
Posted Monday, August 3, 2009 8:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, October 21, 2014 7:27 PM
Points: 202, Visits: 292
Thank you very much it works!


Post #764102
Posted Monday, August 3, 2009 9:12 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, May 30, 2014 7:53 AM
Points: 33, Visits: 117
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.
Post #764135
Posted Monday, August 3, 2009 10:00 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 12:03 PM
Points: 363, Visits: 784
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
Post #764195
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse