You might have a large virtual log file as well, which could prevent shrinks.

Search for "forcibly shrink the transaction log" here. There's a script that can help, but be sure...

I think this is simple if I understand what you are looking for.

In the trigger, look for the inserted table and check if it's dates and code are inside an...

Look these up in BOL as the service accounts. These are accounts for carious services. If you need those services, do not remove these accounts.

The IP on the web server should be in one of the server variables. Keep in mind this is the connection IP, so it might not be the actual client...

Why would you not have one cluster, 3 nodes, 2 active, 1 passive. It's an N+1 cluster or am I missing something?

Who knows. It's hard to figure out on our end sometimes what works and doesn't. IE7 and firefox 2 seems to be fairly stable/consistent. IE6 has issues, but it's such...

Take breaks, communicate on the phone or even IM to get a better feel for people, go out with friends, try to get face to face contact. I know you...

Snowed in here definitely varies. On a bad day it takes 5-6 hours of solid plowing to get to the main road and I have to hope they've cleared that...

One last thing I'd say is that you should push to get your questions answered now. Once the check is written, technical information might be hard to get.

Now that's a good idea. I'll see if I can get one going.

Not right now, but you can use the "Active Threads" on the left to show those threads that have changed since you last visited.

You cannot get the actual execution plan in all cases, so the statement is false. Even if you query the system views, you get the estimated execution plan. That's still...

:), send the old and new emails to sjones@ sqlservercentral.com

I'll get things moved.

No easy way right now, but we're testing a new search feature for the forums. Possibly deployment later this week or next.

Matthias,

Thanks for the note and listening to us.

Steve