Re: ANSI Standards



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.



.



Relevant Pages

  • Re: ANSI Standards
    ... Tibor Karaszi, SQL Server MVP ... 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: Database Schema Documentation Tool?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... and relationships in the database. ...
    (microsoft.public.sqlserver.tools)
  • Re: SMSS - script to new window uses sp_executesql?!
    ... Even if the setting it in the Generate Scripts wizard, ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... If you just right click on the procedure, and select script to new window ...
    (microsoft.public.sqlserver.tools)
  • Re: SMSS - script to new window uses sp_executesql?!
    ... Thanks, I have not used the Wizard to script individual procedures, so I had ... it does not happen there as you describe -only on the wizard. ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ...
    (microsoft.public.sqlserver.tools)
  • Re: Database Schema Documentation Tool?
    ... Arnie Rowland, Ph.D. ... Most good judgment comes from experience. ... and relationships in the database. ... and clicking on the relationships jumps you to that table in the ...
    (microsoft.public.sqlserver.tools)