----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: _SQL_Vinod_ Message 2 in Discussion There is absolutely nothing to get confused here: DMO : is the programming API's to the SQL Server 2000 world. A typical use would be API's that allow you to backup/restore,script out, invoke scripts,run DTS packages etc. Anything that you work on the SQL Server will have an API to work with. And DMO facilitates this. NS : It is Notification Services. Its a simple publisher-subscriber model from the SQL Server 2000 architecture. Its an Add-on to the existing installation. It allows some event driven tasks that can later get published to the subcribers in via medium like Email, HTML etc AS : Analysis services takes you to the next level of progamming with OLAP databases. Building cubes, working with them and generating reporting oriented work and MDX based queries. I bet this is powerful and exciting to work with. DTC: nothing special. Coordinator for the Transactions that happen for the server. A DTC coordinator can be pointed to other servers too. DTS: Me a big fan of this though. Allows you to perform simple tasks using clicks and GUI interface like loading data, transforming data, workflow orchestration, Maintenance plans, moving databases etc. It also has API's to write scripts within. It is dead powerful and one of my favourites as said. Whew ... Do check the SQL Server BOL for detailed info. This is just an intro for you. Vinod Kumar MVP-SQL Server www.ExtremeExperts.com http://groups.msn.com/SQLBang (SQL Server group) ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
