Chris Goldsmith

Creating a recycle bin for SQL Server 2005\2008

Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.86 (73)

You rated this post out of 5. Change rating

2009-05-20

13,692 reads

Measuring and Improving SQL Server Query Plan Cache Efficiency The query...

I may think I'm trying to reach the crowd, but I'm really trying to...

📘 Understanding PESTLE PESTLE is a strategic framework used to evaluate external macro-environmental factors...

Comments posted to this topic are about the item The Technical Debt Anchor

Comments posted to this topic are about the item Getting the Updated Column List

Here's the complete error: An error occurred during local report processing. The definition of...

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge
 SET CustomerContactFirstName = 'Andy'
 WHERE CustomerID = 1

SELECT COLUMNS_UPDATED()