Another use of OpenRowSet()
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,394 reads
From time to time, I need to dump out the result from a SP, such as sp_lock or sp_who.
Traditionally,...
2007-11-29
1,394 reads
It's funny - sorta - how you become used to the quirks of the tools you. I try not to rant too...
2007-11-29
1,404 reads
I was having this discussion recently with Shawn Weisfeld, President of ONETUG and it's definitely a frustrating topic. As a...
2007-11-28
1,415 reads
I was reading an interview with Jimmy Wales (the Wikipedia guy) in Selling Power magazine (I have ecletic reading preferences...
2007-11-26
1,349 reads
CIO Magazine has a interesting article about Douglas Merrill, the CIO of Google. One of the things he dicusses in...
2007-11-26
1,672 reads
After putting it off for six months, I finally took - and passed - 70-431 yesterday. I know, I'm probably one of...
2007-11-25
1,431 reads
As a follow up to my post about Cesar Cerrudo's new whitepaper, earlier this month David Litchfield talked about putting...
2007-11-23
2,337 reads
Cesar Cerrudo of Argeniss Information Security has put out a new whitepaper (.pdf format), Data0: Next generation malware for stealing...
2007-11-23
1,961 reads
For the page 10 months or so I've been using a Samsung Blackjack, before that I used various Blackberries for...
2007-11-21
1,419 reads
I solved an "interesting" issue today. It is about distributed transaction. When I set up transactional replication with immediate updating...
2007-11-21
3,504 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers