And if it's for a client app, why not client side.

I just thought as well that SSRS might be the simplest way to do this if clients are going to...

I believe this is an uninstall and reinstall. You should be able to detach databases, and script out user/passwords if you need to.

If you just need to extract data server side, I'd look at SSIS. Or DTS in SQL 7/2000. You can use the data export wizard to create the basic...

Both of your emails, and your name, are protected by SSC. I can see them when I look up the account, but no one else can.

Nothing else is worth a...

The issue with SQLCMD is passing in the output file name.

You could, for example, calculate the filename in T-SQL, then pass that to SQLCMD as part of an XP-cmdshelll string....

You do need some type of date. An identity could work, but since these are not guaranteed to be unique, and they can get re-seeded, I'd be careful about using...

There's no effect I'm aware of. The CPU is silicon, I guess it could run hot and degrade, but it has no moving parts, so I don't think there's an...

I'd run a SETUSER to switch to this user, and run the fn_my_permissions (or whatever it's called) to check permissions.

A DENY will override the other permissions.

I'd experiment a bit...

The maintenance plan resolves some things at save time, but I thought that in 2005 it ran a cursor over sys.databases at run time. Is this an SP2 patched or...

I'm not quite sure what you mean. Do you mean that you want to run something in SQL Server and then have the results stored in a separate file or...

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