Update statistics reqTablePref WITH FULLSCAN,ALL.

Then recompile your stored procedure

Good luck!

Well that sounds like a terrible bug. I guess you will have to open a case with PSS.

Sorry!

I am with Remi here. Can you just post in the J O B S forums ?

"Disable" in my opinion is not to use Identity ever again at will. Because there are more than one table, according to the poster requirements, such "disable" is not possible.

When...

Note:

DEPENDING on the *strength* of your IO subsystem you may still recive timeouts eventhough defrag is an online operation still requires a transaction log space.

The best bet is as it...

or:

DECLARE @tbl TABLE(PartNo varchar(20))

INSERT INTO @tbl VALUES('12345|03')

SELECT REPLACE(PartNo, '|','')

FROM @tbl

WHERE CHARINDEX('|', PartNo) > 0

If you are using 2005 ( as this forum name suggests ) you should be able to create the index with the "ONLINE" option.

you are missing the "alias" in the inline query:

select count(Wt_Id) as Weight_Unit

from (select Wt_Id, Hosp_id from hpl.Weight_Unit where isNumeric(hosp_id) = 1) K

where CAST(Hosp_id AS int) BETWEEN 373 AND 378

That's what America is all about

Computed columns can be persited in 2000 also ( by creating an index on them )

Count me in. I think that thread was just "sick"

This problems tend to happens when the replica is didconnected from the primary for a long time usually due to time-outs, network outages or heavy locking, etc. It will stop...

Me too

yeah but you can't CREATE VIEW db.dbo.view

SET INDENTITY_INSERT ON does *NOT* disables the identity property. It merely let the batch exceuting it specify a value for the identity column but that is different from "disabling"

The...