Generate Scripts without the Collate statement

using SQL 2K
Just wondering if it is possible to generate scripts without a COLLATE
statement included from EM (I don't see how) or a tool which will allow me t
o
do it.
Currently I simply manually remove all Collate statements after the script
file is created.
KevinI believe there is a script options setting that you can use from EM to do
some global tailoring of your results.
You can set the Formatting Option "Only script 7.0 compatible features"
which will eliminate collation, but it will also drop UDFs and other SQL
2000 features.
RLF
"kevin" <kevin@.discussions.microsoft.com> wrote in message
news:4AFB6BC9-3FC1-41FD-B07E-BB43DD6285C6@.microsoft.com...
> using SQL 2K
> Just wondering if it is possible to generate scripts without a COLLATE
> statement included from EM (I don't see how) or a tool which will allow me
> to
> do it.
> Currently I simply manually remove all Collate statements after the script
> file is created.
> Kevin|||Rusell,
Since I am only interested in in Tables, that actually does the trick.
Thanks.
kevin.
"Russell Fields" wrote:

> I believe there is a script options setting that you can use from EM to do
> some global tailoring of your results.
> You can set the Formatting Option "Only script 7.0 compatible features"
> which will eliminate collation, but it will also drop UDFs and other SQL
> 2000 features.
> RLF
> "kevin" <kevin@.discussions.microsoft.com> wrote in message
> news:4AFB6BC9-3FC1-41FD-B07E-BB43DD6285C6@.microsoft.com...
>
>|||On Thu, 9 Mar 2006 07:30:31 -0800, kevin wrote:

>using SQL 2K
>Just wondering if it is possible to generate scripts without a COLLATE
>statement included from EM (I don't see how) or a tool which will allow me
to
>do it.
Hi Kevin,
You can't control this from EM, but you can control it if you use Query
Analyser and the Object Explorer (hit F8 while in QA) to script.
In QA, click Tools / Options / Script. Then check or unchekc the option
"Do not script the collation if source is an instance of SQL Server
version 7.0 or later".
Hugo Kornelis, SQL Server MVP|||Hugo,
After all these years, I never noticed that. Thanks
Kevin
"Hugo Kornelis" wrote:

> On Thu, 9 Mar 2006 07:30:31 -0800, kevin wrote:
>
> Hi Kevin,
> You can't control this from EM, but you can control it if you use Query
> Analyser and the Object Explorer (hit F8 while in QA) to script.
> In QA, click Tools / Options / Script. Then check or unchekc the option
> "Do not script the collation if source is an instance of SQL Server
> version 7.0 or later".
> --
> Hugo Kornelis, SQL Server MVP
>