Try the CREATE TABLE statement below in your Query Analyzer and when you run  the SELECT statement click on show results in a grid in the Query Analyzer.  Another solution is what I recommended in the post below.    Hope this helps.

http://forums.asp.net/871599/ShowPost.aspx

CREATE TABLE [EmployeePhoto] (
 [EmployeePhotoID] [int] IDENTITY (1, 1) NOT NULL ,
 [ThumbNailPhoto] [image] NULL ,
 [ThumbnailPhotoFileName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [LargePhoto] [image] NULL ,
 [LargePhotoFileName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
 [ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_EmployeePhoto_ModifiedDate] DEFAULT (getdate()),
 CONSTRAINT [PK_EmployeePhoto_EmployeePhotoID] PRIMARY KEY  CLUSTERED
 (
  [EmployeePhotoID]
 )  ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO