Getting Error on Syntax | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Getting Error on Syntax

Hi, I am getting following error messages when I am parsing a new sp based on sys.sp_addrolemember code: /*——————–Error Message Start——————–
Msg 102, Level 15, State 1, Procedure sp_myaddrolemember, Line 25
Incorrect syntax near ‘%’.
Msg 102, Level 15, State 1, Procedure sp_myaddrolemember, Line 61
Incorrect syntax near ‘%’.
Msg 102, Level 15, State 1, Procedure sp_myaddrolemember, Line 99
Incorrect syntax near ‘%’.——————–Error Message End——————–*/
The sql 2005 sp is using following syntax on which I am getting syntax error messages:
1. EXEC %%Owner(Name = @rolename).Lock(Exclusive = 0)
2. EXEC %%Owner(Name = @membername).Lock(Exclusive = 1) — may fail
3. EXEC %%Owner(Name = @membername).SetRoleMember(RoleID = @roluid, IsMember = 1) PS: I am trying to retrofit my requirements in existing 2005 sp_addrolemember. Help in this regard would be higly appreciated. Thanks S. M. Abbas
I didn’t understand your requirment.
are you using sp_myaddrolemember? —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
What is "EXEC %%Owner" ? Roji. P. Thomas
SQL Server MVP
http://toponewithties.blogspot.com
]]>