February 2007 Edition
Feature Spotlight: SQL 2005 Support Preview
Q&A with Technical Support: Quick Search with Contains
Smart Tip of the Month: Backup Procedures for SQL 2005
Additional Resources: Creating Reporting Services Reports
Knowledge Builder: New Articles
Feature Spotlight: SQL Server 2005 Support Preview
The upcoming release of Workgroups 2007 boasts a wealth of new features and functionality including support for Microsoft SQL Server 2005. A major component of MS SQL Server 2005 is the SQL Server Reporting Services (SSRS) module which can provide the ability to create and schedule the running of various reports. Workgroups 2007 includes a direct integration with SSRS that allows the administrator to upload SSRS reports to the Workgroups 2007 system and specify which SSRS server should be used to generate those reports. SSRS reports that are run from Workgroups 2007 can be returned to the user in PDF, Excel or CSV format, giving the user flexibility in how they wish to receive their reports.
For more information visit:
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16264
Q&A with Technical Support: Quick Search with Contains
How can a user differentiate between the `starts with' and `contains' conditions in the Quick Search area of the MetaCommunications Production Portal?
The Quick Search area of the MetaCommunications Production Portal searches for information using a `starts with' condition by default. When a user wants to employ the `contains' condition, an asterisk * can be inserted at the front of the search string to produce a list of all items containing the text portion of the search string. Using an asterisk alone will produce a list of all records of the selected type (Jobs, Customer, Estimates).
For more information visit:
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16262
Smart Tip of the Month: Backup Procedures for SQL 2005
The upcoming release of Workgroups 2007 will include for Microsoft SQL Server 2005. In addition to having a new management interface, the way database maintenance plans are configured for MS SQL Server 2005 is different than previous versions of SQL Server. Consistent database backups are essential to ensure the recoverability of your information in the event of a failure. Knowledge Base article 16261 provides a document which describes how a proper database maintenance plan can be configured for SQL Server 2005.
For more information visit:
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16261
Additional Resources: Creating Reporting Services Reports
Earlier in this edition we discussed the SQL Server Reporting Services (SSRS) component of Microsoft SQL Server 2005. Reports for SSRS are created using a component that ships with SQL 2005 called Report Builder. The following articles provide additional information about Report Builder and how to use it:
Introduction to SQL Server Report Builder
http://www.developer.com/db/article.php/3520116
SQL 2005 Reporting Services, Part 1
http://www.databasejournal.com/features/mssql/article.php/3573361
SQL Server 2005 Report Builder Virtual Lab - Microsoft provides a free online virtual lab environment that will allow you to get familiar with Report Builder without having to install anything.
http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032291310&EventCategory=3&culture=en-US&CountryCode=US
Knowledge Builder
New articles this month
16261 - Backup Procedures for Microsoft SQL Server 2005
This article describes how to configure backup procedures for Microsoft SQL Server 2005.
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16261
16262 - Using the contains condition with Workgroups Portal Quick Search
This article describes how to use the "contains" condition with the Workgroups Portal Quick Searches.
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16262
16263 - Resources for using SQL Reporting Services
This article provides resources for using Microsoft SQL Server 2005 Reporting Services.
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16263
16264 - Running AppleScript containing RunSQLQuery with a non-Administrator user
This article describes how to run AppleScripts that contain the RunSQLQuery command with a Virtual Ticket user other than Administrator.
http://www.meta-comm.com/support/knowledge_base/article.asp?id=16264
Miss an issue of the MetaCommunications Support News? All back issues are available at:
http://www.meta-comm.com/support/support_news.htm.
Have an idea or topic you would like covered in the MetaCommunications Support News? Send your ideas, topics and comments to:
support@meta-comm.com
THE INFORMATION PROVIDED IN THE METACOMMUNICATIONS SUPPORT NEWS IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. METACOMMUNICATIONS DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL METACOMMUNICATIONS OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF METACOMMUNICATIONS OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.