Keyword syntax error

From: "ying" <ying@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 25 May 2005 11:51:07 -0700

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

.

Prev by Date: Excluding weekend dates from calculated data pull
Next by Date: Re: Excluding weekend dates from calculated data pull
Previous by thread: Excluding weekend dates from calculated data pull
Next by thread: Query Question
Index(es):
- Date
- Thread

Relevant Pages

Linked Server connection Problem
... I had a Linked Server to an Access 2000 database which had worked for two ... Hoever, now when I execute queries againt it in Query Anayler, e.g. ... No error messages in QA. ...
(microsoft.public.sqlserver.security)
Re: Oracle linked server error
... Set Up and Troubleshoot a Linked Server to Oracle in SQL Server ... >> The only error messages I have been able to get is by running the t-sql ...
(microsoft.public.sqlserver.connect)
Re: Linked DB2/400
... I have never done this myself, but if the linked server has no setup ... some data to that table from your trigger. ... then your error messages may be instructive. ...
(microsoft.public.sqlserver.connect)