I might do it 10 times or so, just to be safe. Allow some pad in case things change.

You could probably calculate out the max in any column and use...

Not to hijack the thread onto cursors, but I use them many times for one-offs , things like Brandi that need to be done, and figuring out and testing a...

I've tried Atkins, didn't like it. Felt tired, missing some energy. Tried South Beach, with better results, but it didn't fit me.

We have done the Body For Life (http://bodyforlife.com/)diet a...

Excel doesn't really run in the same process, AFAIK. It can hang, which could hang this SPID.

It's an interesting solution, and one that might fit in certain places. Having users...

Links in the article have been corrected.

They shouldn't be allowed to run the same job at the same time. They weren't re-entrant in 2000 AFAIK. Are you sure there aren't two jobs doing the same thing?

http://www.sqlservercentral.com/scripts/SQL+Server+2005/63287/

http://www.sqlservercentral.com/scripts/Indexing/Maintenance+and+Management/

SQL Server Jobs run from SQL Server Agent. It starts jobs on a schedule or with a call to sp_start_job. If you set up an icon on your local machine,...

No soda today at least 🙂

And one (large) cup of coffee!

and here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=3074939&SiteID=1

What exactly is in the maintenance plan if you open it up? What steps?

Could you have client tools at a different SP/CU version than the server?

Don't cross post.

Answered here: http://www.sqlservercentral.com/Forums/Topic614147-146-1.aspx

Restoring could be faster, though I'm not sure if the restore process is tolerant of network issues. The backup process is not.

I'd be sure to check data quality with this. It appears to work, but Kendall Van Dyke might not work well, as perhaps John A. Smith.

You want to look for...

Also, just add space to your data file. indexing consumes space and you might be too low for it to run if you don't have autogrow enabled.