Are you calling Word from within xp_cmdshell? I haven't seen this, but it sounds as though you might be out of memory on the server. I'm not sure the xp_cmdshell...

I'd go with mirroring myself, but I'd supplement it with log shipping to recover from non-critical errors (like table deletes), maybe with a 2 hour delay on the restores.

Geo-clustering...

Use UPDATETEXT (http://msdn.microsoft.com/en-us/library/ms189466.aspx), however if your data isn't larger than 8k most of the time, you shouldn't be using image. Go with varchar instead.

Interesting that many of you wish you had done more education. I wonder if that was to get a headstart on your career now or just to learn more.

And I...

Is that the exact error? no number or anything else?

I haven't seen this reported before as that message. Does this help?

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/c9fd4f8c-ed69-45d9-81bd-92eb1c7df5a1

Please post questions in the appropriate forum. This forum is for author comments. Moving to 2005-admin.

If you have questions, just post in a forum, someone will see it and try...

I think the classification is just to have a frame of reference. It does always change, but it helps to get an idea of scale for how your system might...

Real football starts soon, looking forward to playing hooky and watching a little training camp.

Footie-ball/play acting, that Lynn ref's I think never stops.

I have removed the account of our (un)professional1 friend from the system and deleted threads. Apologies to those of you that had to deal with him/her. It was a bogus...

Or provide more information. A view isn't anything more than a query that is written over a table(s). The query optimizer looks at that query and includes it in the...

you want to run this restore while you are connected to the Master database, not the one you are restoring.

The log is always written to first, before data changes are made. So if the log is slow, meaning the I/O channel, then performance can suffer.

These look like C# of VB.NET questions, not SQL Server.

You can test these, write a loop to build 10,000 of each one, look at the cost/time of each.

Which choices?

I'm not sure this is the right place to ask this question. Are you programming something? You might want to post this on a more appropriate site.