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
 Old Forums
 CLOSED - General SQL Server
 installing sql server 2000 sp4

Author  Topic 

sql_wedge
Starting Member

18 Posts

Posted - 2005-09-21 : 10:10:06
HI

I am just about to try install sp4 on sql server.How can I go about making sure that noone tries to connect while I do the install.

Dont worry it is on a test server(a live test server though)

thanks

mr_mist
Grunnio

1870 Posts

Posted - 2005-09-21 : 10:35:18
You could tell people not to, or disconnect the machine from the network.

-------
Moo. :)
Go to Top of Page

sql_wedge
Starting Member

18 Posts

Posted - 2005-09-21 : 10:55:59
what about single user mode?
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-09-21 : 12:14:06
single user mode could be problematic because sometimes someone else can slide in there as the sinlge user instead of you.




-ec
Go to Top of Page

sql_wedge
Starting Member

18 Posts

Posted - 2005-09-21 : 13:00:40
I have tried to run sp4 and I get the following error :"error running script replsys.sql"
Any ideas?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-09-21 : 13:10:42
quote:
Originally posted by sql_wedge

I have tried to run sp4 and I get the following error :"error running script replsys.sql"
Any ideas?



Reboot and rerun setup.

Tara
Go to Top of Page
   

- Advertisement -