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.

By definition, if the trigger fails, the WHOLE transaction fails.  I'm sure there are ways to go around this but I'm more interested as the WHY do you want to...

I don't have any metrics to give you.  The short answer is if you don't suffer from performance problems on that machine, then you're alright.  Specially if it's only a...

SELECT * FROM LnkdSrv.DbName.dbo.SysObjects WHERE XType = 'U' ORDER BY Name