About new SQL Server 2005 Samples and Sample Databases

There are five msi files listed for downloading.

SqlServerSamples.msi

AdventureWorksDB.msi

AdventureWorksDBCI.msi

AdventureWorksBI.msi

AdventureWorksBICI.msi

What are the AdventureWorksDBCI.ms and AdventureWorksBICI.msi used for? I try to run it, but it return the message "Another version of this product is already installed" and ask me remove the old version of this product. Anybody know what I should remove?

Thanks,

Hi,

Seems that they either need to update their docuementation or change the file names, because the BI (Business Intelligence) was former written wir DW (Datawarehouse). THE CI means (like mentioned in the download page) Case sensitive means, that for example 'A' is not the same as 'a'. more samples about that can be found here:

http://www.databasejournal.com/features/mssql/article.php/3302341

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jen,

Thanks. I are right, the CI means case insensitive.

AdventureWorksDB.msi creates a AdventureWork database with collation Latin1_General_CS_AS in your SQL Server.

AdventureWorksDBCI.msi creates a AdventureWork database with collation Latin1_General_CI_AS in your SQL Server.

Depends on the server collation setting (check the properties of server and see server collation item), you can decide which two msi files should to be downloaded and run on your machine.

Thanks,

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

about Alert

Hi all:
I want to create a Alert,which can email to me when
my log file is attach to 90% full.
How can I do?
Is there Any samples?
Thank you!!
ArronHi:
Follow the list steps, you can create the alert:
1. Start the Enterprize Manager
2. Browser the server you want to create alert
3. Browser the "Management" and right click "Alert"
4. Select "New Alert" to start the alert
5. Change the Types: to "Sql Server perfermence condition alert"
6. Change the objcet to "Sql Server:Databases"
7. Change the counter to "Percentage Log Used"
8. Set the other value as you expect
9. Switch to Response tab
10. Click the "New Operator" and set the e-mail adress
After these steps, the alert should be OK
Best Wishes
Wei Ci Zhou|||Before that, please check if you set the mail profile|||Setting up the mail profile is documented in SQL books online... It requires
that Outlook be installed on the SQL Server... If you may not, or do not
wish to install Outlook, you may go to www.sqldev.com and there is a mail
dll, and sample stored procedures that will allow you to do SMTP
mail...(instead of MAPI mail).
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Arron" <9144492@.pchome.com.tw> wrote in message
news:578601c3e56a$804b52e0$a001280a@.phx.gbl...
> Hi all:
> I want to create a Alert,which can email to me when
> my log file is attach to 90% full.
> How can I do?
> Is there Any samples?
> Thank you!!
> Arron