Alexander, the Robert Vieira SQL Server 2005 book does not mention the Snapshot Isolation Level, which is why I've stated there are only four levels in SQL Server 2005. You...

Since we're on the topic of llinked servers, the above where clause addition by ben.rosato should be WHERE ISREMOTE = 0, which means linked server (Ben may have needed ISREMOTE=0...

Yelena Varshal (12/12/2007)

---

I do think that the config files are the best, but a lot of people prefer DNS aliases for the server names. This way you have to make...

Jacob,

The proper technique is to use package configurations by either using an XML configuration file, or SQL Server based configurations. If using an XML configuration file, you can use...