Viewing 15 posts - 2,836 through 2,850 (of 18,926 total)
CELKO (9/11/2011)
Darn, I need to rewrite 150+ reports of mine. Too bad they actually do what they need, and fast too :-D.
You should not be writing reports...
September 11, 2011 at 1:00 pm
Jeff Moden (9/11/2011)
September 11, 2011 at 6:54 am
My bad, I read go from R2 to 2008.
G is right, as usual.
September 9, 2011 at 6:24 pm
Krasavita (9/9/2011)
Thank you, for the trace when I start running, what options should I check for?
SM will take care of that for you. Just ask it to save the...
September 9, 2011 at 6:23 pm
The dbs can't be downgraded.
You need to script out EVERYTHING then reimport the data on the lower level.
Might actually be cheaper to upgrade everything than the reverse (less work involved...
September 9, 2011 at 11:51 am
GilaMonster (9/9/2011)
The only one that fails is a rollback that references a name that doesn't exist, and that's a side-effect of savepoints.
So yay / nay on the qotd. This...
September 9, 2011 at 11:49 am
Nice one Gail, you should turn that into a QODT.
Like select on the options that will error out or something like that, with one that actually does fail.
September 9, 2011 at 11:45 am
md23 (9/9/2011)
mysearchresult (9/9/2011)
GO
SP_SPACEUSED 'yourschema.yourtablename'
GO
The above gives the number of rows and other information regarding the table. This is the faster way to see the number of commited rows in...
September 9, 2011 at 11:44 am
LutzM (9/9/2011)
Straight from BOL:
It is not legal for the transaction_name parameter of a ROLLBACK TRANSACTION statement to refer to the inner transactions...
September 9, 2011 at 10:53 am
Can you upload the full exec plan? I'd love to play with it.
TIA.
September 9, 2011 at 10:36 am
GilaMonster (9/9/2011)
September 9, 2011 at 10:35 am
GilaMonster (9/9/2011)
PaulB-TheOneAndOnly (9/9/2011)
September 9, 2011 at 10:15 am
GilaMonster (9/9/2011)
September 9, 2011 at 10:05 am
GilaMonster (9/9/2011)
Ninja's_RGR'us (9/9/2011)
MysteryJimbo (9/9/2011)
Ninja's_RGR'us (9/9/2011)
So once ";" are mandatory, the problem will go away.
I love this proposed new "feature". Millions of lines of code to be changed...
September 9, 2011 at 9:57 am
Viewing 15 posts - 2,836 through 2,850 (of 18,926 total)