That works.

Thank you, Shawn!

When I do that I get blanks in the dbrole column and garbage in the memername column:

CREATE TABLE #temp (

DatabaseName VARCHAR(128),

dbrole VARCHAR(40),

membername VARCHAR(40)

);

GO

declare @query nvarchar(2000)

set @query = 'USE...

3 jobs are configured to send notification to account W; 3 configured to send noti to account X; 3 configured to send noti to account Y. when all 9...

Using the wizard does not add a row to msdb.dbo.sysmail_principalprofile, either.

zero rows. there are no rows in msdb.dbo.sysmail_principalprofile.

zero rows returned for that select.

i don't.

the default should be set when u enable dbmail. this is the issue... the dfault shows as account 2 while the emails show as FROM account 3.

I appreciate the replies.

I did the selects on the system tables like anthonly suggested.

I see 3 dbmail profiles and accounts. when ANY job on the instance completes it...

In looking at results from 'select * from msdb.dbo.sysmail_account' I do see the display name for another count is what's showing in the FROM: of the notification email. However,...

Thanks for the reply.

Could you be more specific?

The sp is in the yo schema. Where do I look to see who is the owner of the sp? I...

I got it... one has LOGIN, the other USER.

thanks

thanks ramesh

another question:

when i execute:

execute ('select * From fn_my_permissions(NULL, ''SERVER'')') AS USER = 'firstuser'

REVERT

i get no rows returned; however, when i execute:

EXECUTE AS LOGIN = 'firstuser'

GO

SELECT *

FROM fn_my_permissions(NULL, 'SERVER');...

Thanks for everyone's help.

9.00.3042.00

Thanks

I did find this article:

http://msdn2.microsoft.com/en-us/library/bb153838.aspx

However, when I right click the 2000 maint plan as it says to do, 'Migrate' isn't an option and I am sysadmin.

Any comments appreciated.  Thanks