Register for your free account! | Forgot your password?

You last visited: Today at 22:42

  • Please register to post and access all features, it's quick, easy and FREE!


[Request] 2014 SQL Database

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2017
Posts: 95
Received Thanks: 2
[Request] 2014 SQL Database

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



Yolo143 is offline  
Old 10/19/2017, 10:00   #2
 
elite*gold: 60
Join Date: Sep 2017
Posts: 321
Received Thanks: 95
i dont know if this include fixes but it is on SQL2014 ^^
Attached Files
File Type: rar Database2014.rar (68.8 KB, 11 views)


Dr. Peacock is offline  
Thanks
1 User
Old 10/19/2017, 11:02   #3
 
elite*gold: 0
Join Date: Nov 2011
Posts: 395
Received Thanks: 230
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.
Unleashed! is offline  
Old 10/19/2017, 15:55   #4
 
elite*gold: 0
Join Date: Apr 2017
Posts: 95
Received Thanks: 2
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 @Dr. Peacock
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
Yolo143 is offline  
Reply



« Item Duration | [Help]Disable PartyFinder on GS »

Similar Threads
[SQL] Restore database on sql 2008
11/14/2012 - Flyff PServer - Discussions / Questions - 2 Replies
hallo, i just installed sql 2008, and i want to restore the database's but i cant select them... look as you se, i wanne restore database, the .bak filles are inside the good folder etc etc?.. wy cant i select them? help plz
[SQL-Error]Sql Database For HellmouthSoruce
04/28/2011 - CO2 PServer - Discussions / Questions - 10 Replies
Hello, i was setting up the Hellmouth source 5300+ everything was going smoothly and because i'm stupid and noob + i never used/liked navicat i got error when trying to execute the sql databse and here's the error ...



All times are GMT +2. The time now is 22:42.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.