If this isn't helpful, I apologize. I had the same problem and here is what I did ...

If it doesn't help you, maybe it will be pertinent in someone...

THANKS! I needed that too. I love SQLServerCentral.com.

mmmuah!

yep ... it was totally the stored exec plan, but i guess i didn't hit all the necessary statistics to force it to recompile to use the indexes favorably.

i went ahead...

In 2005 it asks you what you would like to run the agent under.  I choose the service account.  It warns you that this isn't the best security practice, but...

much thanks ... I see what you are talking about now.  I unchecked it and let the index create run for a while ... it didn't time out.  so I...

NEAT!  Yes, I'd like to see the info from your ticket.

Thanks for both responses.  I guess we'll be keeping 2000 around for awhile then.

Thanks for the response!

Here are my settings currently:

Connection Properties->Execution time-out is set to 0.

Tools->Options->Query Execution->Execution time-out is set to 0.

I have experienced out and out work stoppage during generation of a snapshot - to include long term blocking and application timeouts.  How often do you change your schema -...

Gary ... I see this all the time with my large databases.  Perfectly normal, especially if they are taken down just prior to a tran log backup.  I like Carlos's...

I understand what you are saying.  We aren't really capacity planning in the sense of the amount of space we need.  We are planning for the amount of data that...

and extent is 64 KB while a page is 8 KB ... if I rely on extents to be my measurement, then I have the possiblity of overestimating my change...

thanks for the reply ...

i'm running about 10 of each 2000 and 2005.  i have looked through the 2005 views. i looked even more closely at sys.dm_os_sys_info, sys.dm_os_performance_counters,