Please post sample data, required results from that data, the solution you currently have and what is wrong with it.  That'll get you an answer much faster than you can...

As far as I know this is pretty hard to do.

The only thing I can think of is to create a new table with the correct properties set up.  Then...

That means that you are restoring the files to a destination that already exists.  That would be a huge a warning to me that you were about to destroy a production...

Can't you use the scripting methods built-in the GUI!

Why are you unable to create indexes on the system?

Please do not cross-post, we monitor all questions, follow this link to finish the thread :

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=380063

I like the way you spam the forums with seemingly usefull questions only to push your URL.  It's a very neat idea.  You may also post job postings in the...

The only PitFall I see in my idea is the fact that the users need to have DDL_ADMIN rights.

That's why I was using a second process to delete the triggers...

It means just that.  You are trying to insert a value that already exists in the primary key.

Can you post the code you are using so that we can show...

Quoting myself : "But I agree with  your point about code reuse.  But on the other hand, how hard is it to scan the server side code for the datediff...

Lol, 10 to 1.  Ya that's a close decision .

Also 10 000 rows 100 times / day = 1M rows.  That is another scenario where you can shade a few more seconds off the server's hands.  I know it...

That would be another problem altogether.  They both would kill any hope of index seek.  You should adapt the date range to fin all needed rows and not the other...

Why add the overhead of the function call???  It's not like that this is a very complex condition that can't be explained without documentation.

Could you take 2 minutes of your time and post your findings here?  It may help someone else in the future who finds this thread in a search.