SSMSE Hangs Deleting Multiple Records

Hi All

I'm new to sql server. I have built simple database apps using MFC CRecordset over MS Access. I'm tying to learn about SQL server by building a simple app using MFC CRecordset in Visual Studio 2005.



The problem I have is within SQL Server Management studio experess. I have a table called OriginalDrawings that looks like this

CREATE TABLE [dbo].[OriginalDrawings](

[DrawingID] [int] IDENTITY(1,1) NOT NULL,

[OriginalFileName] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,

[PartNumber] [varchar](50) COLLATE Latin1_General_CI_AS NOT NULL,

[SheetNumber] [int] NULL,

[Revision] [varchar](50) COLLATE Latin1_General_CI_AS NULL,

[OriginalDirectory] [varchar](100) COLLATE Latin1_General_CI_AS NULL,

[DrawingCategory] [int] NOT NULL,

[ProductFamily] [int] NOT NULL,

[IsSalvage] [bit] NULL,

[FileSize] [int] NULL,

[DataQueryFlag] [bit] NOT NULL,

[DataQueryCode] [int] NULL,

CONSTRAINT [PK_OriginalDrawings] PRIMARY KEY CLUSTERED

(

[DrawingID] ASC

)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]



I've loaded it with 40,000 records from my test app. If I open it in SSMSE hit Ctrl-A to select all and then press delete SSMSE appears to hang - it freezes for 10 mins+ (after which I restart my PC. I can delete 1000 records at a time OK, I can delete all quite quickly from my test app by walking through the recordset and deleting each record.



Does anyone know why it appears to hang when I try the delete all?



Thanks

Alec



SQL Server 2005 Express 9.00.3042.00

Microsoft SQL Server Management Studio Express 9.00.2047.00


Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600