Viewing 15 posts - 8,941 through 8,955 (of 9,241 total)
your original post above indicates you need to drop users who own views??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:29 pm
ang
what is the output of the following query run against your database?
DBCC LOGINFO
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:21 pm
why not change all the view ownerships using sp_changeobjectowner,
once done then drop the users 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 2:13 pm
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 1:47 pm
ss1011 (8/28/2008)
we would basically drop in the two files after stopping the service.
its not quite as simple as that
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 6:49 am
do you mean
active\active
or
active\passive
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 6:35 am
Imke Cronje (8/28/2008)
File ID 4 of database ID 5 cannot be shrunk as it is either being shrunk by another process or is empty.
yes and this message is fairly descriptive,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 4:40 am
my guess is 1 of the filegroups is already empty.
check your filegroups to see which are in use!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:50 am
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:30 am
how many files\filegroups does the database consist of?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 28, 2008 at 3:26 am
Adam Bean (8/27/2008)
Weird ... I'm a local admin ... I just got done installing 2k5 standard and SP2 ... SP2 went fine, except for this one piece.
what OS is the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2008 at 4:26 pm
select from sys.objects where the object_id
what does it return for this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 27, 2008 at 1:31 pm
Fishbarnriots (8/26/2008)
The file looks like a complete dogs dinner
my my, as tasty as that 😀 :Whistling:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2008 at 10:15 am
rdavid (8/26/2008)
If I define the input parameter to the stored procedure as nvarchar (which is what I would...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2008 at 10:13 am
Lynn Pettis (8/25/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 26, 2008 at 10:10 am
Viewing 15 posts - 8,941 through 8,955 (of 9,241 total)