Sorry, I forgot the where clause. Here's the new execution plan.

There is no clustered index on this table. Just one index.

Here's the execution plan.

CREATE TABLE [dbo].[MYTABLE](

[ID] [int] NOT NULL,

[CRDATETIME] [datetime] NULL,

[CREATORID] [int] NULL,

[CLASSID] [int] NULL,

[PARENTID] [int] NULL,

[USERID] [int] NULL,

[WHEN] [datetime] NULL,

[LOCKTYPEORD] [smallint] NULL,

[COMPUTERNAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[LOCKOBJECTNAME] [varchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[FOLDERNAME] [varchar](30) COLLATE...

I apologize, I'm a SQL Dummy and I'm not familiar with the term DDL. Are you wanting the scripts to create the table and index?

Ok, I think I am able to answer my own question. These numbers were pointing to an object in my database.

DBCC TraceOn(3604)

DBCC PAGE(7,1,1771344)

select * from sysobjects where id =...

Thank you for the response. I'll read up on the "with execute as" some more.

Our application creates the SQL users and I don't want to have to go into...

yes - that's the case, but I obviously dont want the existing number to change.

Please share so I'll know for next time.

The column should have been identity in the first place, but it wasn't. Way too many rows in table and definitely timing out because of this. Took a different plan...

I'm not physically opening the excel spreadsheet. I created a stored procedure that exports data to excel and then attaches it as an email.

I found a workaround for this....

I was able to fix this by following the steps below:

Use Master

Go

sp_configure 'allow updates', 1

reconfigure with override

Go

b. Get the value of the status column in sysdatabase table

select * from sysdatabases...

Yes, this will work! Thanks, Steve.

Thanks. Pointing me to the Outer join did it, but I needed to join on two fields, my client and my value.

Here's what I ended up doing:

select tablea.ID, tablea.client, tablea.value,...

Thanks. Both of my queries took less than a second to run so I couldn't tell the difference, but according to your calculation the milliseconds are being displayed, right? And...

I too have used the winzip command line and it works great.

Thanks, again.

My field was a text field, so I couldn't use = '%'

Server: Msg 306, Level 16, State 1, Line 1

The text, ntext, and image data types cannot be...