New to a company with a lot of skeletons. Seems previous administration was poor at documentation. Actually i think they purposely failed to document things because of fear of loosing their jobs. lol
Here is the situation. We have a particular website hosting a database that has table with millions of lines in it. The data lives on a sql 2000 database and no one in the company has the SA password. We have talked to nearly everyone who has ever touched the database on this particular server and have had no luck at all.
The reason for needing the SA password is because we are trying to export the data to a newer more up to date sql server. We can do this via the command line in the sql 2000 but only with the sa account credentials.
Please help me extract my valued data. I am positive their is a way to get the SA account password because i spend most of my day trying to prevent these kinds of things from attacking my sa accounts in the firewall.
Last resort admin
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008