Wish it gave a little better error but I think the problem is that the datatypes that you are defining in the CONVERT statements care too small for at least...

Anybody with sysadmin rights can do it. Or the owner of the job. Or anyone with the SQLAgentOperator Role.

As far as a list. Not off the top...

I completely agree, shutting the OS down does a clean shutdown of SQL. I have never had a problem with this method.

As another poster noted, be sure...

Caveats:

1. I didn't check the MS documentation to see if they have an explicit position on this.

2. I'm 99% sure you want to install your SQL 2000 servers first and...

I like PaulB's answer. It does depend. In previous versions last page contention was much more of a problem, and by and large you will not see full...

As would be mine.

CEWII

Libby (8/24/2010)

---

Does anyone know if it's possible to add some kind of error handling to not fail the entire task when an invalid email format is encountered on the "Send...

When you run it locally do you use the prod config file?

CEWII

There is a max errors property, set it to zero. You might have to set it for a couple different components within the FOR EACH but it will ignore...

I'm not 100% sure I understand the question. As I read it, you have configured the package to use configurations, now you want it to NOT use them but...

Ran into this before myself, and the answer is.. you can't directly..

BUT, you have several options to make it happen:

1. Use an EXEC SQL or Script Task before the...

Although I can't give you a link to point to I remember reading that remote WMI calls require administrator level access to the box.

I recommend that SQL NEVER run as...

jm99 (8/31/2010)

---

Thank you Elliot.

The other things that I have to consider are:

1) The load that I place on the MySQL system

2) The aggregation is being used as a...

My first question is why wouldn't you do your sorting and aggregation on the database engine side? I know in SQL it would be much faster.

1. As far as...

There are multiple levels of permissions, share and file system permissions. You referenced share permissions, so those appear fine. does the proxy user have permissions at the file...