to clarify on Karl's point further

create a domain local security group in AD which is assigned to the resource (i.e. add to sql server security as a login).

Then create a...

how many files\filegroups does the database consist of?

what OS is the...

select from sys.objects where the object_id

what does it return for this?

my my, as tasty as that 😀 :Whistling:

rdavid (8/26/2008)

---

I have a stored procedure that uses a "Where InvoiceID in (16,17,18)" construct.

If I define the input parameter to the stored procedure as nvarchar (which is what I would...

Lynn Pettis (8/25/2008)

---

True, but my knowledge of the problem domain was limited by the information provided. With OP's last post, my understanding was enhanced and the solution provided previously...

the roles are in the MSDB for that instance. Edit a sql users mapping and under MSDB you'll see the...

are you sure you want to drop all indexes?

you have the scripts to re create them?

the group by would be required for the count function i think

marius.draganescu (8/25/2008)

---

Perry,

It looks like this is it!! It is working...

can you recommend a book/ website/ anything else I could use to learn the more complex TSQL from? I...

whether you step through each index or grab the database name and rebuild all its indexes it'll take the same amount of time. I would use a cursor to grab...

how many nodes\sql instances are in the cluster

ensure users are mapped to one of the MSDB standard DTS roles

db_dtsadmin, db_dtsltduser, and db_dtsoperator

or create and assign a custom role. Users need to have correct permissions to execute...

no problem, table aliasing also helps to compact\tidy your code a little (dont...