why not change all the view ownerships using sp_changeobjectowner,

once done then drop the users 😎

if you want to find disk space used on a server you could try a WMI query to get the info required.

Alternatively try BGInfo utility from sysinternals

its not quite as simple as that

do you mean

active\active

or

active\passive

yes and this message is fairly descriptive,...

my guess is 1 of the filegroups is already empty.

check your filegroups to see which are in use!

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?