all groups > sql server msde > march 2005 >
You're in the

sql server msde

group:

What is this Error!


What is this Error! Tanveer Malik
3/28/2005 9:34:16 AM
sql server msde:
I am using MSDE2000 on my local machine.

I have a Script generated by MS SQL Server 2000 when I try to execute it on
my local machine having MSDE2000 installed on it - by using MSDE Manager by
Vale - I continuously receive errors like
Though I have Set 'GO' as Command Terminator in the Server Settings.

Error -2147221334
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 4: Incorrect syntax near
'GO'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near
'GO'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 10: Incorrect syntax
near 'GO'

The part of the Script follows this line ..
use nFAR
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_NULLS ON
GO

Re: What is this Error! Andrea Montanari
3/28/2005 12:31:38 PM
hi,
[quoted text, click to view]

I do not know how Vale Software MSDE Manager handles that (and perhaps you
have better to ask them), as GO is not a SQL Server keyword but just a batch
terminator recognized by some (actually quiet all) tools and should be
handled separating the whole batch in several statements executions...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Re: What is this Error! Greg Low [MVP]
3/29/2005 11:25:55 PM
Hi Tanveer Malik,

In addition to what Andrea said, if you don't get anywhere with that, we
have a product called MSDE Manager as well that is free for personal use.
Details at our site. Enjoy.

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

[quoted text, click to view]

AddThis Social Bookmark Button