[Request] 2014 SQL Database

10/19/2017 08:29 Yolo143#1
Can some one give me a Clean(Fix) 2014 SQL Database I've heard that some database has a problem with their ranking or something in inventory/bank. If you don't mind can someone please give me a Fix 2014 SQL Database? Thank you.

Regards
10/19/2017 10:00 Dr. Peacock#2
i dont know if this include fixes but it is on SQL2014 ^^
10/19/2017 11:02 Unleashed!#3
As far as i know the only problems is the old syntax for left inner joins in character_str. Dont take my word for it though as i didnt look further into it. the fix for the procedure is included in Blouflashs VS2107 files. This will allow you to login and play at least. I dont know of other problems.
10/19/2017 15:55 Yolo143#4
I tried to use the SQL of Blouflashs but its not compatible with my 2014 SQL I don't know why lol.

Its weird I got this error using The database linked by @[Only registered and activated users can see links. Click Here To Register...]
I got the same error while using the database of Blouflashs.

Code:
Msg 15048, Level 16, State 3, Line 97
Valid values of the database compatibility level are 100, 110, or 120.
Msg 5069, Level 16, State 1, Line 97
ALTER DATABASE statement failed.
Msg 15048, Level 16, State 3, Line 151
Valid values of the database compatibility level are 100, 110, or 120.
Msg 5069, Level 16, State 1, Line 151
ALTER DATABASE statement failed.
Msg 15048, Level 16, State 3, Line 205
Valid values of the database compatibility level are 100, 110, or 120.
Msg 5069, Level 16, State 1, Line 205
ALTER DATABASE statement failed.
Msg 15025, Level 16, State 1, Line 257
The server principal 'account' already exists.
Msg 15025, Level 16, State 1, Line 261
The server principal 'eocrm' already exists.
Msg 15025, Level 16, State 1, Line 265
The server principal 'log01' already exists.
Msg 15025, Level 16, State 1, Line 269
The server principal 'character01' already exists.
OLE DB provider "SQLNCLI11" for linked server "CHR01" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "CHR01" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 2, Level 16, State 1, Line 759
Named Pipes Provider: Could not open a connection to SQL Server [2]. 

(1 row(s) affected)

(1 row(s) affected)
OLE DB provider "SQLNCLI11" for linked server "RANKING" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "RANKING" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 2, Level 16, State 1, Line 7443
Named Pipes Provider: Could not open a connection to SQL Server [2]. 
Msg 208, Level 16, State 1, Procedure view_last_3_month, Line 18427
Invalid object name 'LOGGING_01_DBF.dbo.VIEW_LOG_LOGIN_TBL'.
Msg 208, Level 16, State 1, Procedure view_last_1_month, Line 18446
Invalid object name 'LOGGING_01_DBF.dbo.VIEW_LOG_LOGIN_TBL'.
I'am using SQL Server 2014 Management Studio