DBMail works just fine. The Alerts are not working. When the server shuts down, the log gets full, severity errors happen, it does not send out the alert. DBMail...

Yes, it's a 64bit and our jobs are notifying us using dbmail.

These seem a bit broken up. The 2nd script has no explanation or comments on what the purpose is. Does anyone have any other suggestions? I will continue to look...

I had originally tried the semi-colon and it did not work. Gail, your fix helped. Thank you so much for your help as always!

Seems to have worked using the advanced by picking the windows proxy account rather than the Proxy Name itself on the agent. Lets see how it works!

Thanks!

Here is the working code for sql server 2k5

Execute master.dbo.xp_cmdshell 'dtsrun /S Server\Instance /E /N"Package Name"'

Sql server 2005. It has t-sql steps as mentioned above. I can change other types of steps to run as proxy but not t-sql.

Yes, i'm sa as well. It works for all other types, ie. cmdexec, activex, etc. However, not for t-sql. Is there a reason for this? or am I missing something?

Thank you!

Here is one....

SELECT

'DROP INDEX ' +

QUOTENAME(USER_NAME(o.uid)) +

'.' +

QUOTENAME(o.name) +

'.' +

QUOTENAME(i.name)

FROM sysobjects o

JOIN sysindexes i ON

i.id = o.id

WHERE i.indid BETWEEN 1 AND 254 AND

INDEXPROPERTY(i.id, i.name, 'IsStatistics') = 0 AND

INDEXPROPERTY(i.id, i.name, 'IsHypothetical')...

I've never used it for security, thank you so much!

I'm actually looking for something to drop/remove all indexes. But this is great for other projects.

I would never recommend detatch and attache for system dbs. I agree, help_rev_login is the way to go.

IT seesm as we have to put the full email address, where in sql 200 we did not. That worked and still sent the mail queued message, but just putting...

Thank you so much!