looks like he's correct to me;

according to this page,neither standard nor enterprise will upgrade/replace an existing developer instance:

take a look here:

http://msdn.microsoft.com/en-us/library/ms143393.aspx

so to get everything correct, you need to do a...

besides identifying the columns in the table, you need another attribute to identify what makes a collection of columns unique, especially if it's not the PK of the table and...

in our case, we have a config file that has the connection string information, and a single row table that contains a lot of settings relevant to the application that...

Toby I'm not sure if this is what you are looking for;

this is just a try-catch structure that is parsing out the elements of the error; i'm not sure what...

run bcp /? from the command prompt for all the possible flags;

i think the one you want is the -E flag:

nope a synonym must point to an object ( an object that would exist in a databases sys.objects view), and not part of the name of an object.

so by definitions,...

depending on how many addresses you need to validate,(and you want to do it yourself) this link below could be an option;

i'ved used this to clean up and validate...

chris@home gave you teh best advice so far: if you can rewrite teh query, redo it so that it is 5 unions, using the agregate example he already put to...

sounds like you are getting an error because you have a database greater than ten gig on a SQL express installation;

my recommendation would be to spend $45 dollars and buy...

i hope you mean multiple databases on a single SQL Server installation, and not multiple SQL Server Installations, one for each "application"

If there are going to be any reports or...

statsics look real bad in two of the queries (200K+ rows estimated, actual = 0

and pretty bad for the rest;

running this, with no other changes, will at least help a...

also, my rule of thumb is that any @TableVariable with more than a few hundred rows should be a temp table instead, to allow the system to automatically do things...

if you don't have a customized trace, CDC, SQL Audit, or some other set of tracking in place prior to the query being executed, there's no way to find...

it's not stored anywhere , i think; I believe you'll have to find a year old backup and compare that to todays backup.

since the proc would create the same tables all the time, it seems to me a stored proc which simply restores a backup as a new database name might be...