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

09/18/2011 19:16 ichigo14000#1
last smc problem ??plz help me.all work machine etc-----------|
|
i use ip4... |
---------------------------------------------------------------
[Only registered and activated users can see links. Click Here To Register...]
09/18/2011 19:28 zikor1337#2
Code:
/****** 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
09/18/2011 19:33 ichigo14000#3
Quote:
Originally Posted by zikor1337 View Post
Code:
/****** 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.