If you have the same schema, you could have one package that pulls data and a second package that passes in a server name and calls the first package. It...

Can't the DTS packages run with the Runtime in 2005 without modification?

And here I was proud of my little mailing database, running with graphite and wood pulp, mirrored with a Xerox on a schedule.

I don't think there's a more elegant way. You could use the DTC (distributed transaction coordinator), but it would hold locks until things were committed, and if your link was...

I would second Bru's advice to use a second system for testing, but since you could easily miss something in test, I'd also recommend a side-by-side upgrade for the real...

No, you will need to manually rebuild the FK constraint

If you have a local application, like IIS, Dynamics, etc. on the same server, this is fine. Otherwise, as Bru mentioned, you need to allow remote connections for any client...

I'm not sure I'm The Man, but thanks.

I wouldn't necessarily discount replication. As Bru mentioned you can have issues with pushing this data to the same destination. There are a...

Rambilla,

The current released version of SQL Server is SQL Server 2008. It has one service pack, having been released in Aug 2008 and it is fine for production. You need...

River1,

There usually is some planning for the next version as the current one is being finished. In other words, AFAIK, right now there are

- Support people working on patching SQL...

Or do a simple search of scripts built by the developer. If they can't remember to add dbo., perhaps you can reject their scripts until they do

Encrypt only the credit card column, or better yet, encrypt it as a hash only. Don't store this stuff if you don't need to do it. If you do, then...

Please don't use "sa" in examples. It sends a bad message, even though it doesn't matter in this example.

However, the way you want to do this, using the code above,...

I think that the default response ought to be to help out. That's what we do as technologists, and our art/science is often arcane and complex in the eyes of...

Here's a good hint for you:

http://www.sqlservercentral.com/scripts/Triggers/63064/