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 Administration (2000)
 Sqlserver 2000 Standard Edition Installation

Author  Topic 

valliyil
Starting Member

8 Posts

Posted - 2005-03-24 : 00:52:46
I Installed SQL Server 2000 Standard Edition on Windows 2003 server Operating System. Also run the Service pack 3a.
question 1 :- I can't able to run the sqlserver on single user mode using sqlservr -m. showing this error...

2005-03-24 07:42:56.40 server initerrlog: could not open error log file 'd:\MSSQL\log\ERRORLOG'. operating system error = 32 <The process cannot access the file because it is being used by another process.>.


question 2 :- When I tried to see the version of sqlserver using select @@version, In the result I am not getting which service pack is installed. only showing below in result pan

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: )

please help me in this question.
   

- Advertisement -