MS SQL 2000 HELP

[OutHouse]

Im trying to add more than one machine for the alerts netsend.

how can I add more than one machine for netsend? If you go to Management then Operators and then the properties of an operator. Under the General Tab you will see "Net Send address"

I have tried, quotes, commas, semi colons, colons. single quotes....

any help would be appreciated.

 

[MrChad]

sp_update_notification

 

[bunker]

What he said.

As a side note, if you come across something like this in the future a lot of times it's easier to search for a stored procedure that will do what you want opposed to struggling for hours trying to see if you can do it in enterprise manager. Often something can only be done with a system stored procedure.

 

[OutHouse]

how do i fire that stored proc for alerts?

 

[bunker]

Originally posted by: Citrix
how do i fire that stored proc for alerts?

Start Query manager and type it in manually. Look at the SQL Books Online for the syntax.

 

[OutHouse]

Originally posted by: bunker

Originally posted by: Citrix
how do i fire that stored proc for alerts?

Start Query manager and type it in manually. Look at the SQL Books Online for the syntax.

ok, looks like we were all on different pages. I figured out what i needed to do so I think all of you for your help.