I have a stored procedure which inserts some data into a table and
then runs a select on the table.  I have granted execute permissions
on the stored procedure to a user x.  Although user x has no select or
insert permissions on the table the stored procedure will run, as I

I inherited an Access application which appear on the SQL side to only
be accessed by the "sa" account.  There is not code that uses the
login.  How is this possible?  The database owner is the sa account
but other than that how do the users authenticate to SQL?

I am running into some issues with SQL Server 2005 not allowing users to
connect to it if I just add their AD group instead of individual logins.  I
have verified that they are in the group and using it in other areas works
great, but they can't access SQL Server unless I add ...

Can someone give me some real world experience best practices for sql
administration?  Is it better to have a special domain account to use when
doing sql administration?  What permissions are required for managing a SQL
server?  Does the SQL administrator have to be a local ...

  I have an existing production archive/copyback process. Using 'sa'
authority, it archives records from one db to another archive server. In some
cases buisness can request us to "copyback" some of the archived records from
archive server. Tables have identity columns on it. I ...

  Server 1 is a linked server on server 2. I have a process that does a
bunch of selects/inserts on server 2 and also does an update to 1 table on
server 1 using the linked server. When this process runs, what we see is that
95% of the time is spent in the update to 1 table on ...

I've got a web app (myApp) that users log into using SQL
Authentication. The users enter their userid & passwords into a login
form and these are used in the connection string for the rest of the
session. Users are assigned to SQL roles that dictates what

There is a user in a developer role who has been here since before we changed
our domain name.  This developer has less permission on the server than other
developers.  Developer is a domain level group.
All domain information was ported from the old domain to new domain (per

I want to make a trusted connection from a webserver (IIS 6.0/5.1) to a sql
server (2005)
How do I do that ?

How do i give execute privileges on stored procedures to an account?

I have a windows service that does some distributed transcation
across 2 servers. One DB is SQL 2005 express  and the other is SQL 2005.
My question is I have created a domain user account and I am
logging the service in as that account. Then I am adding permission to

My syntax appears to not work for column 25 (counting base-1 or 24 base 0 -
EDI_SENT).  Also is there a better way to do this (audit)?  Note:  One of the
two servers involved in the transactions uses SQL 2005 rather than 2000.  We
have mystery values showing up in the EDI_SENT ...

I have recently migrated several databases between 2 SQL server 2K servers,
and used backupexec in this process.
Backup from old server, and db restore to new server. Migrated all logins
with a stored procedure I found in MS's knowledgebase.

I am trying to reconstruct the roles from one database to another.  How can I
generate these scripts?  The scripts will need to include the permissions to
all tables within the database.

¿Are there any way to protect a database that is reditributed with a desktop
application? I want to protect this database with an user and a password,
something like access, but with SQL Server 2005, if you have SQL Server 2005
Management Studio, you can access without any ...