Error: Incorrect syntax near ')'.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Error: Incorrect syntax near ')'.

Author

Topic

rtutus
Aged Yak Warrior

522 Posts

Posted - 2007-03-03 : 21:41:07

I get this error:
Server: Msg 102, Level 15, State 1, Line 62
Incorrect syntax near ')'.
Here is the request that I put inside my cursor:

exec ('sp_grantdbaccess @loginame=' + @newLoginParam )
set @sqlGrant='grant update on mosaikdb741.dbo.loginlistInput to ' + @newLoginParam
EXEC (@sqlGrant)
Is there any thing wrong?
thank you

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-03-03 : 22:17:19

[code]
exec ('sp_grantdbaccess @loginame=''' + @newLoginParam + '''')
set @sqlGrant='grant update on mosaikdb741.dbo.loginlistInput to ''' + @newLoginParam + ''''
EXEC (@sqlGrant)
[/code]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources