Sorry, Oracle terminology. In SQL Server this would be Snapshot. Regardless, use technology to allow you to rollback to the point in time before deployment...

Interesting. Certainly you can track db version in the database. quite a few vendors do this and it works well as long as you can keep control of the db...

Steve Jones - SSC Editor (5/6/2015)

---

Bradley Deem (5/6/2015)

---

I've been writing idempotent scripts for years. However, even that's not the best defense against a script run twice. I've found it's more...

Idempotent scripts are great when possible, but you must be pragmatic. For example, data migrations with table transformations are often not easily made idempotent.

You can reliably check the database/app version...

I've been writing idempotent scripts for years. However, even that's not the best defense against a script run twice. I've found it's more economical to write a guard at the...

I assume the dll is unsafe. So for example if we were adding System.Web.dll.

-- Trustworthy is required for unsafe access or use certificates

ALTER DATABASE Utility SET TRUSTWORTHY ON

-- This...

Great question.

UMG,

Thanks for the link, that's good to know for sure.

UMG Developer (3/21/2011)

---

Interesting question, thanks, and a good reason you should always specify the data type for hardcoded items in the first set of values or in the first query...

Great question.

I must say, .NET Framework has one up on SQL here. Considering the following VB.NET code.

System.Console.WriteLine(1234567890.123456789D * 0.1D * 0.1D)

returns 12345678.90123456789 as expected which is simple.

DECLARE @value1 DECIMAL(20,10),...

Solomon Rutzky (12/29/2010)

---

Bradley Deem (12/29/2010)

---

I think part of this limitation is due to the lack of ability to perform an ORDER BY clause with an aggregate.

Assuming I've implemented it correctly,...

Thanks for sharing David. I agree most CLR aggregates have not had much success beyond academics. I think part of this limitation is due to the lack of...

Carlo Romagnano (12/20/2010)

---

ian.grace (12/20/2010)

---

I don't understand how the first transaction could succeed given the attempt to insert the null value into the not-null field "a". Also, why is the...

Interesting, I...

Good question. A slight variation on the question helps explain the behavior of @@TRANCOUNT which isn't very clearly stated in the BOL.

A trigger operates as if there were an...

Great series of questions. Although, I think the correct answer is actually option 1 and option 3. IE

The following error is raised "Cannot roll back InnerTran. No transaction or...