Customer relation and also SQL Server 2005
We're updating an existing program from
Win2k/SQL Server 2k to
Windows 2003 and SQL Server 2005 along with acquiring a new program that additionally makes use of
2k3/2k5. The supplier claims that for us to host both data sources we require to get the Enterprise variation due to the fact that the software programs customers make use of various relation for the links and also just Enterprise sustains this.
I can not locate anything on MS's website to sustain this and also, truthfully, do not intend to pay the added for Enterprise if the Standard version functions. Am I missing out on some not spoken about attribute of SQL Server or is this, as I believe, a supplier attempting to upsell me?
All versions of
SQL Server 2000/2005/2008 assistance having numerous data sources, each utilizing their very own relation series. You do not require the Enterprise variation.
When you have a data source that makes use of a relation series that is various from default relation for the data source web server, you will certainly require to take some added preventative measures if you make use of short-lived tables and/or table variables. Temperature tables/variables stay in the tempdb data source, which makes use of the relation seqyuence made use of by by the master data sources. Simply bear in mind to make use of "
COLLATE database_default" when specifying personality areas in the temperature tables/variables. I blogged about that not also lengthy earlier, if you desire some even more information.