dbTalk Databases Forums  

"'ServerProperty' is not a recognized function name" in SQL 7 DTS logs

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss "'ServerProperty' is not a recognized function name" in SQL 7 DTS logs in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
nugget
 
Posts: n/a

Default "'ServerProperty' is not a recognized function name" in SQL 7 DTS logs - 06-21-2005 , 08:57 AM






Hello:

We are running SQL Server 7 on a Server 2003 box. We just recently
noticed all of our DTS packages are failing with this error in the
scheduled job log:

DTSRun: Loading...
Error: -2147217900 (80040E14);
Provider Error: 195 (C3)
Error string: 'ServerProperty' is not a recognized function name.

Error source: Microsoft OLE DB Provider for SQL Server
Help file:
Help context: 0.
Process Exit Code 1.
The step failed.

The error itself makes sense as ServerProperty is a 2000-only function,
however why would this function even be called as its a SQL 7
installation?

We have recently attempted applying Service Pack 1 for Windows Server
2003. This process failed and the SP install was automatically rolled
back. Of course, this is certainly a possibility for the behavior, but
does anyone know how to fix it?

--
Many thanks,
Chris Simmons
newsgroup.replies (AT) netchris (DOT) com


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.