last smc problem ??plz help me.all work machine etc

[ichigo14000]

last smc problem ??plz help me.all work machine etc-----------|
|
i use ip4... |
---------------------------------------------------------------

[zikor1337]

/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end


GO

in your SRO_VT_SHARD database and restart everything

[ichigo14000]

Originally Posted by zikor1337

/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end


GO

in your SRO_VT_SHARD database and restart everything

Msg 2714, Level 16, State 3, Procedure _ExistsServiceOffRentItem, Line 9
There is already an object named '_ExistsServiceOffRentItem' in the database.