Hi There,

I'm getting the same error also. I know there are at least two spids being blocked.

I did a sp_who2 and found the database where the spid was doing...

Thanks Man. I'll give that a shot on Monday. Looks good.

I added the db in the alter index to see if that worked. The select keeps referring back to master where the SP is located even though I have...

Here you go. A simple cursor than pulls in the owner/schema as well as the table.

Thanks

USE [master]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

Alter proc [dbo].[reindex_all_PJL]

@DB sysname, @fillfactor INT = 90

as

set arithabort...