In order to call SPs in another instance, you have to setup either linked server or remote server and use four-part names in your SPs.

You may consider to use Dynamic...

Mmeory leak may also be caused by otehr components such as SQL mail, Full-text search, Extend Stored Procedures and OLE DB provider etc.

Do you see any error messages like...

Use sp_attach_single_file_db only on databases that have a single log file. Do not use this stored procedure on databases that have multiple log files.

But you can use DBCC Shrinkfile with...

Check SQL Server errorlog to see whether you have an entry "SQL server listening on TCP, Shared Memory, Named Pipes.".

Select * from sysprocesses to verify which protocol your users connect...

Can you please post your stored procedure here ? Make sure you connect to the correct instance from QA and the database is in this instance to run the sp.

Edited...

Which version of SQL Server and service pack you are running?

This KB should answer your question.

http://support.microsoft.com/default.aspx?scid=kb;en-us;328383

Can you post the error messages here? Make sure all SQL Server resources are online from Cluster Administrator.

What service account SQL Server and Agent services run? Has 'BUILTIN\Administrators' login been...

You don't have other options beside eithrt BCP or DTS in and out in SQL Server 7.0.

SQL Server 2000 allows databases having different collation under one instance.

Try this.

delete t1

from test1 t1

join

(select userid, mlsnum, max(savedid) as sid

from test1

group by userid, mlsnum

having count(*)>1) as t2

on t1.userid = t2.userid

and t1.mlsnum =...

Have you tried use sp_attach_single_file_db?

quote:

---

It seems that when we fail over to the second node full text functionality breaks.

---