If it is the journey that is important, perhaps you ought to try to do this yourself. Make an effort and try to solve the problems.

We are happy to help,...

Are you putting the rowcount in all rows you're inserted into the audit table? the count is easy

create trigger ...

for update

....

declare @cnt

select @cnt = count(*) from inserted

I tend to agree that Subway, and Chipotle, have a few issues. You do have to spell things out everytime, which is annoying for someone like me that tends to...

nice question, got me as well.

I'll correct the case sensitivity

I'm not sure that I agree multiple apps aren't simpler. You do have the same knowledge requirement, but when you go to perform a function, you have less clutter, and...

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...