Yes sql 2008

Thanks

Thank you,
I know has creation_time and  last_execution_time, not sure if that means any new query plan added, I mean any new that never executed before or not in DMV...

Thank you

Thank you all, yes I ran upgrade advisor and there were no issue, other than sql server level warning

I tried datalength, I tried many other things didn’t work. At...

Thank you for reply, yes we rebuilt all indexes and ran UPDATE STATISTIC and still same,

I will run DBCC CHECKD.

Thank you for your suggestion

My question is simple what is the different on TEXT data type from sql 2000 to sql 2008?

Why same table , same data size , same column, same statement...

Sorry guys, I don't know what else to explain 🙁

active items for that month

Thank you all, here the details

CREATE TABLE tbItems

(

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

[itemno] [varchar](10) NOT NULL, -- unique index

[Purchasedate] [datetime] NOT NULL,

[Solddate] [datetime] NULL,

[CrDate] [datetime] DEFAULT getdate()

)

CREATE UNIQUE NONCLUSTERED INDEX...

Thank you for your time and reply, I know how to do the script, but my question is: how to get active inventory by given date (month & year) from...

Yes, I think that is the case

You can create new sp to grant permission to this user, then run your SP finally revoke the permission for it, this may work