Showing posts with label notification. Show all posts
Showing posts with label notification. Show all posts

Saturday, February 25, 2012

about the e-mail question of Sql Server 2005 notification services

Dear all

can notification services send a e-mail with a accessory of PDF file ?

Tanks a lot.

Out of the box, SSNS comes with a SMTP delivery channel that does not support attachments. However, you can easily create your own custom event provider for this.

Or, the notification can send a hyperlink to a PDF file that's available online.

HTH...

Joe|||Hi Joe

Thank you for your help.

about the e-mail question of Sql Server 2005 notification services

Dear all

can notification services send a e-mail with a accessory of PDF file ?

Tanks a lot.

Out of the box, SSNS comes with a SMTP delivery channel that does not support attachments. However, you can easily create your own custom event provider for this.

Or, the notification can send a hyperlink to a PDF file that's available online.

HTH...

Joe|||Hi Joe

Thank you for your help.

Thursday, February 16, 2012

about Microsoft SQL Server 2005 Express Edition Service Pack 2

hi, i'm apung from indonesia. i have a problem when i was updating my windows
using windows updates. there was a notification said Microsoft SQL Server
2005 Express Edition Service Pack 2 (KB 921896) can not be installed. please
help me. thank you
--
apung01Hi
There are some issues with windows update recognising SP2. You may want to
check exactly what version you are on and manually download/update See
http://blogs.msdn.com/psssql/archive/2007/04/06/post-sql-server-2005-service-pack-2-sp2-fixes-explained.aspx
for which routes to take. You can always tell windows update to ignore that
patch.
While you are updating you may want to add additional post SP2 hotfixes.
John
"apung" wrote:
> hi, i'm apung from indonesia. i have a problem when i was updating my windows
> using windows updates. there was a notification said Microsoft SQL Server
> 2005 Express Edition Service Pack 2 (KB 921896) can not be installed. please
> help me. thank you
> --
> apung01

Saturday, February 11, 2012

about delivery channels

Which deleverychannels does NS support?

Can i use smartphone to receive notification?

If can,have any samples for this? Thanks

Out of the box, SSNS supports 2 delivery channels - SMTP and file. But it's easily extensible so you can use the API to create your own delivery channel to send notifications to an SMS device, a fax server, voicemail, whatever you can programmatically address.

BOL is a good place to start, but Shyam Pather's book has a better example of how to do this.

HTH...

Joe

|||

I have reading Shyam Pather's book of sql server 2005 .but I have not its example. who can give the example,special customer deliver channel . my e-mail: sichuanwww@.163.com. thank you very much.

|||In have Shyam's 2000 book, he describes how to create a custom delivery protocol in Chapter 10. I don't have his new book in front of me at the moment but I feel sure it's in there too.

I don't have a custom delivery protocol that I can share at the moment. I'll see if I can create a simple one and post it on my blog - http://www.sqlns.com. It'll be a couple of weeks before I can get to it though.

HTH...

Joe

about delivery channels

Which deleverychannels does NS support?

Can i use smartphone to receive notification?

If can,have any samples for this? Thanks

Out of the box, SSNS supports 2 delivery channels - SMTP and file. But it's easily extensible so you can use the API to create your own delivery channel to send notifications to an SMS device, a fax server, voicemail, whatever you can programmatically address.

BOL is a good place to start, but Shyam Pather's book has a better example of how to do this.

HTH...

Joe

|||

I have reading Shyam Pather's book of sql server 2005 .but I have not its example. who can give the example,special customer deliver channel . my e-mail: sichuanwww@.163.com. thank you very much.

|||In have Shyam's 2000 book, he describes how to create a custom delivery protocol in Chapter 10. I don't have his new book in front of me at the moment but I feel sure it's in there too.

I don't have a custom delivery protocol that I can share at the moment. I'll see if I can create a simple one and post it on my blog - http://www.sqlns.com. It'll be a couple of weeks before I can get to it though.

HTH...

Joe