jpowers, best of luck in finding something.

Thanks again for all the responses.

One thing I thought of recently is that most of the "fads" and "new things" that are put out...

The SARGable argument, for me, would make me lean towards straight integer or character columns.

It sounds like a security issue from your description. I would contact your web hoster with the issue.

Ah, but less and less all the time. I remember when I...

This one?

http://www.sqlservercentral.com/Questions/Tags/System+databases

I agree with Gail. Think about what happens if your database fails 10 minutes before the next full/diff backup. How much work is gone since the last full/diff?

That's a risk,...

GilaMonster (5/15/2009)

"In the jungle,

the mighty jungle..."

Thanks for the kind words. I was definitely a little melancholy the day I wrote this one.

Kind of funny that as I read the comments here I'm installing W2K8...

I always here it referred to as the Resource database, so I think it's getting straightened out.

If any of you talk to MS, I would like to know what they say to you about the licensing.

It makes sense that you would license logical procs, but only...

you can get logs from the package itself. The Agent log has no information in it.

I'd enable logging for the package and examine those files for more information about what...

Gail,

sorry to hear about that. I can sympathize a little. I had a car when I lived in San Diego that got broken into 3 times in less than a...

I'd look at VBScript, or perhaps adding Powershell to the servers, and using those to get the space. You can even insert the data into SQL Server from VBScript.

The FileSystemObject...

what have you changed? And how much data is being replicated?

It depends on the transactions, but in most replication scenarios I've had, where we're moving 2-3 tables, we have seconds...

Nice one, Larry.