Dear Friends
I want to use the encryption for the MDF files so that no one can just copy
the data and attach the MDF files to access the database.
When i have done the same the database is in Suspect Mode. Please suggest

Anyone any clues? TIA Simn.
I can run the following sp fine in isql (and vb app) when logged in as
Administrator, but not when logged in as a User who has dbo rights in THISDB
(would rather have less..) and public in OTHERDB. Am using Windows auth and

We do not allow anyone except DBA's the DBO access permission in our
organization for the "production" environment.  The programmers get
DataReader/DataWriter access in production, however, they are wanting
read-only access to the stored procedures.  

I have already posted this but have not received an answer.
Hi there,
             I have set the proxy user details using
xp_sqlagent_proxy_account 'set' and the command completes successfully, so

I'm trying to access SQL Server from an application that is a service
running under the "Local System" account in a computer which is not the same
as the one running SQL Server. The service must run under this account, and
still should have access to an SQL Server database.

I need some advice.
We need to encrypt data in transit between a fat client and SQL Server,
using either AES or 3DES encryption. We will have about 500 clients and
probably clustered servers. Can anyone give me advice on the best way to do

I have created a database in server SRV1 with user 'aaa' as database owner
Know if some body detach this database from SRV1 and attach them on other
server same SRV2 with defrent sa and defrent users 'SA' user in SRV2 has full
access to may database

Windows 2000, SQL Server 2000 SP 4, Windows Authentication. We have several
developers, all in a Windows domain group, and when one developer creates an
Agent job, that job is owned by that one developer and is not visible by the
other developers. Is it possible to have a job be ...

My problem is simple.
Last week I modify my application that connect to a SQL Server 7 to use
Windows Authentication. Before, it use SQL Authentication.
Since I made that change, my application response slowly than before. I use

My customer has a lot of govt customers and has a non-classified SharePoint
2003 implementation with SQL2K for the backend (all SPS 2003 content is
stored in SQL server). They're very concerned about what to do if/when a user
unintentionally uploads a classified document to the ...

I have 2 SQL servers (SQL1 and SQL2) residing on two Windows servers (Win1
and Win2).  I want to back up a database (mydbase) from SQL1 and restore it
to SQL2.  I am using Windows authentication, and I would LIKE to be able to
do this without rebuilding the User list every time.

First question:
I have a user that is admin on the server to perform security patches and
general server maint.  He is also a user in SQL.  Since he is the Admin of
the box he has also inherited Admin rights to SQL.  I want him to have only

   Is there any way to check the password just to allow into the SQL Server
when it matches with the database password including Case.
   My problem is I used a sqlserver connection string to login to my sql
server db. But it is allowing me, even though the user types the ...

  I'm have a user called "developer" with rights create procedure,
db_datareader and db_datawrite. When i try to create an sp with owner as dbo
i'm getting the following error
"Specified owner name 'dbo' either does not exist or you do not have

I want to run distributed queries via a linked server using a windows
autheniticated login.  Talking with our AD/network admin about the steps in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_sec
urity_2gmm.asp
they have a problem with setting up ...