How can I see the backup with  the tools log explorer because I can´t open
this log. ldf?

Either revoke/deny doesnt work or I dont understand the concept correctly.
I need to separate the duties of SA and DBO for SOX :(  
I am planning on creating 2 new roles in every database.  Securityadmin and
DataAdmin.  

How to do encryption and decryption?

Hi, All
I use SQL Server 2000 and Win 2003 Server. I try to create a SQL Server
Login audit log using Profiler, but cannot find the tools. I looked at the
Windows Event Viewer, it only logs Windows authentications users for SQL

We are using mixed mode authentication (users connect to SQL Server using a
SQL login for historical reasons).
We want to setup SQL Server / Windows Server to only allow users from
specified domains to be able to login with this SQL login.

Does anyone know of a sample script I could get access to that would
automatically compare disabled/deleted domain accounts to the SQL Security
Logins and keep them "in sync" without any interaction from the SQL
administrator?  We're wanting to eliminate the need of sending ...

I'm a new Sql Server administrator and I just received a shock ...  We've
set up a pretty much default instance of Win2003 server and SqlServer 2000.
Just told the developers that I'd set up a test Sql Server instance and told
them the name. Shortly there after I found that they ...

I've made a user a member of the db_owner role of a particular database.
However, this account does not have permission to execute a stored procedure
and I can't figure out why. The error message is shown below...
Server: Msg 15247, Level 16, State 1, Procedure sp_addmessage, Line ...

I have a SQL Server 2000 in my head office, it has several databases.
However, one of the databases is maintained by a colleague of a regional
office. He has the all the authority (read / write) to work on this database.
But there is a problem, we have developed some DTS packages ...

I want to communicate to SQL Server through my client. Server is listening
via port 16433 instead of defualt 1433.
And this particular server is on the other side of the firewall and it is in
a workgroup. Client Server is in a domain.

What is the best practice for authentication to Win2003 Server with SQL
Server 2000 database?  For example, an Access 2003 application that would use
a ODBC  pass-through query to connect and select (read only) data from the
SQL Server database.  Would prefer to hard code the ...

how can I view the transactions of a ldf file?
i'm new here
thanks

I am trying to configure SQL so that a user without admin privileges can
execute xp_cmdshell.
I understand I needed to do the following:
---------------

The scenario is like that,
 Database "DB1" on the Production Server  ( Prod1 ) in Sydney has to
maintain the standby database "DB2" on Standby Server (Prod2) in Brisbane.
 Proposed solution is to setup manual Log Shipping by copying of transaction

Has anyone adapted the sp_MSdbuseraccess SP so that users other than
sysadmins cannot see the system databases when they log in?
Thanks - Jean.