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...

Please don't demonstate a vulnerability. I like full disclosure, but contact the company first and explain you "stumbled" upon this. Maybe even use an anonymous hotmail account. Or better yet,...

Check that something hasn't changed on the file system. Can you write to a different file? Different folder?

Steve Jones

sjones@sqlservercentral.com

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

http://www.dkranch.net

Greg has a good point. Before you change something like this, be sure there is not some reason it is setup. The last thing you want is to turn off...