MS SQL Server MSEQ - Keyword syntax error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Keyword syntax error

ying

2005-05-25, 8:24 pm

I have a query like follows:
update [server].[database].dbo.table
set [group]=3
the server is a linked server to my current database. Error messages are:
Statement(s) could not be prepared.
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'group'.

Anyone know how to fix it or how to work around it?

By the way the query
update table
set [group]=3
works ok.

Thanks

Sponsored Links