Some activity happens too fast for sp_who or sp_who2 to catch.

-SQLBill

Also look at tape backups.......is Veritas Backup Exec being used? BE10d has the ability to backup files to disk and with the Agent for SQL Server, it could create database...

When you rebuild the indexes, that will leave more empty space in the database (.mdf) and the log file (.ldf) will be huge. You could just leave the empty...

I would reindex then shrink. Reindexing causes the log file to grow 1.5 to 2 times the size of the database being reindexed.

-SQLBIll

Another thing....you say the schedule is enabled, but is the JOB enabled? It's two different things. Right click on the job, in the pop-up list there should be either...

Are there any error messages? In Enterprise Manager, you should be able to click on Jobs and find the maintenance job. Right click on it, select View Job History, then...

You just open it to the IP address. That will give the user the ability to access any database on that server. You should be able to do it in...

Also, check out fn_get_sql in the BOL. It is better than DBCC INPUTBUFFER.

You might also want to consider using a trigger (ON DELETE) to help capture what you want. Maybe...

It contains whatever was backed up to it.

I do full backups, differential backups, and log backups. For me, my backup names tell me what they are. For example:

MyDB_Full.bak

MyDB_Diff.bak

MyDB_Log.bak

Without seeing your...

Check your named instance......it will be using a different port. You need to make sure that port is open.

-SQLBill

You can't trace past connections. SQL Server doesn't have any way to tell the time that a database was last accessed. It would take too many resources to keep...

The person is admin on the local box for his instance of sql server [end quote]

If he/she is a local admin on the server that hosts the SQL Server,...

This is a duplicate post and was answered already......but for the record...

Enclose the header with square brackets or single quotes.

SELECT mycol AS 'User Account'

or

SELECT mycol AS [User Account]

-SQLBill

Is the person an admin on the local box or domain? If so, they fall under the BUILTIN/Administrators login in SQL Server.

-SQLBill

Do you also use ROLES? See if the user is a member of a role. For example: John Doe is a user, but is also a member of the...