Either the image you installed from is seriously messed up (not likely), or it's a coincidence and something else was being done at the same time.

Have you tried running the command in the command-prompt directly? As opposed to through xp_cmdshell, I mean.

NVARCHAR won't hold RTF files, just the text. I would expect VARBINARY instead of IMAGE, for RTF files.

What error are you getting?

I use Bing, because I'm strange, but most people use Google.

You can trace events in a database, even at the table level. Use either a trace, or (better) extended events. (Search for "sql extended events" to find out...

I've used OpenRowset for exactly that. But the automation executes as an AD credential that's in a group with the needed permissions. Simpler that way, in my opinion.

Are...

Second-the-motion on Gale's suggestion. Script objects, import data. Don't script data.

When you say "migrate", do you mean an in-place upgrade, a copy of a database to a new server, or something else?

Are you using something like Spotlight to monitor server health, etc? If not, then tools like that can take you a long ways in "service improvement".

If you use a Calendar table, you can query the rows in that, join them to your time parameters, and simply do either a join to your date-range table (Cross...

Try this:

CASE WHEN result.Pc_CrFCIC IN (52, 53) THEN result.Ip_Code ELSE 0 END,

CASE WHEN result.Pc_CrFCIC IN (52, 53) THEN 0 ELSE result.Ip_Code END DESC

It takes two statements. You can put...

You should be able to shrink the log files right after setting it to Simple.

Instead of Read_Only, I suggest setting it to Single_User With Rollback_Immediate. ALTER DATABASE mydb SET...

It looks to me like it's having to do an outer-reference for the aggregate in question, in order to resolve the sub-query. The other sub-query doesn't appear to do...

Is there a finite and definite list of all of the possible parameters?

If so, just list them all in the @params parameter and the Exec statement. If...