From BOL:

To send Database mail, users must be a user in the msdb database and a member of the DatabaseMailUserRole database role in the msdb database. To add msdb users...

I have always used local and not had an issue. Mileage may vary..

CEWII

What version of SQL are you using? Standard, Enterprise, etc?

On versions other than Enterprise (and Dev) you can create indexed views but the index will NEVER be used unless...

You can only have one Integration Services server and only one default server.

CEWII

Quite frankly I just find/replace..

CEWII

Aha.. Same idea, but with code!

CEWII

Without writing a bunch of code myself I can present a framework of an idea..

You could use the information schema views to get the table names and column names for...

Look at PIVOT in Books Online. I think that might be what you are looking for..

CEWII

Create a second connection to the same server/database and use it. I'm guessing that will solve it..

CEWII

Jonathan Kehayias (7/21/2009)

---

I think you misunderstood what I was saying there.

That it is consuming so much memory during Assembly creation is usually a sign that unapproved assemblies are being used....

Jonathan Kehayias (7/21/2009)

---

snip.. That would point me to think that you are using unapproved assemblies possibly in your code which would require TRUSTWORTHY ON and UNSAFE assembly rights....

It probably isn't the best but it shouldn't break anything. The hard part is depending on your transaction size and batch size depends on whether all that data is...

In our domain we have created an account that we use for Proxy. Then all jobs use that proxy. If you have some high security jobs you can...

What exactly is the error it is giving you in the Output window?

CEWII

I've tried using temp tables and you can *sometimes* get it to work, but the problem is that I *always* need the process to work.

When I have had...