Jeb58,

I agree that the author's intent appears to be to indicate that defaults assumed in object name resolution aren't going to get you a cache hit, but there are all...

This article is very misleading on one important point.  The article comes very close to stating, or at least implying, that you must specify owner names for cache reuse to...

> My original proposition was, if I am to be true to myself, sort of a T.I.C. mini-troll. 

I wondered whether that might be the case, but one way that...

> The "correct" answer clearly states that the deleted table holds the reocrds ABOUT to be deleted...

Well, when an AFTER trigger fires for a DELETE, the rows have been...

Yeah, you nailed it, Julia.  I hope CEWalden is still following this thread, because unless s/he needs the potential flexibility of the expanded script I posted, what you posted is...

I appreciate your comment, and thought you might be interested to find out that I chose WHILE @@FETCH_STATUS != -1 very deliberately.

To begin with, @@FETCH_STATUS = -2 does not mean...

No, keep speaking up, dphilip!  It sounds like you've got a lot of good thoughts to share.  We all misfire once in a while, and hopefully it's usually on something...

Um, I don't think the local system account's password is accessible, or changeable, by mere mortals.  Are you talking about the local Administrator account?

Cheers,

Chris

Regarding another point:  I have certainly written a single trigger for insert, update, and delete that references the inserted and deleted views before.  Many times, in fact, at one job. ...

Regarding one point raised:  actually, there isa deleted view for an insert trigger, and there is an inserted view for a deleted trigger ... they just don't contain any...

Hello Walden,

Here's one way.  Have fun! 

declare curIndexRebuild cursor

for

select N'dbcc dbreindex (''' + db_name() + N'.'

     + user_name(t.uid) + N'.' + object_name(i.id)...

You're welcome!!!

OK, it's late here, so somebody may well jump in with a much better idea, but if you don't mind a little cut-and-paste, run the following query and then execute...

I agree with Steve and stacenic, but would add that if your database gets so big that you can't get your backups done inside your target timeframe, then multiple filegroups...

Wow, I don't use that part of DTS really, but that's a zinger of an error to get - it's what you'd get in VB.NET (and many of its variants)...