Are you getting any errors when you run the stored procedure? or is the problem that you are not getting the results you expect or no results at all?

I...

Found someone else with this problem here:

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic37118.aspx

THis post suggests making sure the database compatibility level is set to 9.0 (Sql Server 2005).

EXEC sp_dbcmptlevel 'database name', '90'

If you do what Steve mentioned and use a "real" table to hold the rows you want to delete you could run the select in one pass and then have...

ALTER AUTHORIZATION ON DATABASE::[dbname] to [owner]

For Example

ALTER AUTHORIZATION ON DATABASE::adventureworks to sa

Check out BOL

Are you sure the SQL Server service is running when you are doing the deletes?

In SSMS you can navigate to the DB right-click -> properties -> Options. It is the top option.

OR

exec sp_dboption [dbname], 'autoclose'

Have you looked at the job steps? There are parameters/options in the call to run DTS that may include the changed password.

SQL Agent Jobs have an owner that must have rights to run a job. Look in BOL under Proxy accounts (SQL Server Agent).

Here is a link to a forum where someone has SQLMail working with Notes using MAPI, but has a different problem, so it is possible to use SQLMail.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=15912

As far as...

My first disclaimer, I know nothing about Notes, but if you can use Outlook (not Outlook Express) to connect Notes I believe you can use SQLMail.

For SQLMail to worl you...

Thanks for the welcome to FL. I am really enjoying the weather.

I know there is something going on as far as a Jacksonsville PASS group. There is a...

Brad Rhine (12/19/2007)

---

That is a good suggestion, yet we were testing the limitations of Report Builder and have run into a few similar to this. The users current...

Could you use a link to another report instead of bringing all the data down?

If I had not gone to the meeting last night I would have done the same thing for the columns. I had always assumed that it was building the...

Did you set the Maximum Insert Commit Size on each destination? IF left to 0 it does one BIG transaction so committing after x rows will probably free resources...