It means that SQL Server automatically adds a 4 byte system generated uniqueifier to all the duplicate entries in a non-unique clustered index.

The maximum value for the uniqueifier is 4,294,967,296,...

It highly depends on your expected output, but this should do the trick.

DECLARE @Case2 TABLE (

ID int PRIMARY KEY CLUSTERED,

Other_ID int NOT NULL

)

DECLARE @Notes TABLE (

ID int PRIMARY KEY CLUSTERED,

DisplayTime...

Also, looks like you had a huge sort spilling to tempdb. Could be an indexing issue or stale stats. I would try to investigate...

The email gets sent only when DBCC failed for at least one database, otherwise it won't send anything.

If you don't like this behaviour, you can change the code to send...

I would incorporate the trigger code in the procedures if possible.

When you end up with this kind of trigger it's a symptom of a bad relational design. Is refactoring your...

NOLOCK? :sick:

With RCS enabled writers don't block readers. Is this the kind of concurrency issue you're trying to address?

As far as the dangers is concerned, you could read this: http://www.jimmcleod.net/blog/index.php/2009/08/27/the-potential-dangers-of-the-read-committed-snapshot-isolation-level/

Disadvantages: if your application was not designed for optimistic locking, RCS could break some of your business logic or lead to incorrect results.

Let me reverse your question for just one...

You don't need that on SQL Server 2008.

The code checks for the instance version and never runs that branch of code.

You should be okay now.

My bad.

The code starts with ALTER PROCEDURE maint.dba_rucnCHECKDB ....

Change it to CREATE PROCEDURE

hmbtx (12/27/2011)

---

Gianluca

The only reason that I decided to run bwoulfe's code instead of yours is that his already had the code to email the report.

You stated "To get a notification,...

I'm from Venice and we don't (usually) eat Reindeer at Christmas.

You can...

Your best option here is setting up mirroring.

As long as you don't use database snapshots to query the mirror, you don't have to pay for the license.

This applies to physical...

Replies here please:

http://www.sqlservercentral.com/Forums/FindPost1226730.aspx

hmbtx (12/23/2011)

---

bwoulfe

I downloaded the script from http://www.heydba.net/2011/05/get-dbcc-checkdb-output-tool-for-sql-server-2005/ and got it to work in SSMS.

I am running SBS 2011 with SQL Server 2008R2.

However, when I place the scipt in a SQL...

The idea behind is very similar. We got to slightly...