I can reproduce the same issue in SQL Server 2008 R2. Instance is:

Microsoft SQL Server 2008 R2 (SP2) - 10.50.4033.0 (X64)

Jul 9 2014 16:04:25

Copyright (c) Microsoft Corporation

Enterprise...

I'm curious, was the sql server agent running? Anyway, I'm glad you found another way. Thanks for sharing.

Aldo

Thanks to Paul Millar for pointing this out!

paul.millar (5/21/2012)

Short of Redgate Data Compare, check this out for generating Tablediff command lines...has saved my bacon a few times, and is surprisingly...

Thank you for sharing Alejandro.

For reference, we should clarify that -f starts SQL Server minimally configured and in single user mode. Both features are needed to the maintenance work being done here, that...

Martin,

Thank you for your observation, which shows a problem with using Cluster Administrator to start a clustered instance in single user mode. The problem is that even if SQL Server...

Thanks you for the comment. It is clear that there are two schools of thought when it comes to the right number of datafiles in tempdb. Microsoft recommends...

I agree. The article only addresses the sizing of each datafile with respect to the other datafiles on the tempdb filegroup.

Thanks.

Here's another way. This one uses a range provided by a numeric column, even better if it is indexed. No need for counts or deletes.

-- we use a...