Syntax error at function keyword while importing

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

Import/Export (DTS) and Replication (2000)

Syntax error at function keyword while importing

Author

Topic

Maliniksh
Starting Member

8 Posts

Posted - 2003-11-11 : 01:08:37

I have created script file for exporting user defined functions from one of the SQL Server database and exectued at MSDE 2000 sql server version at our clients place to copy to their MSDE 2000 sql server database.
Our clients are using German language operating system.And they are getting error when they execute this script file at command prompt saying that " false syntax near 'function' keyword. But in our sql server environment (not MSDE 2000) it is working fine.please help me why this error is occuring.create function syntax is correctly given.
The script file contains the following code :
==============================================================
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_AktEinzelrechnung11]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_AktEinzelrechnung11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_KundeEinzelrechnung11]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_KundeEinzelrechnung11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_KundeSammelrechnung11]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_KundeSammelrechnung11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_Mietvertrag11]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_Mietvertrag11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_Mietvertrag12]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_Mietvertrag12]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_ProjEinzelrechnung11]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_ProjEinzelrechnung11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_ProjSammelrechnung11]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_ProjSammelrechnung11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_Rechnung11]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_Rechnung11]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[qry_Uebersicht01]') and xtype in (N'FN', N'IF', N'TF'))
drop Function [dbo].[qry_Uebersicht01]
GO

==============================================================

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2003-11-11 : 02:28:02

You dont have to cross post: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=30462

Owais

Where there's a will, I want to be in it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources