Data Compare on Temporal Tables
I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...
2016-11-02 (first published: 2016-10-28)
3,048 reads
I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...
2016-11-02 (first published: 2016-10-28)
3,048 reads
Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...
2016-10-31
901 reads
Here's a quick snippet to get a listing of the database backups that last occurred on a server. Most solutions...
2016-10-31
480 reads
I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...
2016-10-28
533 reads
Registered Servers
I've used Central Management Server registered servers in SSMS for primarily one purpose, saving connections. 🙂 This is definitely not...
2016-10-24 (first published: 2016-10-16)
4,060 reads
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax....
2016-10-22
1,040 reads
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.If...
2016-10-22
230 reads
Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have...
2016-10-18
557 reads
Here's my personal tweaked settings for deploying Minionware's fantastic Reindex & Backup jobs. In the development environment, I wanted to have...
2016-10-18
222 reads
Troubleshooting
I ran into an error: The target principal name is incorrect. Cannot generate SSPI context. (Microsoft SQL Server, Error: 0)
I...
2016-10-17
976 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