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.
so. after seeing that i went searching for this, magical procedure. I found it, tried to run it. and i get this error.
and this is all thats on line 53
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
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')}
Code:
Msg 208, Level 16, State 6, Procedure sp_addlinkedserver, Line 53 Invalid object name 'sys.sp_addlinkedserver'.
Code:
-- ADD THE LINKED-SERVER
Appreciated in advance any help :)
[SOLVED] turns out if i add sleep & coffee to the mix i can do amazing things :P