It's an interesting question, and one designed, IMHO, to see how you think. Proving a negative is always hard and to me the question doesn't make much sense without more...

Try this

declare @val varchar(200)

exec xp_regread @root_key = 'HKEY_LOCAL_MACHINE'

, @key = 'SYSTEM\ControlSet001\Services\MSSQLServer'

, @valuename = 'ObjectName'

, @value = @val output

select @val

Might have to alter for your server.

You should be able to fire off a task from the Service Applet. After xx failures, send an SMS message or email to yourself from there. Is this W2K3?

I've tried Excel, Outlook, and Project to do this and it was a mess everytime. The biggest reason was the granularity of minutes for jobs instead of hours or days...

Be sure you change the filenames. By default it has the file names for the existing db. In the EM dialog, change the db name manually after picking the backup...

How many connections are we talking about? They all use a small amount of memory, but it would have to be thousands and thousands to crash SQL.

You might try some...

John has great advice. It makes sense to do optmization and integrity checks first so if there are issues, then you can get an alert and be ready to fix...

OK, bad question. Also, ping MS on the documentation to change it.

Points awarded back.

That's interesting as well. The developers are working on the basics now, but I'll definitely ask they watch this thread.

STeve

Yeah, some of the nav is buggy. We're on a rewrite as I, well, write this, using the newest version of the forum software.

Apologies

Henk,

I put in a request to the artists for one and I'll implement it as soon as I can.

STeve

Sorry, my US brain keeps getting confused with 27/03/2007? I guess the Month name makes some sense. I'll check on where we are with this.

It seems that as I talk with more people and get emails from this, that drivers are the biggest issue with Vista. Especially for home users with all sorts of...

I saw a few notes that only the add-ins will be Shared Source, meaning you'll need VFP9 to use them. I guess someone could adapt them back to 6, 7,...

You could do a union, with the WHERE clause in each specifying if that part of the union is getting inbound or outbound.

select sum(), count()

from phonelog

where direction =...