Viewing 15 posts - 2,341 through 2,355 (of 7,483 total)
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...
Tom
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,...
Tom
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...
Tom
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,...
Tom
August 14, 2014 at 9:21 am
stephen.long.1 (8/14/2014)
Am I the only one who noticed that the code...
Tom
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...
Tom
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...
Tom
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...
Tom
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...
Tom
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...
Tom
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...
Tom
August 13, 2014 at 9:00 am
Hugo Kornelis (8/12/2014)
Tom
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...
Tom
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...
Tom
August 13, 2014 at 7:48 am
I used replication a lot for about 7 years. This was all transactional replication, except for some(very little) ad-hoc snapshot replication. It certainly had some defects. I...
Tom
August 12, 2014 at 5:22 pm
Viewing 15 posts - 2,341 through 2,355 (of 7,483 total)