I am not aware of any changes to the SA account. The standard for it here is assign it a 50+ character complex PW and forget about it. No one...

Ed, I do believe you are on to something, but I experienced the same problem with adding "Domain Admins" to the server with the SysAdmin role, the next day. I...

Hey, I remember that. I started administering SQL Server with that version. So, yes, I have used it, and every version after it.

If you have a question about it, I...

I am trying to get another server for working out this problem set up now. The original server where this problem exists is needed for an important project so I...

I see the job history just fine, it's the step results that ar emissing. In my job definition I have selected an output file, and have selected to include step...

nataliehinnen (4/29/2009)

---

Thanks for the replies so far.. I actually agree with including the db owner, but I work with a bunch of geeks who are afraid to "hard code" anything......

It sounds like you just need to set up alerts in SQL Server. These do what you describe in your posts.

Chris

For large files, I have found WinRAR to be a better option than Winzip. Perhaps it does now, but when I started needing this Winzip could not handle a file...

Semi-colon (;) between addresses will do it.

Chris

My solution for this, in the many cases I have run into in the past, is to restore the nightly backup of said DB to another DB on the same...

I agree. The server is likely trying to recover a database. Depending on what it is trying to recover from, uncommitted transactions or from corruption, and the size of the...

I always script the user from the Prod environment and run that script on the test or dev environment to copy the users then I never have to mess...

Who did you buy PGP from? Can they provide support? I have used "GPG" in the past for this sort of thing and have never encountered a problem. GPG is...

This is what's so mysifying about the situation. It rolled back, even though the script completed with no error messages, and the script had specific "Commit Tran" statements in it,...

After 2 hours, 53 minutes, the restore finally finished and now the transaction log is almost empty. Time for a shrinkfile.

The shrinkfile worked, on both data and log files. So...