We had something similar, but it was a network issue. If I remember correctly, it was dueling domain controllers(?) generating different information. It was also only happening every 4 hours,...

Congratulation Gus!

Jeff Moden (12/30/2010)

Roy Ernest (12/29/2010)

This post (in the discussion of the article) references both the safety check and the modification to it, and includes the resultant code sample with both applied.

dbursey (12/29/2010)

You'll have to use dynamic sql to run it that way.

Matthew,

Thanks for following up with the code that shows it working - it will help out others in the future when they have a similar issue.

How does this run performance-wise...

This sounds like a job for the row_number() function with the optional partition by clause. This article[/url] might help you out with understanding it.

First, let's put the data into a table so that it can actually be worked with:

And here are 3 different methods to extract the ISBN and Group for just the...

If you definition of unused is that it has zero records, you can run a query to determine this.

Otherwise, you'll probably have to run a server-side trace to track what...

Sounds like a partitioned view here will handle things - see this link for how to handle this. The trigger will insert into the view, which will properly put the...

jbon007 (12/29/2010)

from the two views i want the two results to be combined into one view.

i.e

NoDaycase noElective Dis_Spec...

Matthew Darwin (12/29/2010)

This will generate the ALTER TABLE statements for you.

SELECT 'ALTER TABLE ' + QUOTENAME(ss.name) + '.' + QUOTENAME(st.name) +

' DROP CONSTRAINT '...

Nic,

Very interesting. Thanks for posting your solution - I've learned something out of this!