Haven't seen that.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

First method (in general). might denormalize for performance if needed.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

AFAIK, it's limited by disk space. No limit to number of rows.

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

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