This would not work with QA or any scripting tool. In the stored procedure, do not use hte "go" keyword. Just put the 3 index creates.

Follow Martin's advice.

Grant all I believe just grants them to all objects and you still have to specify the permission.

I think ALL is a bad idea. It would be better to script...

Did you check the log? Are you sure the job is running, check history, enabled, etc?

Buy a bigger box

The timeout occurred because the db and web were on the same box and we were getting overloaded. We separateed...

Never thought of that, but it's a good idea. That page is being rewritten, but I'll look to add those in as well.

Tatsu,thanks, forgot to add this thread last night

I've had a few people email that this started in the UK (those clever Englishman and...

I agree with Jeff

The mirror is unusable as it is in recovering mode all the time. Basically it is like you have restored the a backup and are working your way through the...

I don't think they have a legal basis to republish, but the indexing for searching may be legal. It's an interesting idea and I'm not sure how I feel about...

My understanding is what Tim mentioned. There isn't a zero byte file there, but one that somehow contains schema information and possibly pointers back to data, but essentially no "user"...

2.0 contains a number of new framework items that are built into VS2005 and SS2K5. I know on the ASP.NET side, there are page inheritences that are important, but haven't...

Yelena,

Interesting and glad that works. For me, however, I found that writing something reinforces it. Also, when I have to rewrite something, it's annoying and spurs me to get it...

and no one liked my story??

Greg,

That may be true and I hope that they sent out lots of them. I had the person reporting this say he got one this week and I had two...