Viewing 15 posts - 7,456 through 7,470 (of 7,484 total)
The answer ssumes that the column wasn't flagged "not for replication" - I was expecting to see an option "DBCC CheckIdent(
May 1, 2009 at 8:18 am
Bruce W Cassidy (4/30/2009)
May 1, 2009 at 6:53 am
Samuel Vella (4/27/2009)
Jeff Moden (4/27/2009)
Heh... in SQL Server 2005, even that can be done without a cursor. We're just gonna have to wait for it in Barry's series of...
April 30, 2009 at 1:24 pm
jwheeler (4/27/2009)
If you have database development to be done you either employ a db...
April 30, 2009 at 1:18 pm
WayneS (4/18/2009)
Programming languages have evolved. 15 years ago, you had plain old programming languages, complete with...
April 30, 2009 at 9:45 am
RBarryYoung (4/15/2009)
April 30, 2009 at 5:23 am
Girish Bhat (4/15/2009)
Your point is well taken. For the specific example you have mentioned, you could use:
sp_MSforeachtable
@command1 = "Alter Table ? Alter Column...
April 29, 2009 at 2:32 pm
dbishop (4/14/2009)
April 29, 2009 at 1:34 pm
gautamsheth2000 (4/13/2009)
Should use this code 🙂Select count(*) From master.sys.columns C1 CROSS JOIN master.sys.columns C2
That's far too slow 😉
Try instead:
select power(count(*),2) from master.sys.columns
Comparing equivalent code on SQL Server 2000 indicates...
April 29, 2009 at 12:05 pm
dmoldovan (3/20/2009)
kevin.l.williams (3/20/2009)
March 20, 2009 at 1:23 pm
Chris Harshman (3/19/2009)
Ben Leighton (3/19/2009)
if the SET READ_COMMITTED_SNAPSHOT is set to on for the database you are using then the query will return 1 and 2...
I'm...
March 20, 2009 at 10:15 am
I guess what's improved my efficiency is remote access technology: the internet,VPNs ,VPDNs, remote desktop. VOIP. Without some of these I would have real problems with systems on...
March 20, 2009 at 9:11 am
I'm very much in the clean up camp. I have an inviolable rule that the only access applications have to the databases is to stored procedures, so that I don't...
March 2, 2009 at 7:45 am
noeld (2/3/2009)
Suppose you need to prevent changes on ONE table while you are doing some maintenance work...
February 3, 2009 at 2:51 pm
Viewing 15 posts - 7,456 through 7,470 (of 7,484 total)