Lowell (4/7/2009)

---

duh...format 121 does exactly what you need, sorry i misread:

FormattedDate ...

GilaMonster (4/7/2009)

---

run sp_recompile and pass it the table name as a parameter. This will mark all plans based on that table as invalid and force them to recompile the next...

ahmer:

Attach it as a txt file.

Glad we could help!

It depends a lot on the details. Can you post at least one of the queries that you are looking at, its query plan (as a sqlplan file) and...

Common? No. But most of us do not use the query expression wizard that often, it's just faster (and easier, IMHO) to type the queries yourself once you know...

davboudreau (4/6/2009)

---

I have a small problem here.

Has anyone ever newly created a DB, and every time you want to create a view

all you see when adding tables is the...

I think that 'tmpOldQuery' should be '@tmpOldQuery'.

I'll echo what some of the others have said: when I point someone to Jeff's article, it is almost always because I do not think that I can answer their...

majorbloodnock (4/6/2009)

---

Well, I expect you'll get a lot more posts to this thread agreeing with your article, albeit (frustratingly) all from people who wouldn't commit that cardinal sin in the...

Fair enough, Gus.

Maybe it's just a language issue Ramesh, but what you are suggesting sounds unethical.

Apparently the Deleted pseudotable is not available in the subordinate batch that your dynamic SQL has to run in. Try dumping Deleted into a temp table first.:

ALTER TRIGGER [trgInsertAudit]

ON...

Well that one was no assumption. ...

Thanks, Steve. And agreed.