Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate

Autor Topic: Ayuda con Base de datos MuOnline.sql query.  (Visto 1598 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline sapatilla Posteado: May 13, 2018, 12:27:00 AM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 62
  • Gracias recibida: 20
  • ar
Hola muchachos, quiziera entender y comprender, como instalo una base de datos MuOnline.sql o .txt (con la sentencia sql query dentro)

me baso en los files season 2 Evolution Games aportado aqui en este foro, no logro poder poner la consulta, como se instala? gracias.

Gracias:


Offline cipgrim #1 Posteado: May 13, 2018, 12:33:29 AM

  • 0 puntos por ventas
  • *
  • Rank: Dedicado
  • Posts: 36
  • Gracias recibida: 10
  • ar
Crea primero la base de datos MuOnline por ejemplo y luego ejecutas el query. Si es el texto con el query dentro vas a la base de datos MuOnline, segundo click y le das a nueva consulta, luego f5.


Offline sapatilla #2 Posteado: May 13, 2018, 01:06:25 AM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 62
  • Gracias recibida: 20
  • ar
Si crack, pero me tira error que la base ya esta creada, ahora te mando foto!


Offline sapatilla #3 Posteado: May 13, 2018, 01:21:42 AM

  • 0 puntos por ventas
  • *
  • Rank: Usuario activo
  • Posts: 62
  • Gracias recibida: 20
  • ar
Me tira este error al crear la DB que debo hacer?

The CREATE DATABASE process is allocating 3.25 MB on disk 'MuOnline_Data'.
The CREATE DATABASE process is allocating 218.63 MB on disk 'MuOnline_Log'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'CItemExeSP'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_CheckValue'. The stored procedure will still be created.
Server: Msg 207, Level 16, State 3, Procedure WHS_UPD_Money, Line 10
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_UPD_Money, Line 15
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 3, Procedure WHS_UPD_MnyPwDbv, Line 11
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_UPD_MnyPwDbv, Line 21
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 3, Procedure WHS_UPD_Items, Line 10
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_UPD_Items, Line 15
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 3, Procedure WHS_SELECT, Line 12
Invalid column name 'NeedExtCK'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 19
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 19
Invalid column name 'NeedExtCK'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 23
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 24
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 32
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 36
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 38
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 42
Invalid column name 'Number'.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
Server: Msg 446, Level 16, State 9, Procedure MY_CLEAR_NOCHARID, Line 24
Cannot resolve collation conflict for equal to operation.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.


Offline davidrcj #4 Posteado: May 13, 2018, 01:29:38 AM

  • 0 puntos por ventas
  • *
  • Rank: Puto amo
  • Posts: 390
  • Gracias recibida: 3129
  • ve
Me tira este error al crear la DB que debo hacer?

The CREATE DATABASE process is allocating 3.25 MB on disk 'MuOnline_Data'.
The CREATE DATABASE process is allocating 218.63 MB on disk 'MuOnline_Log'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'CItemExeSP'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_CheckValue'. The stored procedure will still be created.
Server: Msg 207, Level 16, State 3, Procedure WHS_UPD_Money, Line 10
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_UPD_Money, Line 15
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 3, Procedure WHS_UPD_MnyPwDbv, Line 11
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_UPD_MnyPwDbv, Line 21
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 3, Procedure WHS_UPD_Items, Line 10
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_UPD_Items, Line 15
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 3, Procedure WHS_SELECT, Line 12
Invalid column name 'NeedExtCK'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 19
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 19
Invalid column name 'NeedExtCK'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 23
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 24
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 32
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 36
Invalid column name 'Number'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 38
Invalid column name 'ExtCKNum'.
Server: Msg 207, Level 16, State 1, Procedure WHS_SELECT, Line 42
Invalid column name 'Number'.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
Server: Msg 446, Level 16, State 9, Procedure MY_CLEAR_NOCHARID, Line 24
Cannot resolve collation conflict for equal to operation.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'master..XP_MD5_EncodeKeyVal'. The stored procedure will still be created.
instala sql 2008 es mas estable, ya que su base de datos trabaja excelente con esa versión, y así te ahorras problemas.


Solo usuarios registrados pueden comentar y agradecer, Logueate o Registrate


 

Related Topics

  Subject / Started by Replies Last post
6 Replies
1509 Views
Last post November 02, 2017, 11:38:07 AM
by linkzero
0 Replies
860 Views
Last post May 07, 2018, 02:50:26 PM
by Yalc
3 Replies
1409 Views
Last post March 31, 2019, 06:59:44 PM
by joacoRu
1 Replies
1090 Views
Last post April 25, 2019, 09:02:41 PM
by Gaboo;
1 Replies
740 Views
Last post December 28, 2020, 12:21:19 PM
by lunaticodeveloper