Yes, I thought about that. In my searching I got the impression it was client...

I figured out what's going on here. Somebody chose the option to audit all logins. Maybe on purpose, but most likely they were poking around where they shouldn't...

You could look into Red-Gate's SQL Backup. I use it and think its great. I don't have any log shipping going on, but it makes quick work of...

I think I had only pasted the code and saved. Did not try and Build. Tried to Build and got all kinds of errors... and that's because...

Truth is, these users couldn't handle Excel's text import wizard.

Anyway, upon further review, I realize I can get at the text file that was exported.

So I have a delimited text...

Lot of files is right. 73 spread across 6 drive letters. The db is about 120GB now. The amount of data added each night depends on the...

The Result Set property on my SQL Task was set to None. Must be by default 'cause I didn't change it. Anyway, after a couple of hacks at...

I should add, this executes, but only does the SQL Task. I've set up my test with data in my table, so I would expect the Data Flow to...

Thanks, but it only gets more confusing. I created variable send, int32 = 0. Not @send. Try to add variable @send gives error messgage "must begin with...

This is because you're using xp_cmdshell. The Agent service needed sysadmin privileges in order to run xp_cmdshell.

I didn't see Alerts mentioned above. Also check to see if any Alerts were coded way back when and are now being invoked.

Why not create an SSIS package to create your objects in another DB?

If anyone cares, here's my CLR solution.

http://www.sqlservercentral.com/Forums/FindPost1022487.aspx

Oh well, no takers. I changed my subs to functions. Through testing I found the CreateTextFile function would overwrite an existing file, so I blocked that and returned...

I think using an Agent Job is a great idea since the account that runs my Agent already has xp_cmdshell privileges.