IF SA password is forgotten or lost 1

[itsmeyogi]

Hey,
What would happen if the SA password is lost and no others users exist or don't have sys admin rights?

how do i retreive the password? THe enterprise manager doesn't work as its configured with the old password.

Thanx
yogitha

 

[tlbroadbent]

Check here...

http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14150

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[carrr]

Good info, Terry. This one goes in the file.

 

[itsmeyogi]

How do i rebuild master and reattach User databases.

 

[tlbroadbent]

The information for rebuilding master and attaching user databases is available in SQL Books Online and at the following link.

http://msdn.microsoft.com/library/en-us/adminsql/ad_bkprst_0cvm.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.