Viewing 15 posts - 4,081 through 4,095 (of 13,469 total)
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...
January 28, 2013 at 2:03 pm
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...
January 28, 2013 at 2:00 pm
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...
January 28, 2013 at 1:47 pm
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...
January 28, 2013 at 12:14 pm
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...
January 28, 2013 at 10:59 am
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...
January 28, 2013 at 10:51 am
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...
January 28, 2013 at 9:51 am
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...
January 28, 2013 at 9:46 am
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...
January 28, 2013 at 9:24 am
run bcp /? from the command prompt for all the possible flags;
i think the one you want is the -E flag:
-E keep identity values
January 28, 2013 at 9:05 am
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,...
January 28, 2013 at 8:23 am
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...
January 28, 2013 at 6:08 am
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...
January 27, 2013 at 12:19 pm
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...
January 26, 2013 at 8:26 pm
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...
January 25, 2013 at 1:32 pm
Viewing 15 posts - 4,081 through 4,095 (of 13,469 total)