A solution composed just before bedtime, and it could serve from further testing:

;WITH CTE AS (

SELECT legacyid, field1, newid,

...

You can set...

GRANT SELECT and DENY VIEW DEFINITION on the object:

CREATE USER nisse WITHOUT LOGIN

go

CREATE TABLE pelle (a int NOT NULL)

GRANT SELECT ON pelle TO nisse

DENY VIEW DEFINITION ON pelle TO nisse

go

EXECUTE...

Write a small program in C#/VBScript/Perl/whatever that runs the query, and then invokes SQLCMD once for each database. Or just simply run the script directly. (Running a script file is...

dgutie02 (8/14/2013)

Ah, okay, I was afraid so. How does this sound then?

1) Restore the Database on the new machine

2) Increase the filesize

3) Backup the new database

4) Restore the backup of...

Are the database that fail on different disks than the database for which DBCC works?

What is the file system for the F disk?

The hashes are just hashes.

To see the plan for a specific statement...

The data you see is not...

This is something you should do client-side, not in SQL Server. SQL Server serves the data. Formatting is best done elsewhere. I assume that this for some export purpose. There...

Ah, so you have a stored procedure. In that case, there is a somewhat simpler query:

with cte as (

select substring(est.text, (qs.statement_start_offset + 2)/2,

...

I will have to admit that I did not look at the deadlock chain. My experience of serializable was enough.

Do you have a paritioned table or a partitioned view? Can you post the scripts for what you have, so that we can understand what you are talking about?

I think you shold take out the HOLDLOCK. HOLDLOCK is the same as SERIALIZABLE, that is protection against "phantom reads", that is rows that were inserted since you read the...

I think you should invest whether the query plan at the problematic point in time is a fresh one or a new one. You can use this query to search...

Yes, that works, since the dynamic SQL is a scope of its own. But it is hardly a realistic workaround.