I have some users that I need to run stored procedures, but they can't
seem to run them unless they are in the db_owner role of the database.
How do I give them access to run the stored procs without giving them
the complete rights of the db_owner role?

I have the next question, and i would like to hear what do you think
about, and if is there a better solution for "my problem"
here is the question, I have a huge table with 60GB of data (image
files). The problem happen always when i try to ALTER the structure of

Could someone help provide a query that I can run to
determine the primary key and unique columns for any
given table ?
Thanks in Advance,

I am very new to sql and would like somebody to tell me if the following
table will maintain its integrity ....by this I mean if somebody other than
the database owner or someone who has permission to write data to the table.
Thanks for any help

I am using DTS to import tables into my new database from another
database, both of which reside on the same server. All the tables,
fields and data copy over fine; however when I go into design view of
the copied tables, the default values for all the fields are lost. It

I need to catch the SQL error messages, generated while executing a query.
Basically with reference to the Error Number, I can get the message from
sysmessages table. But that would be a raw one.
For ex, that would be like :

I'm relatively new to SQL Server, and I've come across a problem I can't
seem to solve.
I have several SQL Servers running in our network. We recently implemented a
new system for Human Resources Dept, which contain lots of sensitive personal

I have a full database backup on database A (SQL Server 2000).  Now I want
to restore only the tables from database A to database B rather than
restoring the entire database.  What are the steps to achieve that?

I have a client who has developed a customer sql based app. They want us to
provide hardware and installation. Looking for Tools or Rule of thumb in help
to size server to SQL application. Client has not been able to provide
requirement to us so we are looking to create a ...

I am new to SQL so please be patient.  I have a database in SQL 2000.  When
I expand the Database, Tables window, I right click on a table and select
return all rows.  When I try to edit data in some of the fields it tells me,
"Transaction cannot be started while in firehose ...

I am trying to log performance monitor counters to a sql database.  Does
anyone know of sql files that generate a database for performance monitor
counters. I need to create the tables and views.

i have a db set up that i access using an ftp connection, and an sql script
file that i wish to run, how do i go about doing so?
tia

Is it possible to create a unique constraint to a column from another
table? For example:
tb_current:
current_names

I want to set up Multiserver Administration.
The problem I encounter is a firewall between the master server and some
target servers.
What ports need to be set open to make this possible ?

So I installed an instance of SQL for an application (WSUS) and all was
well. Having read in many places that I could install multiple instances of
MSDE on the same box, I started the second install today (Live Communication
Server). The MSDE install portion of LCS gets almost ...