Thanks. I was incorrectly resorting the database on 2000 instance. I meant to restore on 2005.

I agree but my team member have a different approach. I am still trying to understand their logic.

SET ROWCOUNT 1

DELETE FROM #t1

SET ROWCOUNT 0

Sorry we do not have anything in SQL 2000

Really weird.

Try this

select idtransaction, failed, 'Constant' from transactions where failed = 1

Can you try with single quote around the subject line. I was just throwing point in dark. I never had this issue and I do not have a server with...

I think (not sure) you should have sql agent and outlook to be configured with same user.

group by <key> having count(*) > 1. This will find you the duplicate keys and then you can delete them.

Just a note. Make sure you have SQL Server is stop (or deattach the databases) or the sql files will not be defragmented.

setup link server and use fullyqualified object name

I ordered my copy. Just a note based on my 10 minutes reading.

I feel Dale Corey really took time and effort to put this...

"if you think there's something you can use"

The above sentence in the article has informed as indirectly whether to buy or not to buy the report.

check the owner of the table

Nice article. Vijay, keep writing. Take this article to next level (explain different types of joins hints , covering index). I wish I get time to write on these lines.

nice