[posted and mailed, please reply in news]

Mist in the night (mistinthenight@hotmail.com) writes:
> 1. Is it normal not to see the scheduled tasks when logged as
> another user than the sa or the owner of the tasks ? If it isn't, then
> something went wrong copying the DATA directory (even if SQL didn't mark
> them as suspect). Any advise or comment about this would be really
> welcome.

I did a test, and indeed as a plain user I was not able to see the
scheduled task as sa.

> 2. If it's normal not to see the scheduled tasks, Is there any way
> to recover the lost sa password ? The docs containing the password were
> lost around 4 years ago.

I assume that the server is not configured for Windows Authentication?
But as long as you have Windows admin privilege on the box, this can be
arranged. Go the registry, and find
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters.
Change LoginMode from 0 to 1. Restart SQL Server.

Now you can connect with Windows Authentication. If you are logged on to
Windows with admin privs, you will be connected as sa. Once there, you
can change the sa password to whatever you like.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp