Viewing 15 posts - 916 through 930 (of 2,387 total)
quote:
In the Service Manager pop-up, set the server window for your server name, set the service to SQL Server. Down at...
October 30, 2003 at 7:03 am
The reason you have cluster is to have SQL Server available almost all the time. You don't have to shut down both servers at same time. Shuting down active server...
October 29, 2003 at 12:22 pm
Can you apply the sp2 to the destination server ?
October 29, 2003 at 11:30 am
It is Microsoft Data Access Component. Go to http://www.microsoft.com/data to have a look and you can download MDAC checker to verify the version of MDAC in both machine.
October 29, 2003 at 10:10 am
quote:
Microsoft says this: "SQL Server 2000 virtual servers do not have these restrictions; you can safely start and stop the services...
October 29, 2003 at 10:08 am
Check the time-out setting in SQL Server EM --> Tools --> Options --> Advanced Tab.
October 29, 2003 at 9:59 am
I would drop them at end of stored procedure using command "drop table #yourtemptablename".
Edited by - allen_cui on 10/29/2003 09:52:33 AM
October 29, 2003 at 9:52 am
quote:
Every Wednesday morning at 7:30 AM, our operator reboots the cluster. When it comes back up, she logs into WDBS and...
October 29, 2003 at 9:49 am
Which version both SQL Server run? Do they have same MDAC version?
October 29, 2003 at 9:44 am
After enabling /PAE and /3GB, There is only 1Gb left for OS. System has to allocate part of it to manage the memory beyond 4GB boundary. I am wondering similar...
October 29, 2003 at 8:10 am
No aware of it. SQL Server Agent will create new one once it is restarted.
October 29, 2003 at 7:28 am
Viewing 15 posts - 916 through 930 (of 2,387 total)