It was a vendor issue, they had files on the application server that has transactions written to it, those files needed to be deleted after removing all connections to the...

There are a ton of ways to setup backups in SSMS, and yes there is a clean up task that you can have execute at the end of the task...

The server, I knew at the time, only had at most 3 users on it doing stuff. And I had one of the end users on the phone.

I started...

I was looking for all transactions executed by the user getting the error. Not the old user that still has the lock in the server. No luck either way,...

Well I tried tracing the listed event categories, and got no results, so I traced every transaction on the server, if it could be checked marked I checked it. 🙂

I...

When you click on Remove you will be given the option to remove or repair.

Choose repair.

From what I am finding, it is a function that is attempting to decrypt some BLOB data. Only a user with the same credentials can decrypt the information. Also,...

I started a trace on the server, but I am unsure if I have it setup correctly.

Are there any good online tutorials that may help to point me in the...

Gila, I have no idea how the program traces its users, I just wanted to cover all my bases on the SQL Server side before opening a help desk ticket...

So a lock out for an account wouldnt come from the SQL Server side, it would have to come from the vendors software for SQL 2000?

Is this your mail server that your trying to connect to or another departments?

You need to find out the way you need to connect to the mail server(authentication/password). Everyone has...

What is on your SQL Server Express edition that you need to save, it sounds like you have just the Server loaded with no real data (maybe AdventureWorks??), at least...

C# 2.0: The Complete Reference (Complete Reference Series)

Microsoft SQL Server 2005 Unleashed

Cant live without the Complete Series for C# or Unleased for SQL Server.

Maybe a more clear explanation of what I am trying to do...

I created a Maintenance Plan and need to set it up through the SQL Server Agent. While trying...

If this db has been upgraded from SQL2000 then check if you see the db_owner role:

SELECT * FROM sys.database_principals

from a little research the solution seems to be to copy all...