Stored Procedures

[lxchadxl]

Can anybody please help me? None of my stored procedures are able to work.

Here are a few examples:

Dbo.spWinTheClanGame

Msg 201, Level 16, State 4, Procedure spWinTheClanGame, Line 0
Procedure or function 'spWinTheClanGame' expects parameter '@WinnerCLID', which was not supplied.

(1 row(s) affected)

Dbo.spGetClanRanking

Msg 201, Level 16, State 4, Procedure spGetClanRanking, Line 0
Procedure or function 'spGetClanRanking' expects parameter '@Page', which was not supplied.

(1 row(s) affected)

Dbo.spGetFriendList

Msg 201, Level 16, State 4, Procedure spGetFriendList, Line 0
Procedure or function 'spGetFriendList' expects parameter '@CID', which was not supplied.

(1 row(s) affected)

All help is greatly appreciated, thanks.

 

[gReGiTh]

I'd remake the database from scratch. Also if there was a backup that came along with it, try restoring the database.

If you keep getting this problem and you've tried using a different db, you can manually edit the sql script to include those missing parameters - or atleast check for any problems in the script that would prevent them from being created.

 

[lxchadxl]

Mind teaching my how to use the .bak file? I can't drag and drop, neither can I click on open.. -> GunzDB.bak because .bak is used by sony vegas 9. and when i click on open sony vegas opens it, not the database.

 

[death4u2]

right click GunzDB then task>restore db

 

[lxchadxl]

 

[lxchadxl]

Bump, please help guys thank you.

 

[Wucas]

maybe you should re install mssql?