Viewing 15 posts - 2,341 through 2,355 (of 7,484 total)
Steve Jones - SSC Editor (8/14/2014)
August 14, 2014 at 5:22 pm
Toreador (8/14/2014)
SQLRNNR (8/13/2014)Why can't sp_rename perform that same metadata update?
Presumably it's the standard Microsoft trick - there's a bug in the software, they can't be bothered to fix it, so...
August 14, 2014 at 4:47 pm
SQLRNNR (8/13/2014)
TomThomson (8/13/2014)
SQLRNNR (8/13/2014)
Why can't sp_rename perform that same metadata update?
Good question. That's something we definitely agree on. sp_rename should update all the metadata. If it did,...
August 14, 2014 at 4:44 pm
david.gugg (8/14/2014)
1% have gotten it correct? Clearly too complex for QotD. It would have been helpful know the number of correct answers to choose.
Knowing the number would have...
August 14, 2014 at 9:31 am
jjtetzlo (8/14/2014)
I assume that's you, Tom? Wow... I hope I never have to troubleshoot a scenario like this. Tough, tough question. But very well laid out,...
August 14, 2014 at 9:21 am
stephen.long.1 (8/14/2014)
Am I the only one who noticed that the code...
August 14, 2014 at 8:55 am
Brandon J Williams (8/13/2014)
Replication Monitor is good for a quick sanity check but we have rolled our own monitoring solution. We are continuously adding features to that.
That seems to...
August 13, 2014 at 7:53 pm
SQLRNNR (8/13/2014)
Why can't sp_rename perform that same metadata update?
Good question. That's something we definitely agree on. sp_rename should update all the metadata. If it did, OBJECT_DEFINITION would...
August 13, 2014 at 7:26 pm
GilaMonster (8/13/2014)
TomThomson (8/13/2014)
GilaMonster (8/12/2014)
I'd love some rain. It's getting towards the end of winter here and it is soooo dry.
I wish I could give you some of ours. I'm...
August 13, 2014 at 7:16 pm
K. Brian Kelley (8/13/2014)
"Air gaps are failed infosec" hasn't led to SCADA systems directly connected to the Internet. That's because there are SCADA systems that already are.
Yeah, sure, so some...
August 13, 2014 at 6:59 pm
SQLRNNR (8/13/2014)
The point on the second option is that the definition remains the same text as when the procedure was created with the improperly spelled name.
I guess the problem is...
August 13, 2014 at 9:38 am
GilaMonster (8/12/2014)
I'd love some rain. It's getting towards the end of winter here and it is soooo dry.
I wish I could give you some of ours. I'm beginning to...
August 13, 2014 at 9:00 am
Hugo Kornelis (8/12/2014)
August 13, 2014 at 8:48 am
patrickmcginnis59 10839 (8/13/2014)
I remember one product from CISCO that incorporated MSDTC (the SQL 2000 name for SQL Express without tools).
<nitpick>MSDE</nitpick>
MSDTC is the transaction manager isn't it? Just being picky about...
August 13, 2014 at 8:33 am
Interesting question. It's a pity that the first answer option is ambiguous, with one reading making it correct and the other incorrect, while the second option, which is claimed...
August 13, 2014 at 7:48 am
Viewing 15 posts - 2,341 through 2,355 (of 7,484 total)