SWSRO DC

[Only registered and activated users can see links. Click Here To Register...]

?????? SWSRO Server File DC :S :( Help plz :)

[Only registered and activated users can see links. Click Here To Register...]

i'm working on redoing the databases back to mssql server 2000 since everything over mssql2000 is just a waste of resources.
i am having the same problem atm.
does anyone have an idea why it happened? :)
still looking for myself, but i'm not finding the cause :S

that's cuz the shity globalmanager , try to use globalmanager of SL files or vsro ,
i really don't try but i check and i find that globalmanager with swsro files are completely damaged .

wrong.
i found the problem:
you renamed your account database!

now you have to change the name in a stored procedure as well.

open the shard database,
select "programability"
then "stored procedures"
and then right-click the stored procedure called "_GET_REMAIN_SILK"
select "modify"
and then replace the line
"exec SR_AccountDB.dbo._GETSILKDATAFORGAMESERVER @JID, @Silk_Own ....."
with the name of your database. (red needs to be edited ;))
then click on "execute" at the top :)

Shard DB -> Programmability -> Stored Procedures -> dbo._GET_REMAIN_SILK(Modify)

Quote:

set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[_GET_REMAIN_SILK] @JID int, @Silk_Own int output, --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -- 마일리지 최선호) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @Silk_Gift int output, @Mileage int output --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ as --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -- 마일리지 최선호) --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ exec YOUR_ACCOUNT_DB_NAME_HERE.dbo._GetSilkDataForGameServer @JID, @Silk_Own output, @Silk_Gift output, @Mileage output --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

and you're done, this error happened when you changed the account db name, its SrAccountDB (w/e) so you need to change it in _GET_REMAIN_SILK


Edit:silkbotter was faster ;)

hurr hurr =)
so i deserve a thanks. and you don't :P

btw.. sql server 2000 rocks asses! and it saves 1 gb of ram when full in use :P

i say i don't check this well :)
but it's oky that u find where is the problem ^ _ ^

Quote:

Originally Posted by silkbotter hurr hurr =) so i deserve a thanks. and you don't :P btw.. sql server 2000 rocks asses! and it saves 1 gb of ram when full in use :P

sure and if u use windows server 2000 u can use only 1 GB ram with only 3GHz normal processor ;)

Quote:

Originally Posted by Dr.Abdelfattah i say i don't check this well :) but it's oky that u find where is the problem ^ _ ^ sure and if u use windows server 2000 u can use only 1 GB ram with only 3GHz normal processor ;)

ewww..yes.. but i was talking about a sql server 2000 ;)
running on a win server 2003 :P

and not on win server 2000 ^^