Considering that a derived table in a query isn't usually executed in 2 steps (ie, the query processor doesn't...

I used to have some of mine in my sig. Not a laundry list. Just 2 or 3. I put them there after a bad experience (on another forum) where...

That bracket right after the begin that shouldn't be there.

Meaning 1 day later than the datemax that the user...

The rest looks good (other than the varchar types)

What do you want to do with the resultset...

Jeff Moden (11/28/2008)

---

Before folks get into what could be a heated debate, Table Variables, Temp Tables, and Derived Tables (sub queries in the FROM clause) all live in the same...

rbarryyoung (11/29/2008)

---

I don't really have a problem with someone who has a bunch of certs asking questions on methodology or approach. IIRC, the certs don't really test for that...

You left out the equals sign in the procedure call. You had that part right last time.

When you installed SP2, there should have been a utility launch at the end to allow you to specify which windows accounts are sysadmin. On Vista and Server 2008, members...

There's a frighteningly small percentage that actually studied the material. Not many, but there are some.

Well, your procedure (as you posted it) doesn't have any input parameters, hence trying to pass one is going to give an error.

You don't need a variable called @ColumnName, you...

Jack Corbett (11/29/2008)

---

Are you trying to open the trace file using Query Analyzer on your PC? If you are that is why it is failing with the error because...

Ok, that's not of much help. I hate the way the errors are cut off.

See if you can find the job that runs the maint plan. Open the job, find...

Jeff Moden (11/29/2008)

---

True enough... but they are suppose to imply the ability to think and do a little...

No. I mean stop SQL server. The SQL service must be stopped before you can access...

You need to set the variable to the ID of the trace you're trying to manipulate. There can...