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
 SQL Server Development (2000)
 Extended procedure registration problem

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-02-23 : 09:09:24
Sergei writes "Hi,

I have a problem with registration of the extended stored procedure. I have 2 SQL2000 instances at Windows 2003 server and triued to register an extended procedure by:

exec sp_addextendedproc N'xp_sqllitespeed_version', N'C:\Program Files\dbassociates\sqllitespeed\Engine\xpSQLLiteSpeed.3.0.123.4.DLL'

This script registered the procedure at one instance and faild at other with error:

Server: Msg 2714, Level 16, State 7, Line 1
There is already an object named 'xp_sqllitespeed_version' in the database.

There is no 'xp_sqllitespeed_version' objects in master..sysobjects table at this instance. I received this
error even I changed a procedure name in thous script.

Any help is very appreciated!!!

Thanks"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-02-23 : 12:47:19
So you are installing SQL Litespeed I suppose when you get this error? Have you contacted the vendor to see why you are getting the error? Has the product ever been installed on this server before? If so, did it uninstall completely?

I have successfully installed the product on 3 servers now without any errors.

Tara
Go to Top of Page
   

- Advertisement -