Hi SQL Experts,
I have a table like this..:
AgeCategory          RegimenLine
Regimen                        RefillID    Medicine

I've been tasked with creating a script that will put a Windows
account into a SQL 2005 database role.
Could somebody please give me a short list of steps that I should
follow?  (I'm assuming my list is incorrect or missing a very

Good day,
I have a sproc that resembles something like:
CREATE PROCEDURE myPROC
@title varchar(100)

Using the simple example below is there a way to change @Value from a single
value to a recordset result like using CopyFromRecordset
declare @xl integer
declare @rs integer

How do I use a query that has the "for xml auto" syntax?
I'm using C#...but how does C# get to use the results?
Anybody know?
Bob Sweeney

Is there any disaster waiting to happen to me if I use the "." character in
database and table names?
CREATE DATABASE [Cust04.DataCenter];
CREATE TABLE [Invoice.Lines]

I'm working around the limitation where sqlserver doesn't support cross
database foreign key constraint. Would there be a better way especially in
performance than having this trigger below?.  I couldn't think of a right
way to deploy table-joint for this. I'm using sql2005 ...

We want the authentication to happen without providing credentials
anywhere. For this we are planning to use Windows SSPI. Now the
problem I am facing is once the authentication from client to server
is successful, I want to use the

I open up "Microsoft SQL Server Management Studio Express", right
click on the instance name (ACER-55C1D4102C\DBNAME), click on the
Security tab, and...  Server authentication is grayed out.  I'd like
to select SQL Server and Windows Authentication mode but I can't - I

I have a report which has the following formulas from Month 1 to Month 12:
e.g. Month 1-
if left({ep04680s.PerPost},4)={@Year} and right({ep04680s.PerPost},2)="01"
then

I am an application developer, but I am rading some existing stored proc.
Some stored proc is used to support search function on web page, so I
expected it just complicated select with joins.
But I see the inside stroed proc, it create table #temp1, #temp2 and insert

I have a table of records consisting of a single text string that I would
either like to be put into separate columns in the same table or update a
different table.
I have done a 'CREATE table' SQL for the fields but how do I insert the

I have two db in my SQL Server 2005 engine. DB1 and DB2.
I have a transaction that work over the two DB.
If i start backup of DB1 and DB2 during the transaction, is possible have
this scenario: on DB1 the transaction is not committed and when start backup

after running this command, it shows me the info. like usecounts, objtype,
etc.  They are somewhat helpful.  Is there a way to look at the complied
execution plan that SQL Server generated for a specific stored procedure?  I
don't see it included in the system view.

I have a query, where there are two columns (quantity and actualQuantity)
which, when there is a problem there will be different values in each.
What I need to do, is set a third column to be of the value '1' when the
quantity amd actual quantity is different.