I have a SQLServer with many databases.
I have set up a standard user that specifically has access to just one of
the databases and their permissions are restricted to just reading/writing
data within that database.

I'm using a stored proc to delete a record in two tables (in two different
databases) and I keep receiving “Error Number: 229 -- Error State: 5 -- Error
Message: DELETE permission denied on object 'ewBehaviour', database
'eWorkSpaceV5', owner 'dbo' ”.  The stored proc works for ...

if a user runs a dts package from a command line say something like this
C:\>dtsrun /s ServerName /u username /p P1l0t /n DTS_Package
using that /p password switch is the passwork example above P1l0t saved off
somewhere in a log file?

We have recently installed SQL enterprise manager.  I was testing the security to the databases when I realized that if I login to XP under a standard domain user account, open MS Access, create an ADP project, then under connections, pick the sql server, I can see and pick any ...

Hi,
I am a junior DBA for SQL Server. I have some tables in the production that
want to give update access to group of data management personals, but without
giving them access to update the table directly. If I create an update-stored

Hi everybody..
Could somebody help me out?  
whenever I try to connect to my Local Server, i gett an error
'A Connection could not be established to <<SERVERNAME>>

The following question may be trivial, however, I just can't make it clear to
myself, even after reading through the Books Online.
I have two machines in the same network.
A hosts Sql Server (named AS), B access the database ASD in Sql Server AS.

I have a DB with SSN. I would like to encrypt using HashBytes with salt.
I ran
UPDATE tablex
SET essn=HashBytes('SHA1',ssn+salt)

We have a DTS package that is password protected. The developer has since
left the company. Is there any way to change or crack the password?

I have a problem with database access that I would like to sort out.
1. I gave a Windows 2003 server with SQL 2000 (SP3)
2. I decided to create different Windows Groups and add Windows accounts to
them to access different databases

I'm trying to use the DOS copy command to copy a file from the servers local
drive to a mapped network drive (to a share on a different domain).  When I
run the command in DOS, it works just fine, but when running the same
command using xp_cmdshell I get an error: "The system ...

I have just installed SQL Server using the administrator account and
mixed mode (I did not know any better).
Baseline analyser subsequently told me to sort myself out and use a
domain user account for both the SQL Server and SQL Server agent

Our application using an SQL 2000 database, which is currently using Windows
Authentication. For some reason, we need to change the access mode to mixed
mode. Could someone please throw some light on the impact of this change.
Thanks in advance

I have a server that crashed, so a new OS was installed.  I now have access
to the drive where the database file exists.  I am now trying to either copy
that file onto a new server or reattach it to a new insance of SQL Server.  
In both cases I get a Access denied error.

sql server 2000 sp3
sample scenario: 1 user called userA. A few tables and a few stored
procedures. SQL configured for mixed mode auth. userA is a windows account
added to the database. IIS 5 configured for integrated windows auth.