Are you running dynamic memory allocation for the database server? If so, perhaps the server just doesn't think that it needs any more. I wonder what you'd get...

Yep. I had to switch to a new program and make sure it ran while I was working on it. I frequently try to remember to do a...

It's only 3.6gig now, we haven't brought our utility billing online yet! Also it's only been in use about 18 months with payroll coming online only three months ago,...

Andrew:

Arguments can be made that running a database in Simple Recovery Model is OK, I don't agree with that overall because it limits the recovery techniques that can be applied...

Did you thrash them soundly with a Cat6 cable? Be sure to use the ones with metal clips!

There's a reason why we back...

Same here! We have around 200gig +/- in ArcInfo databases, I think the new spatial support will add some very cool capability but it's going to be a whole...

I wish! I live in the desert (Las Cruces, NM). It's usually 100f+ outside in the summer when I get off work, the sand would be at White...

I assume that you have a test database that you can run your code against, or is everything desk checked?

I have no problem with the network admin guys not having...

2005 (or is it 2008? I don't recall) has login triggers and DDL auditing, so it would be pretty easy to track "last logged in" info. Have a...

Since there are so many instances, you don't have a single point that you can query to get that info unless all the servers are linked, and I think that...

I would create a job that runs a CMD file after your last backup should have completed that would pipe the log through Find looking for errors. Email the...

Not readily. You can monitor logins through SQL Profiler, but I think that's about it for 2000. With 2005, there's a lot more that can do this for...

It might depend on the version whether or not you have to plug in a key. I have to on my 2005 Developer Edition.

Browse the scripts section of this site, there's several that might do the trick for you, or at least give you the framework to write something that does exactly what...

Though you don't like counts, I'm doing something along these lines:

declare @cmd1 varchar(4000)

set @cmd1 = 'select ''?'', checksum_agg(binary_checksum(*)), count(*) from ?'

exec sp_msforeachtable @command1=@cmd1

By comparing the aggregate checksums, I have much...