You need some type of server side component to do this, like an ASP page. There are some articles on the site showing this. Or you might to better searching...

We considered a CD, but the cost and packaging logistics didn't make sense for us this time. We'll see about the future. Since this content is also online, it was...

That's a great point. If the server is running, but your database isn't, then is it up? Probably not.

You might be better off having some other process on another box...

sp_help_job is my favorite

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Andy's a big fan of app roles for this reason and he has some great arguments for this.

Personally I confront them and their boss and explain why they should not...

You might need to remove more stuff. There could be entries or something else in the registry or filesystem that is left over from S2K. Is there a reason that...

Some great essays from Counterpane founder Bruce Schneier exist on their site (www.counterpane.com). Disclosure is a battle and I'm not sure how much time we should give vendors. They should...

1. Sounds like some "driver" type or unregistered COM interface issue. Can you query AD from VBScript on that machine? I'd be sure you can do this first.

2. The querying...

uptime.exe is a resource kit utility that will also show you the uptime for the server. If it's a dedicated SQL box, this should be close to SQL's uptime, though...

Haven't seen that so much with SQL. Have seen issues with IIS. However, if the mdf/ldf are fragmented, multiple growths, then it could be an issue. Be sure to check...

Check out SQLCompare from Red Gate. Low priced and seems to work well.

Our own Andy Warren loves it!

http://www.sqlservercentral.com/columnists/awarren/reviewofsqlcomparisonandsynchronizationtoolkit.asp

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

AFAIK, there isn't a slip stream for SP3. If there is, please correct me. I could use one!!!

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones

http://www.dkranch.net

Setup an alert, prefereable page, to let you know when it gets XX % full. Probably 70%, but if it seems to fill quickly, then you might want a lower...

I tend to create a view in the first database to access the second. Helps if I need to move things by abstracting. Also doesn't tie my code to some...

Personally, I'd abstract it. Set up a table and have the Access front end insert users into this.

Then have a stored procedure the reads this table (top 1) and runs...