I certainly could be wrong about BI, but I'm not sure it's the current big thing. It certainly is popular, but I'm not sure if that's few people using it...

bump?

If you recompile the proc, meaning changing the code, it should take effect immediately. If you recompiled to get a new plan, that may or may not take effect, depending...

It's not W2K3. Likely something didn't install correctly. You might try uninstalling the SQL client tools and adding them back.

I think Litespeed can do this. Not sure about the other backup tools.

There is no way in SQL Server to do this other than restore the database as a new...

You could write 3 queries and union them. Not sure it would be faster, but possibly. The LIKE is not that efficient compare to other techniques.

Perhaps you could pull off...

My guess is you're doing too much work in the trigger. Trigger code should be tight and do minimal work.

I would agree with Sergiy, though I see Kenneth's point.

The reason, in my opinion, that the square brackets came into being was due to extensions to SQL. Many common words...

Kenneth has the only items I know of (unless you had a trace running).

ApexSQL has ApexLog

Lumigent has Log Explorer

Red Gate has Log Rescue

Probably more out there.

Thanks. Please put suggestions for other stuff in here. I watch it and often this goes to the developers.

Al,

Which tool? I've used ER/Studio and ErWin. Didn't like ErWin, like ER/Studio, but both $$$.

I don't worry about getting rusty, that will drop off fast. Being a good employee, communicating, etc. shines through above technical skills in many jobs. The basic principles of being...

That's a good one. I'll see if we can get a query for that one.

One of the issues is that we used a purchased forum code so that we didn't...

Let's hope. I get tired of moving stuff around

It should, but I didn't trust my high school Latin to find the word

If you figure out the schema tool thing, write me an article. I'd be interested to see that work.

I think some people use it when they do an all...