george sibbald (9/30/2010)

---

not enough information to help there. Is there a stack trace in your SQL log directory or any further messages in the errorlog.

As a fatal exception this might...

ps. (6/15/2009)

---

Use tablediff utility.

http://msdn.microsoft.com/en-us/library/ms162843(SQL.90).aspx

http://www.mssqltips.com/tip.asp?tip=1073%5B/url%5D%5B/quote%5D

I second this suggestion. I have used tablediff myself, and while it will need some amount of DOS/batch file techniques, the benefits are:

1....

UMG Developer (10/5/2010)

---

Nice question, thanks!

Related BOL links:

SQL Server 2008 R2: http://msdn.microsoft.com/en-us/library/ms175010.aspx

SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms175010(SQL.100).aspx

SQL Server 2005: http://msdn.microsoft.com/en-us/library/ms175010(SQL.90).aspx

SQL Server 2000: http://msdn.microsoft.com/en-us/library/aa260638(SQL.80).aspx

All of them say:

* "Transactions involving table variables last...

Not at all, Hugo. In fact, I like it that we have a frank and honest community which draws...

That's why said "the test above shows that..." - I didn't have the time...

p0peye (9/23/2010)

---

Please correct me if i am wrong...

My understanding is, you wont be able to commit or rollback inner transaction separately as the outer transaction will override with its commit/rollback...

Thank-you for the kind words, "UMG Developer" (I am sorry for using your alias), Ron and Dhruvesh.

I have learnt a great deal from the community, and when I was first...

When...

I believe "NoSQL" can be used for "Service-only" offerings (Examples can be application/widgets that simply gather data by crawling across the web and display the same - the WeatherBug and...

The comics might be put up in the Best of SSC and also have their own series - Best of Raw Materials. As one of the readers suggested, maybe one...

Hello!

Sorry for not mentioning this earlier, but in recent times, I have also seen a 98 page exceptions report for data coming over an interface over a period of 1...

Hello!

I would say a lot depends on the type of report - if you are doing an inventory report to cross-check the physical inventory stored at a remote location, the...

vinod.andani-874416 (9/16/2010)

---

i strongly disagree with you.. as the rollback/commit statments does not work for alias unless preceeded by TRAN or TRANSACTION so the syntax error.... i chose answer "Error :...

That...

mtassin (9/15/2010)

---

I don't even know how excitingly appropriate this is.

Yesterday I learned about savepoints. Today a trigger that was invoking a stored procedure that created an inner transaction and...