i had the same thing in my test script. i'm going to rewrite it so it runs only against selected tables and indexes and the rest will get offline indexing.

where are you getting the data for the numbers that have been won in the past?

where is the log?

we have a high end HP server with storage on a SAN and updates that affect 300 million rows take a few days to complete. i wouldn't...

if you do a rollback, it will probably take a while

what kind of hardware are you running on? we have a test environment for sql 2005 on some ancient fiber...

do an sp_who2 every few seconds and you will see it running at some point

most likely you have I/O roadblock and it's waiting on I/O to finish before going forward

i found the problem

the database id's are different and i just copied and pasted the script and forgot to change the db id across servers

MS revamped their whole certification track. I like the new MCTS for DBA's. No more windows tests which means a lot of time and money saved

not sure about the current version of MOM, but the original was a lite licensed version of some well known monitoring product called NetQ or something like that with MS...

build windows cluster

install sql2005 as default instance

install sql2005 as named instance in another cluster group with different hard disk resources

keep default instance on one node and named instance on another...

is it blocking it as spam or is it a relay issue? similar solutions but if your server is not on the allow to relay list then its email won't...

i'm pretty new at this myself but i don't think you can allow nulls in a FK column since it has to match up to the PK column. if you...

/* Declare Variables */

DECLARE @objectid int;

DECLARE @indexid int;

DECLARE @partitioncount bigint;

DECLARE @schemaname nvarchar(130);

DECLARE @objectname nvarchar(130);

DECLARE @indexname nvarchar(130);

DECLARE @partitionnum bigint;

DECLARE @partitions bigint;

DECLARE @frag float;

DECLARE @command nvarchar(4000);

--...

have you run sp_who to see what is running?

i think you have to buy the dev version separately. it's like $50 or less if you use a corporate account

is there a difference in service pack levels beween the machine you used to back up the db and your machine at home?