My preference is to keep the scripts separate and run them one at a time. In our environment, we release bug fixes and enhancements to beta as they're fixed and...

Not a real elegant solution but would this work for you?

declare @customer table (customerid varchar(8))

declare @Tmp table (incrdate datetime)

declare @maxdate datetime

insert into @customer (customerid) values ('00009956')

insert into @customer...

In the DTS package, is the precedence between steps set to success or completion? This would affect how the job status is reporting.

Changes to existing code is usually a one-on-one with a dev team peer to make sure it meets coding/company standards and is well documented.

Reviews for new code is at least...

ok,

use master

ALTER SERVICE MASTER KEY FORCE REGENERATE

worked. thanks all for your help!

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'targetsrvname',

...

Yep, login works. it was the 2005 box (source) that was upgraded.

Nope, same thing.

Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91

An error occurred during decryption.

Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98

There is no remote user 'sql2000login'...

ok, changed to

exec sp_addlinkedsrvlogin

@rmtsrvname = 'targetsrvname'

,@useself = 'true'

,@locallogin = NULL

,@rmtuser = 'sql2000login'

,@rmtpassword = 'pwd'

and here's what I'm getting

OLE DB provider "SQLNCLI" for linked server "targetsrvname" returned message "Communication link...

It's actually a Windows account 'domain\sql2005login' but yes, it's on both instances.

If it's a one-off, I'd go with the import/export wizard. If this is something you'll need to repeat down the road, you might consider writing code (i.e. SP) to handle...

Can't remember where I got it but this might prove useful to you.

use master

go

if exists ( select * from tempdb.dbo.sysobjects o

where o.xtype in ('U') and o.id...

Would it make a difference if you reworked Lowell's trigger into an INSTEAD OF rather than a FOR/AFTER?

Have you checked the physical server to identify what resources (IO, Memory, CPU, etc.) are being consumed?

If you don't already have one, set yourself up a test box and get in the practice of trying stuff out there before applying it to a live db. I've...