generating .aql scripts in sql server 2005

[ice7899]

Is it possible to generate a .sql script in the sql server 2000 format using sql server 2005

I would like to generate a script in this format using 2005




if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CLSFD_AdBlocks]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CLSFD_AdBlocks]
GO

CREATE TABLE [dbo].[CLSFD_AdBlocks] (
[BlockID] [bigint] IDENTITY (1, 1) NOT NULL ,
[MemberID] [bigint] NULL ,
[SenderEmail] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SenderIP] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[CLSFD_AdBlocks] WITH NOCHECK ADD
CONSTRAINT [PK_CLSFD_AdBlocks] PRIMARY KEY CLUSTERED
(
[BlockID]
) ON [PRIMARY]
GO

 

[mrdenny]

Unfornitually no. Microsoft wasn't able to get this functionality into the final release. We are all hopping that it will be comming along is a future service pack release.

If you right click on the database in the object explorer you can get to the scripting wizzard. You will need to run it twice. Once for the drop and once for the create.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com