What's the error message??

Can't see any error in that query...

Hence the term MVP used to qualify Frank .

Given that you have tried everything else in mind, and that you have no other idea, then I'd go for it unless it can cause problems for the users.

The gurus are recognized as MVPs (like Frank Kalis)... I've still got a verrrrrry long way to go before I can learn half the stuff he masters. I'd put...

I see.. nice to know.

I also like dates as primary key but I don't have many range queries so it's maybe not as usefull.

If you use dynamic sql, then yes... but I was assuming that you were gonna use a stored proc as best practices suggest.

Assuming you got the column names right then yes. The only thing now is to modify this code to handle a list of keywords passed in parameter. Do...

You got to help me out here... can you post the INSERT SCRIPT for all those lines... don't really feel like typing all that to help you.

I think this will...

You have to create an on update trigger to handle a task like that. Otherwise you'll have to buy a log reader to read the transaction log. ...

Is this some sort of recurring stored proc?

Also I'm already gonna say my conclusion. Avoid gotos unless it's for err handling. Just go with a bunch of well...

I've already answered your question here :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=186697

Backup database and restore to new server or new name is your fastest/safest option.

Or you could use dts copy object task to do this... but it's really not full proof...

do a select top 20 in query analyser, copy and paste the results.

It could be even better if you could paste the insert scripts instead. You can create them...

Just make sure you test to see which performs best in your environement. There's no clear cut answer to this problem (even if it should really be done at...

Ya obviously... just never occured to me to have the clustered index not unique. Have you come across a situation where it might be the best way to go?