Thanks Joe - great suggestions!!!

Glenn

Thanks all for the great responses (I can always count on this group).

After trying some of the canned apps (which worked well - but don't provide all of what I'm...

Already considered this...

As I mentioned we can't take the chance that some/all of the databases/applications would fail. So, we're in a go slow mode. - I wish things could be...

OK thanks!

I figured that it wouldn't be too straight forward. And yes... we do have alot of 3rd party apps (I know of several which do use SQL Authentication).

Do you...

What are the potential implications of switching from Mixed Mode authentication to Windows Authentication?

I would much prefer to go the windows route but all of the SQL instances support very...

Thanks so much!!!

As always the site and its members really come through. For us newbie DBAs this is a great resource.

Glenn

Well, that was easy!!!

After a bit more reading I decided to try the Detach/Attach method.

Since the named instance was on the same...

Yes, sorry - this is another named instance of SQL Server on the same box.

Yes, apparently in all of the chaos of her PC popping-up ads, etc instead of updating the record, as she had indicated, she had actually deleted the record.

She was...

Thanks all. The issue has been handled.

I restored a copy of the database to a checkpoint prior to the problem. After restoring the db I pointed a copy of the...

Thanks for the confirmation Allen. I suspected that to be the case but when she indicated that the vendor thought that it should present no problem I thought that maybe...

Thanks alt.Steve (I had wondered about that). Fortunately, the database did finally restore and has been deleted and the offending IT individual has been catigated... all-in-all a satisfying day!

Thanks again.

Glenn

Thanks Steve. I had thought of going in to Master and delete the sysdatabases entry but I was concerned that there are other entries elsewhere (i.e. MSDB jobs, etc) that...