For me, the Publisher instance was fine but had the same issue with "Processor Time %" graph grayed out on the Subscriber - SQL Server 2012. The solution is simple,...

Yes, all the failover cluster work has been done and checked ok.

Thanks Winash, I was thinking along the same line:

remove the article

truncate table

add the article

The table is huge, 50+ gigbyte with a million+ rows, so we aren't going to try a...

Thanks Scott, that was the fix and appreciate your help.

The database name was not the issue becasue there aren't any spaces in the name and the name itself isn't a sql reserved keyword. We have some table in the...

I'm sorry I don't get it. Could you give some example or point me to where I can find out some more.

Thanks for you help

The script failed again with the same error. I'm not sure if I have done all needed to be done though. What I have changed was this line

...

Yep, there is a table with the name 'case'. I'm going with your suggestion to see what happens.

Thanks

Thanks, ignoring the identity column was the answer.:-)

I agree with kll but I don't think microsoft would care if instead you made the call to bing.com.

One friend made a comment to me that with all the...

Thanks guys, this answered my question.

Is there an object named sys.table_index_fragments or this only applies to fulltext? I haven't played with SQL 2008 as of yet.

Thanks Michael that seems to be the case when I break a tablename and put a space in there. I'm not sure if 'SQL reserved' names apply here either becuase...

Nice work. In your case you already know what might have happened by resetting the Max Memory. My question is what if you don't know that was the cause of...

Thanks Mike, I knew it is somewhere in the msdb.