• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Setting up the Databases in Microsoft SQL Server Management Studio (MSSMS)

Status
Not open for further replies.
Ultraporing

Ultraporing

Junior Spellweaver
Joined
Apr 9, 2013
Messages
101
Reaction score
83
First a warning this management studio is in german, i tryed with paint to show you where to click.
The database scripts shown are from GigaToni's FAQ.

I've removed the user creation in the scripts and reuploaded them because we create our own user.
Download and unzip them:
You must be registered to see links


The pictures show the creation of the warz db, but you should first create the breezenet db with those steps, or you get a warning which can be ignored.


Step 0, set your server to SQL Authentication!:

First rightclick your server, then hit Properties.
Then select Security, and check SQL Authentication!
Hit OK.

You must be registered to see links


Step 1, Creating the Database:

Right Click the databases dropdown object and select new database.

, 1 - Setting up the Databases in Microsoft SQL Server Management Studio (MSSMS) - RaGEZONE Forums


Step 2, naming the DB:

Enter the name BreezeNet and click OK.
(for the warz, name it WarZ)

2 - Setting up the Databases in Microsoft SQL Server Management Studio (MSSMS) - RaGEZONE Forums


Step 3, opening the provided script:

Hit File->Open->File, or click the Button looking like a open folder.
Then navigate to your downloaded and unzipped script location and select breezenet.sql.
Hit Open.
(for the warz DB, open warz.sql)

3 - Setting up the Databases in Microsoft SQL Server Management Studio (MSSMS) - RaGEZONE Forums


Step 4, executing the script:

Hit execute.

4 - Setting up the Databases in Microsoft SQL Server Management Studio (MSSMS) - RaGEZONE Forums


Step 5, success!

Repeate Steps 1-5 for warz DB.

5 - Setting up the Databases in Microsoft SQL Server Management Studio (MSSMS) - RaGEZONE Forums


Step 6, user creation:

select in the dropdown: Security->Logins. And rightclick at logins, then click new login.

You must be registered to see links



Step 7, names and passwords:

enter a username then click SQL Authentication and enter a password.
Click "user assignment" in quotes because i dont know the name.

You must be registered to see links



Step 8, assigning users:

Mark the checkboxes next to your 2 new databases (WarZ, breezenet). Then click one of them so its highlighted. Check all boxes as shown in Red Box 2.
Highlight your other database by clicking on it and set there all user rolls too.
now click OK.

You must be registered to see links



CONGRATS! You are set up and ready to use your new databases!
 

Attachments

You must be registered for see attachments list
Last edited:
The Best DDoS Protected Servers
L

LayZ Gamer

Newbie Spellweaver
Joined
Mar 29, 2013
Messages
81
Reaction score
9
Is the following normal for breezenet? Got some similar errors in the warz table.
Msg 15007, Level 16, State 1, Line 2
'WZAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'wz_api_user' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'WOAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'BNAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'bn_api_user' is not a valid login or you do not have permission.
Click to expand...

warZ database
Msg 15007, Level 16, State 1, Line 2
'WZAdmin' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'wz_api_user' is not a valid login or you do not have permission.
Msg 15007, Level 16, State 1, Line 2
'bn_api_user' is not a valid login or you do not have permission.
Click to expand...
 
Last edited:
Ultraporing

Ultraporing

Junior Spellweaver
Joined
Apr 9, 2013
Messages
101
Reaction score
83
LayZ Gamer said:
When clicking execute
Click to expand...

you execute it on a empty db? It worked for me, im wondering right now why it says you dont have permissions.

Ive just read you need to create logins for those users.
Or remove the respective lines from the script
 
L

LayZ Gamer

Newbie Spellweaver
Joined
Mar 29, 2013
Messages
81
Reaction score
9
Ultraporing said:
you execute it on a empty db? It worked for me, im wondering right now why it says you dont have permissions.
Click to expand...

Yep empty, tried removing sql completely reinstalled at least 5 times and I get same thing.
 
Ultraporing

Ultraporing

Junior Spellweaver
Joined
Apr 9, 2013
Messages
101
Reaction score
83
Try removing lines 3-17 in breezenet script.
And lines 3-17 in warz script

we create our own db user so they shouldnt be needed.
 
L

LayZ Gamer

Newbie Spellweaver
Joined
Mar 29, 2013
Messages
81
Reaction score
9
Just this now on warZ

The module 'WZ_ACCOUNT_APPLYKEY' depends on the missing object 'BreezeNet.dbo.BN_WarZ_SerialGetInfo'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'WZ_ACCOUNT_APPLYKEY' depends on the missing object 'BreezeNet.dbo.BN_WarZ_SerialSetCustomerID'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'WZ_ACCOUNT_CREATE' depends on the missing object 'BreezeNet.dbo.BN_WarZ_SerialGetInfo'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'WZ_ACCOUNT_CREATE' depends on the missing object 'BreezeNet.dbo.BN_WarZ_SerialSetCustomerID'. The module will still be created; however, it cannot run successfully until the object exists.
Click to expand...

It all went through okay, so I assume it is fine?
 
Ultraporing

Ultraporing

Junior Spellweaver
Joined
Apr 9, 2013
Messages
101
Reaction score
83
LayZ Gamer said:
Just this now on warZ



It all went through okay, so I assume it is fine?
Click to expand...

did you first run the breezenet script or the warz script?
I think he is only bitching because of the order you've used the scripts.
 
V

verdu5

Newbie Spellweaver
Joined
Apr 11, 2013
Messages
10
Reaction score
0
Cant execute: Msg 102, Level 15, State 1, Line 16Incorrect syntax near '='.

what im doing wrong?...
 
HappyCampers

HappyCampers

Newbie Spellweaver
Joined
Apr 17, 2013
Messages
29
Reaction score
0
Get these errors when trying to execute the scripts

"BreezeNet"
Msg 139, Level 15, State 1, Procedure DB_BackupDatabase, Line 0Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_BackupDatabase, Line 13
Must declare the scalar variable "@databaseName".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderChangeEmail, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderChangeEmail, Line 40
Must declare the scalar variable "@msg".
Msg 139, Level 15, State 1, Procedure BN_WarZ_GetSerial, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure BN_WarZ_GetSerial, Line 11
Must declare the scalar variable "@SerialKey".
Msg 137, Level 15, State 2, Procedure BN_WarZ_GetSerial, Line 17
Must declare the scalar variable "@SerialKey".
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'WarZ.dbo.WZ_ACCOUNT_DELETE'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'WarZ.dbo.WZ_ACCOUNT_DELETE'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 156, Level 15, State 1, Procedure BN_Xsolla_CancelOrder, Line 18
Incorrect syntax near the keyword 'convert'.
Msg 137, Level 15, State 2, Procedure BN_Xsolla_CancelOrder, Line 31
Must declare the scalar variable "@OrderId".
Msg 137, Level 15, State 2, Procedure BN_Xsolla_CancelOrder, Line 62
Must declare the scalar variable "@OrderId".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 16
Must declare the scalar variable "@Serial1".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 29
Must declare the scalar variable "@Serial2".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 30
Must declare the scalar variable "@Serial3".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 31
Must declare the scalar variable "@Serial4".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 57
Must declare the scalar variable "@Serial1".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 69
Must declare the scalar variable "@Serial1".
Msg 139, Level 15, State 1, Procedure BN_Xsolla_StoreOrder, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_Xsolla_StoreOrder, Line 35
Must declare the scalar variable "@xOrderID".
Click to expand...

And for the "warZ"
Msg 911, Level 16, State 1, Line 1Could not locate entry in sysdatabases for database 'WarZ'. No entry found with that name. Make sure that the name is entered correctly.
Msg 139, Level 15, State 1, Procedure DB_BackupDatabase, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_BackupDatabase, Line 13
Must declare the scalar variable "@databaseName".
Msg 139, Level 15, State 1, Procedure FN_LevelUpBonus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_LevelUpBonus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_CreateMD5Password, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure FN_CreateMD5Password, Line 9
Must declare the scalar variable "@PASSWORD_SALT".
Msg 139, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 13
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 20
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 29
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 36
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 37
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure FN_AlterUserGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure FN_AlterUserGP, Line 13
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure FN_AlterUserGP, Line 26
Must declare the scalar variable "@GamePoints".
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure FN_AddItemToUser, Line 16
Must declare the scalar variable "@BuyStackSize".
Msg 137, Level 15, State 1, Procedure FN_AddItemToUser, Line 19
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 21
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 34
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 40
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 41
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 51
Must declare the scalar variable "@BuyStackSize".
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharCreate, Line 37
Must declare the scalar variable "@NumChars".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 38
Must declare the scalar variable "@NumChars".
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharCreate, Line 69
Must declare the scalar variable "@CharsCreated".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 70
Must declare the scalar variable "@CharsCreated".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 73
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 75
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 77
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 79
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 83
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 86
Must declare the scalar variable "@CharID".
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 26
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 32
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 38
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 44
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 57
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 58
Must declare the scalar variable "@Price7".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 59
Must declare the scalar variable "@Price30".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 60
Must declare the scalar variable "@PriceP".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 61
Must declare the scalar variable "@GPrice1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 62
Must declare the scalar variable "@GPrice7".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 63
Must declare the scalar variable "@GPrice30".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 64
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 71
Must declare the scalar variable "@IsEnabled".
Msg 139, Level 15, State 1, Procedure WZ_ClanCreate, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanCreate, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 20
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 40
Must declare the scalar variable "@DEFAULT_CLAN_SIZE".
Msg 137, Level 15, State 1, Procedure WZ_ClanCreate, Line 45
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 52
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 63
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 74
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 16
Must declare the scalar variable "@PlayerClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 17
Must declare the scalar variable "@PlayerClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 38
Must declare the scalar variable "@AppTotalCounts".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 39
Must declare the scalar variable "@AppTotalCounts".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 55
Must declare the scalar variable "@APPLY_EXPIRE_TIME_HOURS".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyGetList, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyGetList, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyGetList, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyGetList, Line 37
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 15
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 16
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 30
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 40
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 41
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 51
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 52
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 67
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 68
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 82
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 12
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 13
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 20
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 21
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 27
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 39
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 10
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 11
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 18
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 25
Must declare the scalar variable "@Alive".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 29
Must declare the scalar variable "@Alive".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 35
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_UpdateAchievementStatus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_SRV_NoteAddNew, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_SRV_NoteAddNew, Line 36
Must declare the scalar variable "@NoteID".
Msg 139, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 20
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 23
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 26
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 29
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 32
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 38
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 43
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 46
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 49
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 52
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateLeaderboard7, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard7, Line 13
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard7, Line 41
Must declare the scalar variable "@StartDay".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateLeaderboard30, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 13
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 14
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 42
Must declare the scalar variable "@StartDay".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateDailyLeaderboard, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateDailyLeaderboard, Line 39
Must declare the scalar variable "@CurDay".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 20
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 30
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 31
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 58
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 76
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetLore, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanSetLore, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetLore, Line 12
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 19
Must declare the scalar variable "@ClanRank".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 24
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanKickMember, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanKickMember, Line 18
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 19
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanKickMember, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanKickMember, Line 28
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 29
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 49
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 63
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 16
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 17
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 33
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 37
Must declare the scalar variable "@PendingInvites".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 57
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 69
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteReportAll, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteReportAll, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteReportAll, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteReportAll, Line 38
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 15
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 22
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 40
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 47
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 54
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 55
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 66
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 76
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanGetEvents, Line 15
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ClanGetEvents, Line 24
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackToInv, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 90
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 1, Procedure WZ_BackpackToInv, Line 110
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 113
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 126
Must declare the scalar variable "@InvInventoryID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 41
Must declare the scalar variable "@InventoryIdFrom".
Msg 137, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 42
Must declare the scalar variable "@InventoryIdTo".
Msg 137, Level 15, State 2, Procedure WZ_BackpackGridSwap, Line 45
Must declare the scalar variable "@InventoryIdFrom".
Msg 137, Level 15, State 2, Procedure WZ_BackpackGridSwap, Line 46
Must declare the scalar variable "@InventoryIdTo".
Msg 139, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 70
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 73
Must declare the scalar variable "@BackpackItemID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 83
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 91
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 114
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 118
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 131
Must declare the scalar variable "@BackpackInventoryID".
Msg 139, Level 15, State 1, Procedure WZ_ClanCreateCheckParams, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanCreateCheckParams, Line 11
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreateCheckParams, Line 12
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure DB_PurgeUnusedUserData, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_PurgeUnusedUserData, Line 47
Must declare the scalar variable "@InvCleanDate".
Msg 137, Level 15, State 2, Procedure DB_PurgeUnusedUserData, Line 48
Must declare the scalar variable "@InvCleanDate".
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'FN_CreateMD5Password'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 9
Must declare the scalar variable "@AccountType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 16
Must declare the scalar variable "@AccountType".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 32
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 36
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 40
Must declare the scalar variable "@keyCustomerID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 47
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 49
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 51
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 57
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 62
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 69
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure ADMIN_BanUser, Line 21
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 26
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 41
Must declare the scalar variable "@AccountType".
Msg 137, Level 15, State 1, Procedure ADMIN_BanUser, Line 43
Must declare the scalar variable "@BanCount".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 47
Must declare the scalar variable "@BanCount".
Msg 156, Level 15, State 1, Procedure ADMIN_BanUser, Line 62
Incorrect syntax near the keyword 'else'.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 66
Must declare the scalar variable "@BanTime".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 73
Must declare the scalar variable "@BanTime".
Msg 139, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 21
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_Backpack_SRV_AddItem, Line 22
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 47
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_Backpack_SRV_AddItem, Line 50
Must declare the scalar variable "@InventoryID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 20
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 50
Must declare the scalar variable "@BanExpireMin".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 55
Must declare the scalar variable "@BanExpireMin".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 94
Must declare the scalar variable "@SessionKey".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 106
Must declare the scalar variable "@SessionKey".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 125
Must declare the scalar variable "@SessionID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN, Line 20
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN, Line 43
Must declare the scalar variable "@AccountStatus".
Msg 139, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 16
Must declare the scalar variable "@dt1".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 20
Must declare the scalar variable "@dt1".
Msg 139, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 43
Must declare the scalar variable "@BanReason".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 50
Must declare the scalar variable "@BanReason".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 51
Must declare the scalar variable "@BanReason".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 24
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 28
Must declare the scalar variable "@keyResultCode".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 35
Must declare the scalar variable "@RefundCustomerID".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 36
Must declare the scalar variable "@RefundCustomerID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 41
Must declare the scalar variable "@refundedEmail".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 80
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 85
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 87
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 113
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 118
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 125
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackChange, Line 39
Must declare the scalar variable "@InvItemID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 40
Must declare the scalar variable "@InvCustomerID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 44
Must declare the scalar variable "@InvCharID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackChange, Line 51
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 52
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 58
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 61
Must declare the scalar variable "@InvQuantity".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 62
Must declare the scalar variable "@InvQuantity".
Msg 156, Level 15, State 1, Procedure WZ_BackpackChange, Line 65
Incorrect syntax near the keyword 'else'.
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 66
Must declare the scalar variable "@InvQuantity".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 75
Must declare the scalar variable "@InvItemID".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 24
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToMemberGP, Line 25
Must declare the scalar variable "@MemberClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 37
Must declare the scalar variable "@ClanGP".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToMemberGP, Line 42
Must declare the scalar variable "@ClanGP".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 20
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToClanGP, Line 26
Must declare the scalar variable "@GamePoints".
Msg 102, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 34
Incorrect syntax near '@in_GP'.
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToClanGP, Line 35
Must declare the scalar variable "@AlterGP".
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharDelete, Line 10
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 11
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharDelete, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 20
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 23
Must declare the scalar variable "@ClanRank".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 27
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 34
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 39
Must declare the scalar variable "@ClanID".
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'FN_AddItemToUser'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 23
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 24
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 25
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 42
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 43
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 44
Must declare the scalar variable "@out_FNResult".
Msg 102, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 50
Incorrect syntax near '@FinalPrice'.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 51
Must declare the scalar variable "@AlterGP".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 56
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 57
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 61
Must declare the scalar variable "@TType".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 66
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 70
Must declare the scalar variable "@InventoryID".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 23
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 24
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 25
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 42
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 43
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 44
Must declare the scalar variable "@out_FNResult".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 55
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 56
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 60
Must declare the scalar variable "@TType".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 65
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 69
Must declare the scalar variable "@InventoryID".
Click to expand...

What should i do?
 
War Inc

War Inc

Newbie Spellweaver
Joined
Apr 20, 2013
Messages
39
Reaction score
2
Hi,

warZ.sql

Code: 
Msg 139, Level 15, State 1, Procedure DB_BackupDatabase, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_BackupDatabase, Line 13
Must declare the scalar variable "@databaseName".
Msg 139, Level 15, State 1, Procedure FN_LevelUpBonus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_LevelUpBonus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_CreateMD5Password, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure FN_CreateMD5Password, Line 9
Must declare the scalar variable "@PASSWORD_SALT".
Msg 139, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 13
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure TEMP_AddGPToUser, Line 20
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 29
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 36
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure TEMP_AddGPToUser, Line 37
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure FN_AlterUserGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure FN_AlterUserGP, Line 13
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure FN_AlterUserGP, Line 26
Must declare the scalar variable "@GamePoints".
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure FN_AddItemToUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure FN_AddItemToUser, Line 16
Must declare the scalar variable "@BuyStackSize".
Msg 137, Level 15, State 1, Procedure FN_AddItemToUser, Line 19
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 21
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 34
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 40
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 41
Must declare the scalar variable "@CurDate".
Msg 137, Level 15, State 2, Procedure FN_AddItemToUser, Line 51
Must declare the scalar variable "@BuyStackSize".
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharCreate, Line 37
Must declare the scalar variable "@NumChars".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 38
Must declare the scalar variable "@NumChars".
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_CharCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharCreate, Line 69
Must declare the scalar variable "@CharsCreated".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 70
Must declare the scalar variable "@CharsCreated".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 73
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 75
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 77
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 79
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 83
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure WZ_CharCreate, Line 86
Must declare the scalar variable "@CharID".
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 26
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 32
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 38
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 1, Procedure WZ_BuyItemFN_GetPrice, Line 44
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 57
Must declare the scalar variable "@Price1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 58
Must declare the scalar variable "@Price7".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 59
Must declare the scalar variable "@Price30".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 60
Must declare the scalar variable "@PriceP".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 61
Must declare the scalar variable "@GPrice1".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 62
Must declare the scalar variable "@GPrice7".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 63
Must declare the scalar variable "@GPrice30".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 64
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_BuyItemFN_GetPrice, Line 71
Must declare the scalar variable "@IsEnabled".
Msg 139, Level 15, State 1, Procedure WZ_ClanCreate, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanCreate, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanCreate, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 20
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 40
Must declare the scalar variable "@DEFAULT_CLAN_SIZE".
Msg 137, Level 15, State 1, Procedure WZ_ClanCreate, Line 45
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 52
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 63
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreate, Line 74
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 16
Must declare the scalar variable "@PlayerClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 17
Must declare the scalar variable "@PlayerClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyToJoin, Line 38
Must declare the scalar variable "@AppTotalCounts".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 39
Must declare the scalar variable "@AppTotalCounts".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyToJoin, Line 55
Must declare the scalar variable "@APPLY_EXPIRE_TIME_HOURS".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyGetList, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyGetList, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyGetList, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyGetList, Line 37
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 15
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 16
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 30
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 40
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 41
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 1, Procedure WZ_ClanApplyAnswer, Line 51
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 52
Must declare the scalar variable "@AppClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 67
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 68
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanApplyAnswer, Line 82
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 12
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 13
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanAddClanMembers, Line 20
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 21
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 27
Must declare the scalar variable "@GPriceP".
Msg 137, Level 15, State 2, Procedure WZ_ClanAddClanMembers, Line 39
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 10
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 11
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 18
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_CharRevive, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharRevive, Line 25
Must declare the scalar variable "@Alive".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 29
Must declare the scalar variable "@Alive".
Msg 137, Level 15, State 2, Procedure WZ_CharRevive, Line 35
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_UpdateAchievementStatus, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_SRV_NoteAddNew, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_SRV_NoteAddNew, Line 36
Must declare the scalar variable "@NoteID".
Msg 139, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 20
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 23
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 26
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 1, Procedure WZ_LeaderboardGet, Line 29
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 32
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 38
Must declare the scalar variable "@TotalRows".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 43
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 46
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 49
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 137, Level 15, State 2, Procedure WZ_LeaderboardGet, Line 52
Must declare the scalar variable "@ROWS_TO_FETCH".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateLeaderboard7, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard7, Line 13
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard7, Line 41
Must declare the scalar variable "@StartDay".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateLeaderboard30, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 13
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 14
Must declare the scalar variable "@StartDay".
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateLeaderboard30, Line 42
Must declare the scalar variable "@StartDay".
Msg 139, Level 15, State 1, Procedure WZ_DB_GenerateDailyLeaderboard, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_DB_GenerateDailyLeaderboard, Line 39
Must declare the scalar variable "@CurDay".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 20
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetMemberRank, Line 30
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 31
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 58
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetMemberRank, Line 76
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanSetLore, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanSetLore, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanSetLore, Line 12
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 19
Must declare the scalar variable "@ClanRank".
Msg 137, Level 15, State 2, Procedure WZ_ClanSetLore, Line 24
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanKickMember, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanKickMember, Line 18
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 19
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanKickMember, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanKickMember, Line 28
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 29
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 49
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanKickMember, Line 63
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 16
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 17
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 33
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteSendToPlayer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 37
Must declare the scalar variable "@PendingInvites".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 57
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteSendToPlayer, Line 69
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteReportAll, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteReportAll, Line 13
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteReportAll, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteReportAll, Line 38
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 15
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 1, Procedure WZ_ClanInviteAnswer, Line 22
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 40
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 47
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 54
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 55
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 66
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanInviteAnswer, Line 76
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 14
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanGetEvents, Line 15
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanGetEvents, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ClanGetEvents, Line 24
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackToInv, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 90
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 1, Procedure WZ_BackpackToInv, Line 110
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 113
Must declare the scalar variable "@InvInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackToInv, Line 126
Must declare the scalar variable "@InvInventoryID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 41
Must declare the scalar variable "@InventoryIdFrom".
Msg 137, Level 15, State 1, Procedure WZ_BackpackGridSwap, Line 42
Must declare the scalar variable "@InventoryIdTo".
Msg 137, Level 15, State 2, Procedure WZ_BackpackGridSwap, Line 45
Must declare the scalar variable "@InventoryIdFrom".
Msg 137, Level 15, State 2, Procedure WZ_BackpackGridSwap, Line 46
Must declare the scalar variable "@InventoryIdTo".
Msg 139, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 70
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 73
Must declare the scalar variable "@BackpackItemID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 83
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 91
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 1, Procedure WZ_BackpackFromInv, Line 114
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 118
Must declare the scalar variable "@BackpackInventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackFromInv, Line 131
Must declare the scalar variable "@BackpackInventoryID".
Msg 139, Level 15, State 1, Procedure WZ_ClanCreateCheckParams, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanCreateCheckParams, Line 11
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanCreateCheckParams, Line 12
Must declare the scalar variable "@ClanID".
Msg 139, Level 15, State 1, Procedure DB_PurgeUnusedUserData, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_PurgeUnusedUserData, Line 47
Must declare the scalar variable "@InvCleanDate".
Msg 137, Level 15, State 2, Procedure DB_PurgeUnusedUserData, Line 48
Must declare the scalar variable "@InvCleanDate".
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'FN_CreateMD5Password'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 9
Must declare the scalar variable "@AccountType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 16
Must declare the scalar variable "@AccountType".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 32
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 36
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 40
Must declare the scalar variable "@keyCustomerID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 47
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_APPLYKEY, Line 49
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 51
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 57
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 62
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_APPLYKEY, Line 69
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure ADMIN_BanUser, Line 21
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 26
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 41
Must declare the scalar variable "@AccountType".
Msg 137, Level 15, State 1, Procedure ADMIN_BanUser, Line 43
Must declare the scalar variable "@BanCount".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 47
Must declare the scalar variable "@BanCount".
Msg 156, Level 15, State 1, Procedure ADMIN_BanUser, Line 62
Incorrect syntax near the keyword 'else'.
Msg 139, Level 15, State 1, Procedure ADMIN_BanUser, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 66
Must declare the scalar variable "@BanTime".
Msg 137, Level 15, State 2, Procedure ADMIN_BanUser, Line 73
Must declare the scalar variable "@BanTime".
Msg 139, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 21
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_Backpack_SRV_AddItem, Line 22
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 1, Procedure WZ_Backpack_SRV_AddItem, Line 47
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_Backpack_SRV_AddItem, Line 50
Must declare the scalar variable "@InventoryID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 20
Must declare the scalar variable "@IsDeveloper".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 50
Must declare the scalar variable "@BanExpireMin".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 55
Must declare the scalar variable "@BanExpireMin".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 94
Must declare the scalar variable "@SessionKey".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 106
Must declare the scalar variable "@SessionKey".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN_EXEC, Line 125
Must declare the scalar variable "@SessionID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_LOGIN, Line 20
Must declare the scalar variable "@AccountStatus".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_LOGIN, Line 43
Must declare the scalar variable "@AccountStatus".
Msg 139, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 16
Must declare the scalar variable "@dt1".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 20
Must declare the scalar variable "@dt1".
Msg 139, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure ADMIN_BanWeaponHackers, Line 43
Must declare the scalar variable "@BanReason".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 50
Must declare the scalar variable "@BanReason".
Msg 137, Level 15, State 2, Procedure ADMIN_BanWeaponHackers, Line 51
Must declare the scalar variable "@BanReason".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 24
Must declare the scalar variable "@keyResultCode".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 28
Must declare the scalar variable "@keyResultCode".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 35
Must declare the scalar variable "@RefundCustomerID".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 36
Must declare the scalar variable "@RefundCustomerID".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 41
Must declare the scalar variable "@refundedEmail".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 80
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 85
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure WZ_ACCOUNT_CREATE, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 87
Must declare the scalar variable "@DateActiveUntil".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 113
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 118
Must declare the scalar variable "@keySerialType".
Msg 137, Level 15, State 2, Procedure WZ_ACCOUNT_CREATE, Line 125
Must declare the scalar variable "@keySerialType".
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackChange, Line 39
Must declare the scalar variable "@InvItemID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 40
Must declare the scalar variable "@InvCustomerID".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 44
Must declare the scalar variable "@InvCharID".
Msg 139, Level 15, State 1, Procedure WZ_BackpackChange, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BackpackChange, Line 51
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 52
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 58
Must declare the scalar variable "@MaxSlots".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 61
Must declare the scalar variable "@InvQuantity".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 62
Must declare the scalar variable "@InvQuantity".
Msg 156, Level 15, State 1, Procedure WZ_BackpackChange, Line 65
Incorrect syntax near the keyword 'else'.
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 66
Must declare the scalar variable "@InvQuantity".
Msg 137, Level 15, State 2, Procedure WZ_BackpackChange, Line 75
Must declare the scalar variable "@InvItemID".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 24
Must declare the scalar variable "@MemberClanID".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToMemberGP, Line 25
Must declare the scalar variable "@MemberClanID".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToMemberGP, Line 37
Must declare the scalar variable "@ClanGP".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToMemberGP, Line 42
Must declare the scalar variable "@ClanGP".
Msg 139, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 20
Must declare the scalar variable "@GamePoints".
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToClanGP, Line 26
Must declare the scalar variable "@GamePoints".
Msg 102, Level 15, State 1, Procedure WZ_ClanDonateToClanGP, Line 34
Incorrect syntax near '@in_GP'.
Msg 137, Level 15, State 2, Procedure WZ_ClanDonateToClanGP, Line 35
Must declare the scalar variable "@AlterGP".
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharDelete, Line 10
Must declare the scalar variable "@CustomerID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 11
Must declare the scalar variable "@CustomerID".
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure WZ_CharDelete, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_CharDelete, Line 19
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 20
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 23
Must declare the scalar variable "@ClanRank".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 27
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 34
Must declare the scalar variable "@ClanID".
Msg 137, Level 15, State 2, Procedure WZ_CharDelete, Line 39
Must declare the scalar variable "@ClanID".
Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'FN_AddItemToUser'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists.
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 23
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 24
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 25
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 42
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 43
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 44
Must declare the scalar variable "@out_FNResult".
Msg 102, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 50
Incorrect syntax near '@FinalPrice'.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 51
Must declare the scalar variable "@AlterGP".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 56
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 57
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 61
Must declare the scalar variable "@TType".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GP, Line 66
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GP, Line 70
Must declare the scalar variable "@InventoryID".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 23
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 24
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 25
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 42
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 43
Must declare the scalar variable "@out_FNResult".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 44
Must declare the scalar variable "@out_FNResult".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 55
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 56
Must declare the scalar variable "@TType".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 60
Must declare the scalar variable "@TType".
Msg 139, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure WZ_BuyItem_GD, Line 65
Must declare the scalar variable "@InventoryID".
Msg 137, Level 15, State 2, Procedure WZ_BuyItem_GD, Line 69
Must declare the scalar variable "@InventoryID".


breezenet.sql
Code: 
Msg 139, Level 15, State 1, Procedure DB_BackupDatabase, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure DB_BackupDatabase, Line 13
Must declare the scalar variable "@databaseName".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderChangeEmail, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderChangeEmail, Line 40
Must declare the scalar variable "@msg".
Msg 139, Level 15, State 1, Procedure BN_WarZ_GetSerial, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 1, Procedure BN_WarZ_GetSerial, Line 11
Must declare the scalar variable "@SerialKey".
Msg 137, Level 15, State 2, Procedure BN_WarZ_GetSerial, Line 17
Must declare the scalar variable "@SerialKey".
Msg 156, Level 15, State 1, Procedure BN_Xsolla_CancelOrder, Line 18
Incorrect syntax near the keyword 'convert'.
Msg 137, Level 15, State 2, Procedure BN_Xsolla_CancelOrder, Line 31
Must declare the scalar variable "@OrderId".
Msg 137, Level 15, State 2, Procedure BN_Xsolla_CancelOrder, Line 62
Must declare the scalar variable "@OrderId".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 16
Must declare the scalar variable "@Serial1".
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 139, Level 15, State 1, Procedure BN_WarZ_PreorderRegister, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 29
Must declare the scalar variable "@Serial2".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 30
Must declare the scalar variable "@Serial3".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 31
Must declare the scalar variable "@Serial4".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 57
Must declare the scalar variable "@Serial1".
Msg 137, Level 15, State 2, Procedure BN_WarZ_PreorderRegister, Line 69
Must declare the scalar variable "@Serial1".
Msg 139, Level 15, State 1, Procedure BN_Xsolla_StoreOrder, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Procedure BN_Xsolla_StoreOrder, Line 35
Must declare the scalar variable "@xOrderID".
 
Status
Not open for further replies.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
141
Guests online
10,896
Total visitors
11,037
Totals may include hidden visitors.

Forum statistics

Threads
429,198
Messages
4,590,912
Members
281,304
Latest member
ismodev
Most visitors online was 12717 , on 1 May 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top