Error in SQL startup

Hi guys,

I have an SQL Server 2000 installed on a Windows server 2003. Yesterday, i restart my server and before login to the server the following message poped-up:

"Your SQL Server installation is either corrupt or has been tampered with (unable to load SQLBOOT.DLL). Please uninstall, then re-run setup to correct this problem"

Any ideas what this error is or why occurred?
Any help will be appreciated.

have u checked the sqllog and application log.. post the error from Log. its looks like the REGISTRY/system drive got corrupted/ or master file corrupted... what all are the backup u have. Do u have system dbs backups ?...

Madhu

|||

There are no errors in the event viewer regarding the error i tild you above. There is only the 19012 error which has to do something with the TCP port.

Any other ideas what this error should be?

|||Please post the sql log here. It would help us help you pinpoint the problem. The sqlboot error simply means the service doesn't get all the resources it needs to start up. A re-install typically will fix this.|||

generally this might be the log file path. C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG . Open the ERRORLOG file and paste the contents here

Madhu

Error Handling not workinh after select a bad table

Hi guys,
I have a SP that is executing a simple task, and I=B4m forcing an error,
but the SQL Server is not catching the error, please help me.
The code is:
insert into table1
select * from table2_bad
print @.@.error
Notes:
The table2_bad is not valid in the database, so the sql show an error
saying that the table isnt create of something... but the variable
@.@.error isnt filled.=20
Do you know why'
Thanks!Answered in .programming. Please do not post the same message independently
to multiple newsgroups.

Error Handling not workinh after select a bad table

Hi guys,
I have a SP that is executing a simple task, and I=B4m forcing an error,
but the SQL Server is not catching the error, please help me.
The code is:
insert into table1
select * from table2_bad
print @.@.error
Notes:
The table2_bad is not valid in the database, so the sql show an error
saying that the table isnt create of something... but the variable
@.@.error isnt filled. Do you know why'
Thanks!Answered in .programming. Please do not post the same message independently
to multiple newsgroups.