I tried deleting just 10 records directly as follows:

delete from tblDocument where DocumentID in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)

The delete ran for over a minute,...

--Table definition (with relevant indexes)

CREATE TABLE [dbo].[tblDocument](

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

[Category] [varchar](50) NULL,

[Number] [varchar](50) NULL,

[State] [varchar](50) NULL,

[CreatedDate] [datetime] NULL,

[CreatedBy] [varchar](50) NULL,

[ModifiedDate] [datetime] NULL,

[ModifiedBy] [varchar](50) NULL,

[DirType] [int] NULL,

[DocumentName] [varchar](200) NULL,

[FileName] [varchar](200)...

I think I found the problem - the execution plan for the stored procedure. (SQL Profiler helped point the way.)

The stored procedure is called with a date range. I suspect...

I know for a fact that the ASP page is only executing the SP once and is timing out on this one call.

The SQL Server is our production server and...

Sorry. I guess I wasn't very clear. The same "exec usp_...." SQL code that the ASP page executes is what I am executing in Query Analyzer. (I showed the SQL...

Would it be advantagous to carefully convert the identity columns to BIGINT?

Lighten up, people! SQL Server isn't the only DB in the world.

Defining the length of a column in SQL Server defines both the number of characters to display and the maximum...

No deadlocks, just lockouts. The isolation levels are most likely the defaults.

When I try viewing conflicts for the publication, I get "An unexpected error occured while trying to launch the Conflict Viewer". Any suggestions on how to fix this?