I rejected it from the onset w/o knowing anything on it.

Does anyone know of people using this to do SQL Server backups/restores ?

I thought I would put it in the correct Forum. (made a mistake originally)

So SET LOCK_TIMEOUT should stay at the default of -1 (indefinite wait) in the database ?

what alert is that exactly ?

real time of course.

Log shipping or replication ???

What are the bad points about denying access to the BUILTIN\ADMINISTRATORS group ?

--> Members of the Local Admin. group will still be able to access the Box correct ?

(I would...

An Admin. could turn off Auditing correct ?

O.K. Since I don't know alot of these Admin. people personally and our Data CANNOT be visible. This is my plan :

1. Deny...

Understood.

But, my point is if BUILTIN\Administrators group is enabled(has access), any member of the Local Administrators group could log in to SQL Server and have full System Administration power.

Why...

So bacically, with the BUILTIN\ADMINISTRATOR Login still enabled :

A member of the Local Admin Group, even if the SQL Server is registered as SA, can logon to the Server, edit...

as an add-on to bkelleys's comments,

"There is a basic tool I believe in the SQL 2K Resource Kit for general stress testing"

This "tool" is called Database Hammer.

A customizable tool...

Database Hammer in resource kit.

you'd think if a Job was stored locally one could see the Job Details.

Will the Process Info. tell me anything ?

I need the Host Name. But if its a Job stored locally I don't think it will show a HOST name when it...

If I run the job it just says the "Job was invoked by Schedule 89(DTS_0000000001)". That's it. I have no other information.

I think this was a DTS Package created on...

Under the Job properties....

Command :

DTSRUN/......bunch of #/letter combination.