Game001 error help

01/22/2012 01:36 hackfever#1
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 god i save backups daily
01/22/2012 21:17 haxti#2
You db is pretty messed up i'd say. Try to restore a backup
01/22/2012 23:07 hackfever#3
restored all working now thankfully i save backups daily