Did you ever figure it out ?? I have a similar problem.

Did you install Service Pack 2 ?? I think that has the DTS legacy Components in it, along with all the other fixes & updates.

SQL 2005 has synonyms that are for situations like this.

So, you want to change the default collation of the server ?? It's not easy. I've looked into it, and for now, I'm going to live with it...

I've had a couple of service pack installation problems recently, and I think the problem was that the account used to log onto the server did not have enough permissions....

I'm not clear on what's moving where, but you're right about having to specify the server name with linked servers.

You might want to ask this in a new thread...

I don't remember. They have prices listed on their website, and they will usually discount those prices somewhat if...

I suppose there must be some, but they claim it's very minimal. It seems worth the benefit, and we haven't noticed any problems. It has lots of setting so...

We use Idera's Compliance Manager for this

Funny story. Lead Developer came storming down because 3 of his stored procedures were missing. We had recently refreshed the testing area from production,...

We've got Idera's Diagnostic Manager and found it helpful, especially the "Worst Performing SQL & SP" function and the "Most Frequent SQL & SP" function. They helped us track down...

Ed Wyant (11/14/2007)

---

Hi everyone. Is it possible to notify more than one operator of the same job completion? The notifications of Job Properties drop down permits only one e-mail recipient...

I agree. Sounds like a lot...

DECLARE @BackupFile char(91), -- 91 is length of BACKUP script

@strSQL VARCHAR(8000), @DateSuffix char(16)

set @DateSuffix = CONVERT( char(16), getdate(), 121 )

set @DateSuffix = replace(@DateSuffix, '-', '')

set @DateSuffix = replace(@DateSuffix,...

I came across this in my notes, but haven't tried it lately ... (too tired & busy right now)

+++++++++

--This selects every 500 th record, using an identity field

SELECT fielda, fieldb,...

+1 The price is right