MCP Market News: Microsoft SQL Server & SQL Reporting Services
David will also review the value proposition and selling points for Microsoft SQL Server & SQL Reporting Services. Jeff has been working with SQL Server since version 4.

What You Should Know About Installing Screensavers
SLAP! You can't figure out the way to make it work on your system and you will never know what you have missed. At least you can see what it's all about.

Microsoft Great Plains: Customization Upgrade & Recovery - Visual Studio VB 6.0
0 and 2000 - we see more historical custom projects done in SQL stored procedures and front ends coded in VB in Visual Studio 6. Microsoft Great Plains, former Great Plains Software Dynamics, eEnterprise has very long, about 12 years customization & integration history.

Increase Office Efficiency With One Simple Tool
It's a great way to increase the efficiency in your workplace. Additional copies are a fraction of the cost, so you can buy a copy for everyone in your office.

Microsoft Great Plains eCommerce: overview for developer
Microsoft Business Solutions Great Plains was designed back in the earlier 1990th as first graphical ERP/accounting system for mid-size businesses. Companies, like Alba Spectrum Technologies have implemented multiple diversified eCommerce projects with Great Plains at the back end.

Microsoft Great Plains Dynamics on Pervasive SQL.2000 Data Repair - Overview For DBAs
Microsoft Great Plains Tables Structure - Launch Great Plains and go to Tools->Resource Description->Tables. Small companies use Small Business Manager (which is based on the same technology - Great Plains Dexterity dictionary DYNAMICS.

Groupware and Version History: Collaboration Series #1
Groupware deals specifically with the ad hoc nature of much of the document collaboration in today's fast-paced business. This article is the first of a series of articles exploring specific aspects of groupware.

Microsoft eCommerce Web-development: Great Plains eConnect .Net - Highlights for Programmer
In our small article we'll consider Microsoft Business Solutions Great Plains Sales Order Processing module as eCommerce backend. As you see above - Great Plains allows you to address work tables only - this means that you can not post transactions using eConnect.

Benefits of Shareware
Businesses and individual consumers need to take a closer look at the benefits of taking advantage of shareware marketing. As a result, the Internet has taken the proliferation of shareware to a new level.

How to Make Own CMS
The simplest and the most common way is to make a hierarchical structure tree. For visitors, the CMS displays web site content.

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, California, Texas, Florida, New York, Georgia, Colorado, Oregon, Washington, Canada, UK, Australia and having locations in multiple states and internationally (www. Net, Crystal Reports and Microsoft CRM SDK developer. Net, Web Service, Transact SQL scripting and stored procedures, deploy such SQL Server tools as Linked Server to all ODBC/OLEDB compliant database, including ORACLE, Sybase, Ingress, DB2, Unidata, Pervasive SQL, Ctree and even Lotus Notes/Domino. In this small article we would like to give you the clue on programming the integration with SQL third party Database. Net and one of its programming languages - C.

Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc. Direct SQL touch - in #4 above I described you the scenario with MS Exchange handlers - this would be ideal world if MS CRM SDK does the job. But - in real world this is not always true - you have to do direct flags correction in CRM database (like making Activity closed, moving email attachments/octet streams, etc. This is not supported by MBS technical support - but you can rescue to this technique if you have to get job done. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience.

Windows Active Directory, Microsoft Exchange 2003/2000, SQL Server, Crystal Reports Enterprise, Biztalk server, Microsoft Outlook, Internet Explorer, Microsoft Great Plains as backend, etc. Direct SQL touch - in #4 above I described you the scenario with MS Exchange handlers - this would be ideal world if MS CRM SDK does the job. MS CRM Customization tool -  this is rather end-user tool and we don't describe it here - read the manual. Net, Crystal Reports and Microsoft CRM SDK developer. Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies - USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, Boston, San Francisco, Seattle, Minneapolis, Los Angeles, Houston, Dallas, Atlanta, Miami, Canada, UK, Australia and having locations in multiple states and internationally (www.

Integration with other MBS products - currently it has integration interface with Microsoft Great Plains. Then simply apply some MS CRM SDK programming - you need some COM+ objects creation and VB programming experience. Refer to MS Exchange SDK onsyncsave event handling. Direct SQL touch - in #4 above I described you the scenario with MS Exchange handlers - this would be ideal world if MS CRM SDK does the job. This is not supported by MBS technical support - but you can rescue to this technique if you have to get job done.

He is Microsoft Great Plains certified master, Great Plains Dexterity, Microsoft CRM SDK C. Software Development Kit allows you to integrate your custom SQL, DB2, Oracle or other ODBC and OLEDB complaint application. Currently we are confident in MS CRM ability to automate the following industries. Aerospace & Defense, Chemicals, Oil & Gas, Advertising & Publishing, Distribution & Logistics, Beverages, Supply Chain Management (SCM), Pharmaceutical, Nonprofit, Healthcare/Hospitals, Wholesale/Retail, Manufacturing/Assembling, International Business/Multinational Corporation, Government. Using MS CRM SDK you can integrate CRM with your third party financial applications, such as Navision, Axapta, Solomon, Oracle Financials, SAP, PeopleSoft.

This technique is COM+ applications, registered as Microsoft Exchange sinks or handlers. Microsoft Exchange allows you to alter it's logic in the events, exposed for custom handling. Net, but you will not have debugging available, because these applications will work as event handlers. If you are programmer or software developer - you can actually program these advancements and we'll give you the direction. To decrease the possibility that users will use outlook to send new messages and answer the messages from there - you would probably like the idea to delete them from MS Exchange database when they are transferred to the CRM.

Andrew is Great Plains specialist in Alba Spectrum Technologies ( http. Lotus could work in multiple hardware & OS platforms, such as Windows Server, AS/400, etc. It is US$3k basic pack, including 30 users and then $75 each additional user. The reason for this is simple - version 6. In Europe price is proportional in Euro.

MS CRM works in concert with MS Exchange, Windows Active Directory, SQL Server, BizTalk (integration with Great Plains and in the close future Navision. Considering conservative decision making - there is often the requirement of clear and complete audit to verify past decision making. MS CRM plays this role by automatic logging all the documentation and especially all the incoming and outgoing emails to/from clients. You need MS CRM Exchange connector customization. Pension Funds and Financial institutions.

It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision (the last two in progress. Create(userAuth, strActivityXml, strPartiesXml)). Now I would like to share the trick with you - there is no method to make this activity closed in MS CRM SDK 1. Obviously Microsoft doesn't support if you do direct SQL programming bypassing SDK. So here is what we have - this procedure will do the job and make activity closed.

If we don't use this directive - we can't pull the results from Navision tables - we will get errors, like this. TRACEON(8765) directive allows working with the data results of variable length returned by C/ODBC driver. Unexpected data length returned for the column. ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1'. Now we need to create small procedure for Sales data extraction.

It is tightly integrated with other Microsoft Business Solutions products such as Microsoft Great Plains, Solomon, Navision (the last two in progress. Create(userAuth, strXml, activityPartyXml). Our credits to Anna Osborn (so obviously small pocket aquarium goes to her - smile!), she let us know how to close MS CRM Activity. But in any case whatever you find below could help you to do whatever CRM SDK can't. Create(userAuth, strActivityXml, strPartiesXml)).

This is special handler, inspecting document change status, transferred from MS CRM to document storage (SharePoint), and report Activity owner on the changes with home page notifications (User home page in MS CRM. User in turn can review the history of the document editing - who, when and where is the change. Modified version sores document in SharePoint Document Library (the required library is subject for setup by MS CRM system administrator) or keep it in MS CRM as is (for documents of minor importance. Standard unmodified CRM suggests you to store documents in the file system. From the moment of saving the document in SharePoint Document Library it is not stored in MS CRM - CRM will now store only the link/reference to the document.

Advanced Techniques - in MS SQL Enterprise Manager you can create Linked Server to all ODBC/OLEDB compliant databases. Ctree, PervasiveSQL/Btrieve, MS Access, ORACLE, DB2, Unidata, Navision (C/ODBC) and using OPENROWSET construction you can create geterogeneus view and stored proc - then you can have the data from multiple systems in your Crystal Report. SQL Views and Stored Procedures - yes - feel free to create them directly in RMS Headquarters database and deploy in your Crystal Report. Hints on dataflow/synchronization - Microsoft RMS uses worksheets technology and all the data goes from stores to headquarters database through worksheets. Headquarters database doesn't create its own transactions - so be careful and do not try this type of data integration.

Robert Horowitz is Certified Navision Specialist in Microsoft Business Solutions Partner Alba Spectrum Technologies - USA nationwide Navision, Great Plains, Microsoft CRM customization company, based in Chicago, California, Arizona, Texas, Florida, New York, Georgia, Washington, Colorado, Canada, UK, Australia and having locations in multiple states and internationally (www. You should probably familiarize yourself with OPENROWSET statement in Transaction SQL. Now you are ready to create geterogeneus SQL View to link all your databases and have the data shown in one Crystal Report. If you are on C/SIDE DB - you create linked server to it via C/ODBC, then you create additional linked servers to your legacy DBs. If Navision sits in MS SQL - you create linked server to the third party database (Oracle, DB2, Unidata, Ingress, Sybase, Pervasive, Ctree, MS Access.

If you have a need in large scale data import, you can always have us help you with MS CRM SDK data conversion. Aerospace & Defense, Medical & Healthcare, Distribution & Logistics, Hospitality, Banking & Finance, Wholesale & Retail, Chemicals, Oil & Gas, Placement & Recruiting, Advertising & Publishing, Textile, Pharmaceutical, Non-Profit, Beverages, Conglomerates, Apparels, Durables, Manufacturing and having locations in multiple states and internationally. Andrew Karasev is Chief Technology Officer at Alba Spectrum Technologies ( http. Tools->Import and select contacts or leads. Here we will describe other option and possibilities.