Per Books Online:

Committing inner transactions is ignored by the SQL Server Database Engine. The transaction is either committed or rolled back based on the action taken at the end of...

Special instructions for system databases:

http://msdn2.microsoft.com/en-us/library/ms190749.aspx

Cross-posting.

Please continue conversation here

Please don't cross-post.

Do you by chance have connection pooling turned on in your ODBC connection? Mine look to be on by default. That may be causing your issue,...

Isn't the purpose of a trigger to be run every time? If you have to continually disable triggers, are you sure you're not missing what a trigger is built...

If it helps you at all bonk - a table IS a persistent 2-dimension array. One that happens to have the ability to perform parallel operations on its members...

Did you check into replication? Because if the DB is supposed to be replicating, it won't remove transactions that still need to replicate to the other nodes....

I can't take credit for it - I got clued into this by Jeff Moden (who was using 2000's syscolumns equivalent).

Considering it has 4100 rows in a brand new blank...

Well - consider Paul Randal was one of the people who reviewed and critiqued the very white paper you're asking about, I'd say that following his advice would be a...

I'd advise against trying to hammer everything into Port 1433. It tends to get the server confused, especially when "internal" things like Agent, Analysis services, etc... try to access...

There's an intermediary screen in SSMS between the time when you pick the .MDF to attach, asking you to confirm you want to attach. At the bottom of that...

A bit of a spin on jeremy's thought, using a temp table

drop table #tally

declare @startvalue datetime

select @startvalue='01/01/2008'

select top 745 -- 31 days *24 hours +1

...

That seems to point to the fact that you've got a transaction still not committed somewhere. The backup, etc.... will only backup and truncate committed transactions up to the...

Open your report up, go to Report parameters, and make sure that Enddate is defined as a datetime parameter. If you have Enddate defined as a string - this...

First thought - you're doing this one time on 3000 or so rows, so it doesn't much matter HOW you do it.

Second thought - now that we've banished thought #1...