Look up SQL Profiler in BOL.  It has instructions for creating a trace.

Mubeen, your query only shows who is currently connected to a database. 

Greg

Shyam,

Try posting your question in the SQL Server 2005 Administering or General forums.  This one is for submitting suggestions for improving the SQL Server Central website.

Greg

No, I meant the System Administrators server role.  My thought was if someone is a member of sysadmin, he/she has permission to do anything in the instance regardless of permissions...

Try adding users to the TargetServersRole role in msdb.  It's really meant for remote server administration, but it has the correct permissions for seeing jobs with being in Sysadmin.

You may...

What about server roles?  Is the login that the user is mapped to a member of sysadmins? 

Greg

I think Paul's last point is the most important.  Your business's tolerance for data loss dictates whether point-in-time recovery, and therefore log backups, is required.

If you make full backups with no...

If you're talking about comparing schema between two databases, there are a bunch of 3rd party comparison tools available.  We just purchased ApexSQL's Diff tool for comparing database objects and...

Ballack,

You're talking about something that you can only get if you audit DML statements on a table or if you use a 3rd party transaction log reader, like Log Explorer. ...

SELECT count(*) is the best way to get current row count in SQL 2000.  SQL 2005 has dynamic dictionary views like Oracle.

Greg

Naila,

In Enterprise Manager, right-click on the table and select 'Design Table'. 

Highlight the columns that you want in the primary key and click the 'set primary key' button.  Save the...

Perhaps user 'XXX' is a member of the db_datawriter fixed database role?  If he is, you wouldn't see an object permission for the user because the permission is granted to...

I don't think the error has anything to do with running the package in a job.  Here's the problem:

"Error string: Cannot insert the value NULL into column 'nomEmple', table...

DTS is a lot easier to use than BCP and you can transfer data in one shot instead of BCPing it out to a file then BCPing it in to the...

I read that Litespeed from Quest can restore individual objects.  Probably others can too.  You should use this site's search to find 3rd party backup tools. 

Standard procedure with native...

DTS packages are stored in binary in msdb tables so you can't search them with T-SQL.  What you can do is save the packages as files and search them.  There's...