C'mon Tony, get it right! Here is the code pasted in as a 'snippet' and using & e n s p ;

[font="Courier New"]USE [master]

GO

CREATE DATABASE [Test_DB] ON PRIMARY

   (

            NAME = N'Test_DB',

            FILENAME = N'D:\MSSQL\Data\Test_DB.mdf' ,

            SIZE = 102400KB ,

            MAXSIZE = UNLIMITED,

            FILEGROWTH = 102400KB

   )

         LOG ON

   (

            NAME = N'Test_DB_log',

            FILENAME = N'E:\MSSQL\Logs\Test_DB_log.ldf' ,

            SIZE = 51200KB ,

            MAXSIZE = 2048GB ,

            FILEGROWTH = 51200KB

   )

         COLLATE SQL_Latin1_General_CP1_CI_AS

GO[/font]

and here is is using nbsp; in a code block. The first time I pasted it in, it lost its indentation (if you paste it in, then preview it... is my best guess)

[font="Courier New"]USE [master]

GO

CREATE DATABASE [Test_DB] ON PRIMARY

(

NAME = N'Test_DB',

FILENAME = N'D:\MSSQL\Data\Test_DB.mdf' ,

SIZE = 102400KB ,

MAXSIZE = UNLIMITED,

FILEGROWTH = 102400KB

)

LOG ON

(

NAME = N'Test_DB_log',

FILENAME = N'E:\MSSQL\Logs\Test_DB_log.ldf' ,

SIZE = 51200KB ,

MAXSIZE = 2048GB ,

FILEGROWTH = 51200KB

)

COLLATE SQL_Latin1_General_CP1_CI_AS

GO[/font]

and here is the ensp version which never seems to lose its indentation. It will be all right in IE6 once you lose the ghastly grey background

[font="Courier New"]USE [master]

GO

CREATE DATABASE [Test_DB] ON PRIMARY

   (

            NAME = N'Test_DB',

            FILENAME = N'D:\MSSQL\Data\Test_DB.mdf' ,

            SIZE = 102400KB ,

            MAXSIZE = UNLIMITED,

            FILEGROWTH = 102400KB

   )

         LOG ON

   (

            NAME = N'Test_DB_log',

            FILENAME = N'E:\MSSQL\Logs\Test_DB_log.ldf' ,

            SIZE = 51200KB ,

            MAXSIZE = 2048GB ,

            FILEGROWTH = 51200KB

   )

         COLLATE SQL_Latin1_General_CP1_CI_AS

GO[/font]