the error "identifier too long" is probably because a column name is longer than 30 characters, which is the Oracle size limit on object names.

review the table you are trying...

you can also do it SQL2000 style(before the wonderful row_number/ranking functions came out) , using nested TOP statements to get the top 11, and then the top 2 of...

you can get a pretty good copy of the table , which would not have the any foreign key constraints, by doing something with the INTO statement:

SELECT *

INTO MyNewTable

FROM MyLinkedServer.DatabaseName.dbo.TargetTable

WHERE...

I Am probably reading this wrong:, but since I never stay at a Holiday Inn Express, I don't have the required Expertise:

http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx

but i don't see a # of connections...

that is by design, and the normal behaviour for SQL server:

SQL tries to keep everything in memory to support subsequent queries. if you leave an installation at it's default settings(2...

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