Insert the log data into a table variable. Then, in your error handling, after the rollbacks, insert it into the final table. That should give you what you...

Splitting it into multiple sub-procs is generally a good idea, in terms of execution plans for each one. I've gotten very nice performance improvements by doing exactly that.

Is the agent account part of the domain, or is it a local account on the server?

There might be problems with it, but there probably won't.

I wouldn't do this, but it isn't one of those "never, ever, never" kind of things, it's just that I find...

Most of this could be done with OpenRowset. That, at least, can select from Excel into SQL. Given dynamic SQL and an input parameter of the file name...

Do you mean save the data in Excel? Excel isn't really something you print to, but it might be something you export to or save to.

Reporting Services does have...

The reason it takes a long time is because there is something wrong with it.

Without more details about it, nobody can be more specific than that.

When you say the data is "fixed delimited", do you mean that it uses fixed width for columns? For example, the first 10 characters are column 1, characters 11...

And, of course, if you're using a "Standard" version of Windows Server, you can't address that much RAM anyway.

The company I currently work for, when I arrived a little over a year ago, had the IS manager operating as the DBA when he had time for it.

Backups were...

Rod at work (11/26/2008)

---

I've contacted my network administrator and talked to him about it. He said that it might be possible the firewall is blocking SMTP traffic, so he's...

Do you mean you're casting to bigint instead of numeric(6) now? (3-million is inside the range for Int, you don't need to go quite as large as bigint for...

It's not the difference between whether it has a clustered index or not. Some tables gain more than others from removing unused columns. A lot of it depends...

Over the last year, there have been times I've been very active on this site, and times when I haven't had the time to even visit, much less post.

When I'm...

Instead of a trigger, would a unique index give you what you need?