I am running into the same problem rdann is having. all of a sudden the company wants to secure the sa login.

Brian you suggested using SQL Profiler....

Have you tried:

sp_changedbowner 'sa'

If memory serves me right - I think there is an issue with using 'sa" with add user type stored proc

karen

We reinstalled SQL again and she seems to be OK. If problem continues I will follow your suggestions Jim

Thanks

Karen

Thanks for your reply gentlemen.

We are using TCPIP, dynamically determining the port and the program is not stopping at the same spot. But heres the weird stuff. Its...

I did apply the fix but it did not help me. I thought it would because my computer name has small and upper case letters along with a...

I had the same problem, still do as a matter of fact. I rec'd the same error and MS Support returned the following. Did not fix my problem....

Andy

leave it to me to get it backwards but here is what happened!

To make a long story short I have DEV server and a Production...

If you are using SQL backup In Ent Mgr - right click the database - all tasks - restore database

you will get a list of the backups and...

Thanks Steve

Ill try and see what happens

karen

Im pretty sure it looks at last back up then deltes anything 2 weeks older

karen

I use EM 2000 all the time and delete old backups after a few days - there is a check off box in the Complete DB and Tran Log...

I mainly use EM mainenance for backups, db daily and log every hour 8 am - 8pm.- optimizations and intergirty checks on all Db at least once a week....