Item Mall

kheyo · 04/12/2011, 08:46

Ok so im getting the item mall crashing with error 1. Yes i checked the search and tried things but i came up with this error log.

Code:

2011-04-12 02:20:42 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_NCASH' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2011-04-12 02:20:42 SaveBuyPointItem 14 TEST qerr=0, {?=call usp_Save_User_BuyPointItems_NCash(8,14,0,'PK_primm0001','2011-04-12 02:20:41')}

so. after seeing that i went searching for this, magical procedure. I found it, tried to run it. and i get this error.

Code:

Msg 208, Level 16, State 6, Procedure sp_addlinkedserver, Line 53
Invalid object name 'sys.sp_addlinkedserver'.

and this is all thats on line 53

Code:

	-- ADD THE LINKED-SERVER

Any thoughts on how to fix this? with or without the procedure, i really dont care i just want the errors to stop lol. Ive been trying to figure this out and it has got me stumped.

Appreciated in advance any help

[SOLVED] turns out if i add sleep & coffee to the mix i can do amazing things :P