I need to run it in a SSIS package, but to prove that it is...

Yes dbmail is enabled. I can run a sp_send_dbmail in a regular SQL Agent job step, but when it runs inside a SSIS, that's when it gets the permission...

Also on SQL Agent properties

Connection option: alias is empty

SQL Server Connection: Windows Auth selected.

I have a dev system that the sp send db mail works ok with. ...

I have a user "servername\SQLServer2005SQLAgentUser$servername$MSSQLSERVER"

It is mapped to sysadmin role by default. Both boxes are like this.

On properties

Connection option: alias is empty

SQL Server Connection: Windows Auth selected.

I...

yep, will do a dts to an archive db which go onto a dvd, then truncate away!

search Luke search yielded http://qa.sqlservercentral.com/Forums/Topic416687-5-2.aspx

🙂

Very good question, here's how I did it on WAS 6.0.

Login to admin console

Click on Resources

Click on JDBC Providers

Step 1: select user defined

step 2 and 3 should all...

How timely, 10 worst jobs:

http://valleywag.com/390182/

hhhmmm, I don't see anything under Mgmt -> Legacy -> DTS. I tried again and double checked that I saved it to right server. I also checked another...

I have only one end user database on that system now.

The shrink script seems to work pretty good. Thanks!

ya, I had actually thought about that. I still have the scripts and format files from a previous bcp we had done.

Indexes were actually dropped and rebuilt a week ago. There are daily bulk inserts, so it's possible they need defragging weekly.

thanks for all the info.

I ran shrinkdatabase and it still wasn't finished after 42 hours. I had to stop it to get the app up and running again. ...

I just had similiar problems with pageiolatch_sh.  A query took 30 minutes to run.  I found an index problem, dropped it, rebuilt it and bam, query runs sub 60 ms...