I think this happens when the owner of the job does not have an individual login to SQL Server but has access granted through the membership of a Domain Group...

There is more information on the sp_help_revlogin here http://support.microsoft.com/kb/918992/en-gb

I've done this in the past. I created a SQL Server Agent job with one step that had the command "EXEC sp_help_revlogin" in the database master. One the...

In my experience you can not fix this at the backend; you need to make changes to the application. Application developers need to minimize the occurance of deadlocks by...

I've never used evault for backing up SQL Server databases so I can't really help further sorry, but I'm guessing if the software says it is doing hourly log backups...

Doug,

What is the name of the software system you are using for the backups? Is it something developed in-house or from a third-party vendor?

I used to do this kind of thing using osql and bat files to deploy to multiple servers before we had Central Management servers. For example you could create...

From what you've already posted I think you can do it one script. What makes you think you can't?

You could use the REPLACE function. You would need to use it for each number you want to replace with the character 9.

DECLARE @s-2 VARCHAR(50)

SET

I've struggled to do this kind of thing in the past, so ended up creating two datasets (one for the first 1o rows, and one for the remainder) and having...

Sorry, from reading your original post I thought you already had a number of different data flow tasks that were trying to write to the same file name.

Could you have each of the 4 data flow tasks output to a differently named file and then add a File System Task at the end to rename the file...

I would see if setting the DelayValidation property to true on each of the file connection managers solved this problem first. Then. if that did not work, I'd have...

It might also be worth checking the default language setting of the login being used. This has caught me out before. The login on the old server...

It's the "Identifier" Display Item that you need to change when showing the settings for Text Editor, change the Item foreground to Black.