Re: ANSI Standards

From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
Date: Mon, 28 Aug 2006 22:54:42 +0200

To the best of my knowledge, FIPS_FLAGGER is more of less useless. With 2000, there was a lot of stuff introduced that FIPS_FLAGGER didn't catch. I don't recall details, but I recall that it seemed like MS didn't bother to up the FIPS_FLAGGER code for 2000. I haven't checked whether same goes for 2005. I prefer to use the SQL validator found at mimer. Not as easy to use, though.

.... One thing, for instance, that FIPS_FLAGGER don't warn for is FOR XML.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/

"Arnie Rowland" <arnie@xxxxxxxx> wrote in message news:O62ha9ryGHA.4116@xxxxxxxxxxxxxxxxxxxxxxx

Good Idea Sue. Thanks.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message news:4336f2pp381r58b1h086qkk9uedmr44917@xxxxxxxxxx
But in checking for ANSI issues on an existing database, you
can script out the entire database and all object into one
file. Then load that file into QA and at the beginning add
the set fips option and then just parse the entire script.
I've used it that way before to check for ANSI issues with
existing databases.

-Sue

On Thu, 24 Aug 2006 20:18:28 -0700, "Arnie Rowland"
<arnie@xxxxxxxx> wrote:

Unfortunately, the FIPS_FLAGGER setting is only useful when creating SQL
Objects -it operates at Parse-time.

References:
- ANSI Standards
  - From: Loren Z
- Re: ANSI Standards
  - From: Erland Sommarskog
- Re: ANSI Standards
  - From: Arnie Rowland
- Re: ANSI Standards
  - From: Sue Hoegemeier
- Re: ANSI Standards
  - From: Arnie Rowland

Prev by Date: Re: Import Data succeeds but doesn't copy data?
Next by Date: Re: Problem with auditing
Previous by thread: Re: ANSI Standards
Next by thread: Import Data succeeds but doesn't copy data?
Index(es):
- Date
- Thread

Relevant Pages

Re: Scripting DataBase
... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >>> Can someone explain how could I crate a script of a database? ...
(microsoft.public.sqlserver.dts)
Re: How to truncate?
... you can't truncate a table that is referenced by any ... > Another way would be to script out all the data from the production database ... Code to generate such scripts written by SQL Server MVP Vyas ...
(microsoft.public.sqlserver.programming)
Re: ANSI Standards
... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... can script out the entire database and all object into one ... the set fips option and then just parse the entire script. ...
(microsoft.public.sqlserver.tools)
Re: Urgent! How to change databases charset in SQL 2000?
... Do a search and replace on the script to get rid of the COLLATE options. ... Drop the old database - or rename if you don't trust the backup. ... Mary Bray [SQL Server MVP] ...
(microsoft.public.sqlserver.server)
Re: Scripting a Database
... Tibor Karaszi, SQL Server MVP ... http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ Blog: http://solidqualitylearning.com/blogs/tibor/ ... I need to be able to create a script of a database from within a .NET application. ...
(microsoft.public.sqlserver.tools)