Maximizer
>
Support
> Knowledge Base Search
New
-
Searching Tips
Disclaimer
Answers
Help
Search Results
Related Answers
Product
All Products
Accounting Link
Customization
EcBuilder
MaxExchange
MaxMobile
Maximizer
Maximizer Link
Enterprise 9.5 and older - Pervasive
Category
All Categories
Accounting Link-Quickbooks
Compatibility
Configuration
Display
E-Commerce
Email
Errors
How-To
Installation
Integration
Maintenance
Miscellaneous
Networking
Patches-Downloads
Performance
Productivity
Searching
Synchronization
Upgrading
Installation-Uninstallation
Search Text (optional)
Search Tips?
Search by
Sort by
Phrases
Ref. #
Similar Phrases
Complex Expression
Exact Phrase
Default Sort
Product
Subject
Updated
Reference #
020802-000004
Product
Maximizer
Enterprise 9.5 and older - SQL
Category
Patches-Downloads
Date Updated
02/23/2009 02:59 PM
Print Answer
SQL Script: Scripts for Name Types and Record Types
Question
This article contains SQL scripts the check for an fix records with incorrect or invlaid name types and record types.
Answer
1. Click on the script you wish to download.
2. Copy and paste the script text into SQL Server's Query Analyser.
3. Run the script against the appropriate table.
Check for invalid Record Type
Count records with inavlid Name Type
Fix invalid Record and Name Types
Fix other invalid Record and Name Types
Changes made
-hyperlink change (09/30/03)
How well did this answer your question?
100%
0%
Back to Search Results