I have a developer who has dbo privileges in master and msdb, and also has
VIEW SERVER STATE and VIEW ANY DATABASE.  According to SQL Server 2005
documentation she should be able to view the Activity Monitor, but instead
gets the following error:  

Has anyone used the Encrypting File System (EFS) capabilities of the OS to
encrypt the sql server 2005 data files? I am looking to do this but cannot
find any examples/instructions. Thanks.

I'm using windows authentication on sql server 2000
Suddenly i got error when i'm trying to access the sql server from my
computer 'Failed to logon user 'Null' . not .....
How can it happen?

-On the Principle (sql1) I have a Database named dbBooks
-I create a SQL Account called Dog and password of Cat and give it
read/write to dbBooks
-I fail the morror to (sql2) , Dog is an account on the databse, but not at

We have loaded the hotfix that takes care of NTFS permissions being
reset when detaching and attaching a DB - but when a user creates a
New DB - the NTFS file permissions get reset and are not the
permissions that we want to be set as default.  The permissions we

I just moved my databases from an older Server to a new  windows 2003 SP1
server.  I was connected and all my jobs ran fine last night.  All of a
sudden this morning I tried to connect thru EM and I get the following error:
"A connection Could not be established to (local)

Hello, I have a sql server 2000 production database that will need to have
multiple web sites insert contact information into a table.  I plan to
create a new sql user and only give it permission to execute one stored
procedure (that will do the insert row into the contact table).

Can someone provide me a sample of how to search encrypted column?  Using
below method seems pretty slow.
select FirstName, LastName,
     convert(varchar,decryptbykey(SSN)) as SSN

I have a table with 3 fields:
val1
val2
val3

Since local admin has full control on local file, so he can
always use detach, copy and attach to access the database contained in the
db files. Thus it is immpossible to seperate the role of computer admin with
the dba role, am I right? Anyone has any idea on this? Thx

I have SQL Server 2005 SP1 installed on win2003 SP1 with two instances
(default and \instance2).
The server is set up with mixed mode authentication.
SA is setup with the same password on both. The domain user

how do i set sql2000 so that  a user can only read or execute
user-stored-procedures?
Leon

In a database I created an audit table in which, e.g., I insert one record
for each INSERT statement made on another table (via a trigger).
My problem is to recover remote IP address of the connected client which
does the INSERT.

Is there any link where I can see how the new security model wrt
keys/certificates work ? I am looking for examples. to play around with.

Hi, (excuse my poor english).
I want to access data stored on a SQL2000 server using
"SELECT * FROM openquery(SQL2000srv, ..." from a
connection on my SQL2005 server.