Hi all,
I'm using generating SQL script from SQL 2K. After that when I run those SQL scripts on SQL Server 7.0, has problem is SQL Server 7.0 not accept COLLATE, how can I generate SQL script from SQL 2K which not have COLLATE of SQL 2K.
Thank for your help.

I believe you have to change the collation of the SqL 2000 server to match the collation of the existing SQL 7.0 collation then script your database

Look it up on Books Online

Selecting a SQL Collation
  New Information - SQL Server 2000 SP3.

When selecting a SQL collation in the Collations Settings screen, use the following table to make the installation of Microsoft® SQL Server™ 2000 compatible with an installation of an earlier version of SQL Server.



Note Each SQL Collation name has an equivalent string in T-SQL code. For a list of sort order identifiers and the T-SQL version, see SQL Collation Name.

Thank you very much,
My problem was fixed. But I have another problem when I use SQLDMO Scripting table structure I got script again has contain "COLLATE SQL_Latin1_General_CP1_CI_AI" ( [LastName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AI NOT NULL ) when I need script is "[LastName] [nvarchar] (20) NOT NULL" Could you tell me about parameter of ObjectScripting Contanst or how to fix this problem.
Thank for your help.

I am not 100% clear on what you trying to say but if you do not want the collation when you are scripting and object.

Open Query Analyzer
select tools
select options
select script tab
select option " do not script the collation clause if source is an instance of SQL server version 7.0 or later"

I hope this answers your question?