BOT,

Thanks for your reply; we were not prompted by the SP 3 installation whether we wanted to do the post installation steps, it just did them. Strange error we...

ksharma,

Hello, I followed your advice and came up with the following :

select * from sys.database_principals where

Hello,

Thank you for the response.  Can you point me to where the sys.database_principals table exists ?  I can not seem to located it in the master, msdb, or any other...

Scott,

Dude, thanks for the informative response. I was checking the Microsoft site and could not find the answer in the online product documentation.

Hope you have a great weekend !

Don

Good Day,

I want to thank you all for the excellent responses.  They have all helped me a great deal. This is by far the best Sql Server bulletin board in...

Hello,

Have you tried executing DBCC to check for consistency errors ?

Something like this :

In SQL Query Analyzer:

a) place database in single-user mode

exec sp_dboption dbname,'single user',true

b) repair database

DBCC CHECKDB...

Greg,

Thank you for sharing your thoughts.  I certainly appreciate your input.  I thought the Clustered configuration was desirable but just checking to see what other folks thought about it.

Good day

Don

Steve,

Thanks for input I think you answered my question. Everything attempted fails and now I believe it's related to a problem with the version od Sql Server 2000 I...

quote:

---

From the Enterprise Manager, selct the database desired, click on Tools, then Generate SQL Scripts. You will see from there.

---