Re: ANSI Standards
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 23 Aug 2006 22:02:52 +0000 (UTC)
Loren Z (anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
We are in the process of migrating our MS SQL Server 2000 databases to MS
SQL Server 2005.
We have using the MS Upgrade Advisor to flag problems in our databases
so they can be fixed. Does there exist a tool from which we can get a
report on which databases contain components (tables, columns, stored
procedures) that do not meet ANSI standards?
The only I know of is the SET FIPS_FLAGGER command. I have not used it
myself. See Books Online for details.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: ANSI Standards
- From: Arnie Rowland
- Re: ANSI Standards
- References:
- ANSI Standards
- From: Loren Z
- ANSI Standards
- Prev by Date: Re: Debugging Stored Procedures with Query Analyzer
- Next by Date: Re: Debugging Stored Procedures with Query Analyzer
- Previous by thread: ANSI Standards
- Next by thread: Re: ANSI Standards
- Index(es):
Relevant Pages
|
