Viewing 15 posts - 886 through 900 (of 18,926 total)
You can do a 2nd test.
Run that sp from withing bids (data / query window).
You'll see if the results are getting returned correctly. Then you can do the same...
November 21, 2011 at 8:10 am
BEGIN TRAN
CREATE TABLE dbo.tid
(
id1 INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
id2 INT IDENTITY(10,10) NOT NULL,
sometext VARCHAR(10) default(newid())
)
ROLLBACK
Msg 2744, Level 16, State 2, Line 3
Multiple identity columns specified for table 'tid'. Only one...
November 21, 2011 at 8:00 am
Jack Corbett (11/21/2011)
Hey, has anyone gotten today's SSC newsletter? Mine's usually in the inbox by 7am EST and nothing yet.
Didn't get it either.
November 21, 2011 at 7:57 am
jcrawf02 (11/21/2011)
Ninja's_RGR'us (11/21/2011)
jcrawf02 (11/21/2011)
Ninja's_RGR'us (11/21/2011)
jcrawf02 (11/21/2011)
Yeah, move. Not worth it.This question is worth 20K / year on the low end. This is not so black or white for me.
And...
November 21, 2011 at 7:54 am
mtassin (11/21/2011)
Ninja's_RGR'us (11/21/2011)
mtassin (11/21/2011)
Ninja's_RGR'us (11/21/2011)
I know it depends, but I'm getting sick of making that argument so I was hoping one of you guys would take care ot that! 😉
IT...
November 21, 2011 at 7:44 am
sami.sqldba (11/21/2011)
Try this outSELECT SomeColumn
FROM SomeTable
WHERE SomeDateColumn >= '20110901' AND SomeDateColumn <= '20111031'
Take your spam somewhere else. Or try to help for real!
November 21, 2011 at 7:30 am
November 21, 2011 at 7:29 am
Daniel Bowlin (11/21/2011)
crookj (11/17/2011)
WOTD - phenomenonmovie
Dante's peak!
November 21, 2011 at 7:29 am
george sibbald (11/21/2011)
Have you seen Tom thomsons new avatar?Looks like the operation was a success.
Of course soon as he changes it (again) this post will look stupid.
😀
Nope, I 100% agree....
November 21, 2011 at 7:27 am
jcrawf02 (11/21/2011)
Ninja's_RGR'us (11/21/2011)
jcrawf02 (11/21/2011)
Yeah, move. Not worth it.This question is worth 20K / year on the low end. This is not so black or white for me.
And how much...
November 21, 2011 at 7:18 am
Greg Edwards-268690 (11/21/2011)
Ninja's_RGR'us (11/21/2011)
Either they fix it for me and I live there, or they burn down the house nobody has to risk...
November 21, 2011 at 7:17 am
mtassin (11/21/2011)
Ninja's_RGR'us (11/21/2011)
I know it depends, but I'm getting sick of making that argument so I was hoping one of you guys would take care ot that! 😉
IT DEPENDS!
There I...
November 21, 2011 at 7:07 am
okbangas (11/21/2011)
For those interrested in MCM, I can clearly recommend the MCM Videos. Lots of useful stuff, actually even if you're never going to certify as MCM.
That's scary enough to...
November 21, 2011 at 7:06 am
You're not upgrading in that sense. For the upgrade advisor you need to change the version (2008 to 2008 R2), not the edition (express, standard, enterprise).
November 21, 2011 at 7:05 am
Viewing 15 posts - 886 through 900 (of 18,926 total)