Viewing 15 posts - 1,786 through 1,800 (of 2,387 total)
Here is the KB for manually uninstall SQL Server.
http://support.microsoft.com/default.aspx?scid=kb;en-us;290991
May 21, 2003 at 12:33 pm
You should remove the files in the filegroup and then remove the filegroup. Make sure the files you are removing are empty.
May 21, 2003 at 12:27 pm
Run sp_who2 to see who is blocking your backup.
Dormant is same as Sleeping, except Dormant also indicates that the SPID has been reset after completing an RPC event. The...
May 21, 2003 at 12:07 pm
Did you change the fill factor when rebuilt the indexes?
May 21, 2003 at 12:03 pm
See following KBs helps.
http://support.microsoft.com/default.aspx?scid=kb;en-us;316989
http://support.microsoft.com/default.aspx?scid=kb;en-us;815154
May 21, 2003 at 8:51 am
quote:
One thing I do recall is that some things would not work until we installed the SQL 2000 client tools on workstations,...
May 21, 2003 at 7:41 am
Are you calling the SP from ASP or anything else?
Have you grant 'NT AUTHORITY\ANONYMOUS LOGON' access SQL Server with proper permissions to tables in instance PROD1?
May 21, 2003 at 6:47 am
Are there unique index exists on remote tables in ORACLE?
Each Oracle instance has its own set of services installed. You will know which one is running by verify the...
May 20, 2003 at 11:55 am
From tools --> Add-Ins --> Linked Table Manager --> select tables you want to refresh.
May 20, 2003 at 8:43 am
gts31 was not only upgrade MDAC, but also installed SQL Server 2000 client tools that is used by DTS in his machine too.
Higher version of MDAC is supposed to be...
May 20, 2003 at 8:39 am
Frank,
You don't have to drop the linked table, Just refresh it.
May 20, 2003 at 8:16 am
I think your unstanding about Implicit transactions is correct.
From BOL.
"Implicit transactions
A new transaction is implicitly started when the prior transaction completes, but each transaction is explicitly completed with a COMMIT...
May 16, 2003 at 6:22 pm
Can you connect to named instance from QA? What is your SQL Server service pack level?
Could it be caused by your machine name (PC-124405\CKDB) that has dash in it.
I have...
May 16, 2003 at 2:21 pm
It works for me. My server is Microsoft SQL Server 7.00 - 7.00.1077. Could it be issue of service pack/patch level?
May 16, 2003 at 2:04 pm
See following link for how to transfer DTS packages between servers.
http://www.sqldts.com/default.aspx?6,105,204,0,1
In term of jobs, you can script them from EM and recreate them in your new server.
May 16, 2003 at 7:25 am
Viewing 15 posts - 1,786 through 1,800 (of 2,387 total)