Showing posts with label allcan. Show all posts
Showing posts with label allcan. 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.

Monday, February 13, 2012

about Index

Hi all~
can anybody tell me What is the difference
Index Seek AND Index Scan
Thanks~Hi all~
can anybody tell me What is the difference
Index Seek AND Index Scan
Thanks~

Well, if our criterion is (LIKE 'A%'),we do one single lookup in our index and are able to look through the non-clustered index to find a continuous range of data.This kind of lookup where we can go to a particular spot in the index is called a Index Seek.
You better see the BOL about this topic

Index Seek (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_119q.asp)
Index scan (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_119q.asp)