Is re-indexing all that the optimization job does?

Additionally, what if the column that is a calculated/computed column does not have an index?

Thanks.

Chris...

I don't know about the SQL 2K5 question, but you can make a full back-up without affecting log-shipping.  Thanks.

Chris

You also might want to consider flushing the error logs daily and increasing the amount of error logs being kept.  This will possibly help in you being able to open...

Try this:

http://www.mssqlcity.com/Articles/KnowHow/RowCount.htm

Thanks...Chris

I'd just go with the cftry/cfcatch error handling.  Hope that this helps.  Thanks.

Chris

You're welcome.

Look into table variables.  Same concept as cursors (row by row), but less intensive on the machine resources.  Hope that this helps.  Thanks.

Chris

Thanks, Colin.

Dig it!  Thanks all!

Yeah, I know what "exec" is, but when you run a stored procedure in Query Analyzer, it's optional.  I was just commenting on the fact that it is required in stored...

That did it!  Thanks a lot, Sriram!  I guess the "exec" is needed in a stored procedure, huh?!

Check out these links.

http://www.sqlservercentral.com/columnists/sjones/whodoyouhire.asp

http://www.simple-talk.com/2005/10/18/the-database-mole/

Hopefully they help.  Thanks.

Chris

Firstly, thanks, Jeff.  I understand that the code that I posted is not correct.  I only posted the code to convey the general meaning of what I was trying to...

Thank you!

Not looking at one query in particular but all of those captured from an application.  I'll take a closer look and let you guys know if I have any further questions.  Thanks...