Viewing 15 posts - 12,661 through 12,675 (of 13,469 total)
do not cross post...the Active topics function allows everyone to see new posts, regardless of forum. there is no need to ask the same question in multiple places.
answered here:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=349780
March 7, 2007 at 11:41 am
the correct answer is to not remove the identity at all...NEVER update sys tables directly...
the identity column sis there for conveneince, and you can still insert by setting an additional...
March 7, 2007 at 11:33 am
that error is usually when you try and stick 10 characters into a field that is smaller than 10 for example...check the TEST server's DDL for the table...i would bet...
March 7, 2007 at 11:24 am
you might want to consider writing a program to do the work(open file, manipulate, save file) instead of in TSQL; most languages are more robust in their ability to edit files...
March 6, 2007 at 10:17 pm
i have this procedure that i use; sorry i don't know the source of where i got it: this lists all servers on the network, you'd then need to query...
March 6, 2007 at 10:33 am
thanks Jeff I should have thought of that...he never said "procedure" so i assumed he was talking about ad hoc queries.
March 6, 2007 at 6:24 am
yes... if you select @@version, you would most likely see this:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on...
March 5, 2007 at 8:34 pm
I might be mis-understanding the question, but...
if you are re-using the same view name, and recreating it with different SELECT statements, then you should be able to use the command...
March 5, 2007 at 12:05 pm
similar issues here that Steve reported;
we started using strongly typed data sets, and found issues when the underlying structure changed...if we added a column to a table, for example, the...
March 5, 2007 at 11:58 am
there's a difference between the Parse Query Function and the Execute Query;
Parse Query (the check mark button) validates the query for syntax violations...it does not actually check if the objects...
March 5, 2007 at 11:08 am
because your WHERE statements affect different records, you can't merge them together into the SAME SQL
there is no guarantee that the data found would be the same rows, and would...
March 2, 2007 at 11:12 am
I'm sure Aaron is right...it calls the extended stored procedure, which in turn queries the registry for the specific values in question...that way, for example, a service pack or Hot...
March 2, 2007 at 6:11 am
here's an example: you need to decide what to do with columns that have multiple or no commas, but here you go:
create table QUADTEST(namefield varchar(60) )
insert into QUADTEST(namefield) VALUES('Noblesville,Fishers')
insert into...
March 1, 2007 at 9:34 am
if you can, redesign your data storage... you should use a date time filed to store the date and the time together. if you need them separate, you can always...
February 27, 2007 at 2:54 pm
you would want to deploy the SQL Native Client drivers with your application. you would not need anything else.
here's what MS says: basically they give a reditributable sqlncli.msi file, and...
February 27, 2007 at 1:50 pm
Viewing 15 posts - 12,661 through 12,675 (of 13,469 total)