Need Help about this 2 Errors

[KILLSTEAL]

2010-08-10 10:12:09 PS_USERLOG__system start log (UserLog) 2010-08-10 10:12:09 2010-08-10 10:12:15 connect connect 2010-08-10 10:12:17 2010 connect -08-10 10:12:17 2010-08-10 10:20:50 connect err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] space for the 'dbo.UserLog'. "PK_UserLog ' object in the 'PS_GameLog' database could not be assigned because the filegroup' PRIMARY 'is full. Space may, by deleting unnecessary files, deleting objects in the filegroup, adding files to the filegroup, or setting the automatic increase for existing files will be extracted in the filegroup., SQL STATE: 42000, NATIVE ERROR: 1105 (0x451) 2010-08 -10 DBWrite 10:20:50:: LogLogins: err =- 1, query = EXEC usp_Try_GameLogout_R 10239,3032228854933487617,1, '64 '2010-08-10

PS_USERLOG


2010-08-10 10:12:11 PS_GAMELOG__system start log (GameLog01) 2010-08-10 10:12:15 2010-08-10 10:12:17 game connect connect game 2010-08-10 10:13:17 err =- 1, [Microsoft] [ODBC SQL Server Driver] [SQL Server] space for the 'dbo.ActionLog' object in the 'PS_GameLog' database could not be assigned because the filegroup' PRIMARY 'is full. Space may, by deleting unnecessary files, deleting objects in the filegroup, adding files to the filegroup, or setting the automatic increase for existing files will be extracted in the filegroup., SQL STATE: 42000, NATIVE ERROR: 1105 (0x451) 2010-08 -10 DBWrite 10:13:17:: LogGame: err =- 1, query =''EXEC usp_Insert_Action_Log_E, 0.22115, '_.Vlady._', 0,0,0, 0.0,0.0,0.0, '2010 -08-10 10:13:17 ', 223.3023461503832555520, 36209,120292,0, NULL, NULL, NULL, NULL, NULL, NULL,' Walker hit ', '0, 0,0,0,0,0 (Option: 00000100060003000000) ', '2010-07-26

PS_GAMELOG






Any SQL fix for delet this or any other help please !

 

[Twilight]

1. Shrink database PS_GameLog (Shrink - see google)
2. or clear tables dbo.ActionLog and others Log...
TRUNCATE command

You must be registered to see links

 

[KILLSTEAL]

thank you i have fixed now this problem