Our problem domain focuses around confidential development time/test data
from the clients. This data potentially includes very critical business value
data, so thorough protection of it is required.
This problem requires protection also in case of physical theft of the

In the FAQ about SQLMail, Microsoft said :
http://support.microsoft.com/default.aspx?scid=kb;en-us;311231&sd=tech
"To configure a mail profile for a service account, you must log on to
the server by using that service account."

Can you run a query to identify any database users who haven't logged into
the database for the last six months.
Thanks,
Omran

How to change a user's DB dbo connexion name?

I'm just beginning my database programming.  I've done a little bit of
research on security, just to get an idea of what's out there, and of course
I came across SQL injection.
I've thought about it, and I can't seem to come to a conclusion: If I

One of our programmers is going to write a program that involves some
sensitive data stored in the SQL server, using visual basic. Is there a way
to restrict him from viewing the data in the database, yet allowing him to do
his programming and debugging?

Hello Group,
I have restored a database to a server and want to change the owner from me
to the SA.  I have tried to use " Exec sp_changedbowner 'sa' " but get this
error:

Is there any way to deny access to BUILTIN\Administrators on just one database.
Very highly confidential databse and want to deny the access to
BUILTIN\Administrators.
Thanks

Is there a way to change the sa as loginname?
At work we are getting haked by 'brut-force', every second we are beinbg
attacked with sa and a password.
It's a matter of time when the password will be hacked, so changing the

I have several people on my team that are working remotely from PCs that are
stand-alone, ie. they have not been joined to the domain.  They do have an
account on the domain, though, which they use to map drives and such.  How
can I set it up so that they can use Enterprise ...

I'm not sure if this is the right group but I give it a try:
I have a job that executes a DTS-package which in turn call a store procedure
which calls another store procedure. The last procedure calls xplog70.dll
passing a filename (full path) to get some information back about the ...

As title, thanks!

On sql2K, I need the USER_NAME with alert on 229 error (%ls permission
denied on object '%.*ls', database '%.*ls', owner '%.*ls'.)
HOW ?
Thanks

Is it possible to grant execute permissions to xp_regread to a user who isn't
a member of the sysadmins role?

I need a query (script) or a tool to obtain a report (or audit report) for
all databases instanced into SQL Server, just for an entittlement review aun
audit reports.
The fields are: