game001 says this when i try to start uses all memory then crashes
DB COM ERROR(thread 2, HRESULT:80040e37 , guid:0c733a63-2a
artup (on server startup) : invalid object name 'item'.
i went to telecaster on server start up and everything semms to be right there it looks like this
USE [telecaster]
GO
/****** Object: StoredProcedure [dbo].[on_server_startup] Script Date: 11/03/2011 10:03:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- start of smp_insert_character
ALTER PROCEDURE [dbo].[on_server_startup]
@OUT_SID INT OUTPUT
AS
SET NOCOUNT ON
DECLARE @SID INT;
DECLARE @ITEM INT
SELECT MAX(sid) as max_id FROM Item with (nolock) where sid =@ITEM
SELECT MAX(sid) as max_id FROM Skill with (nolock) where sid =@SID
UPDATE Character SET name = '@' + name WHERE delete_time <= GETDATE() and name not like '@%'
SELECT MAX(sid) as max_id FROM Pet with (nolock) where sid =SID
i used search and found 1 post with a similar problem but the fix diddnt work
nevermind was hacked thank *** i save backups daily
 |
