Cannot Access Server o.O

[Phoenix]

Mind telling me how it happened and how you fixed it? Because my database seriously doesn't give these errors.

[jur13n]

Mind telling me how it happened and how you fixed it? Because my database seriously doesn't give these errors.

i want to know it too, if you don't mind telling?

[llMafiall]

I dont want to quote his post that this community never helps. But take a look at him o.O

[jur13n]

I dont want to quote his post that this community never helps. But take a look at him o.O

yeh true..

fixed
/close please..
and he is saying the comunity won't help..
fine you tell us how u fixed >.<

[HeLMaX]

Mind telling me how it happened and how you fixed it? Because my database seriously doesn't give these errors.

Yea sure..
The cod should be:

/****** Object:  StoredProcedure [dbo].[spGetAccountInfo]    Script Date: 11/17/2010 14:36:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE  PROC [dbo].[spGetAccountInfo]
 @AID  int      
, @ServerID int = 0
AS    
BEGIN  
 SET NOCOUNT ON    

 SELECT AID, UserID, UGradeID, Name, HackingType
 , DATEPART(yy, EndHackingBlockTime) AS HackBlockYear, DATEPART(mm, EndHackingBlockTime) AS HackBlockMonth    
 , DATEPART(dd, EndHackingBlockTime) AS HackBlockDay, DATEPART(hh, EndHackingBlockTime) AS HackBlockHour    
 , DATEPART(mi, EndHackingBlockTime) AS HackBlockMin
 FROM Account(NOLOCK) WHERE AID = @AID      

 update Account set LastLoginTime = getdate(), ServerID = @ServerID  where AID = @AID  
END

I dont want to quote his post that this community never helps. But take a look at him o.O

Take a look at your self nab.

yeh true..

fixed
/close please..
and he is saying the comunity won't help..
fine you tell us how u fixed >.<

Don't break your ass.. Just ask for it why QQ ?