[HELP] Remove OMG_Gameweb from New SQL

09/14/2013 11:18 uDied#1

How to I remove the OMG_Gameweb from the new SQL new installation.sql ?

Code:

/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
	EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END	
EXEC sp_addsrvrolemember 'Shaiya', 'sysadmin';

TRUNCATE TABLE PS_UserData.dbo.Users_Master;
TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;
TRUNCATE TABLE PS_UserData.dbo.Users_Detail;
	
if exists(select * 
from master..sysservers 
where isremote=1 and srvname='game') 
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_NCASH') 
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_USERDB') 
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_USERDB01') 
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_DEFINEDB') 
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_GAMEDB01') 
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123'
	
/* Add to Game User: admin, Password: admin123 and user information*/

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
	INSERT INTO PS_UserData.dbo.Users_Master
	(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
	VALUES (1,'gmlight', 'gmlight123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END


IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
	INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
	(UserUID,GameAccount,OneTimePassword,OTPExpireDate,DelCharPWD,CreateDate)
	VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
	INSERT INTO PS_UserData.dbo.Users_Detail
	(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQuestion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
	Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,Sms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
	Job,JobNo,LocalNo,PwQuNo)
	VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer','email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0',
	'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END

I do not have the OMG_Gameweb database. Thats why I need to remove it from the query. Thx for any info on this

09/14/2013 11:44 nubness#2

Quote:

Code:

IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
	INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
	(UserUID,GameAccount,OneTimePassword,OTPExpireDate,DelCharPWD,CreateDate)
	VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

This is what you have to remove from your query.

09/15/2013 01:34 uDied#3

When I remove that it still give me an error.

Msg 4701, Level 16, State 1, Line 9
Cannot find the object "GameAccountTBL" because it does not exist or you do not have permissions.

This is what i have with out what you said nubness. Thx for responding btw.

Code:

/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
	EXEC sp_addlogin 'Shaiya', 'Shaiya123', 'PS_GameDefs';
END	
EXEC sp_addsrvrolemember 'Shaiya', 'sysadmin';

TRUNCATE TABLE PS_UserData.dbo.Users_Master;
TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;
TRUNCATE TABLE PS_UserData.dbo.Users_Detail;
	
if exists(select * 
from master..sysservers 
where isremote=1 and srvname='game') 
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_NCASH') 
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_USERDB') 
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_USERDB01') 
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_DEFINEDB') 
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'Shaiya','Shaiya123'

if exists(select * 
from master..sysservers 
where isremote=1 and srvname='PS_GAMEDB01') 
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'Shaiya','Shaiya123'
	
/* Add to Game User: admin, Password: admin123 and user information*/

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
	INSERT INTO PS_UserData.dbo.Users_Master
	(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
	VALUES (1,'gmlight', 'gmlight123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END
IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
	INSERT INTO PS_UserData.dbo.Users_Detail
	(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQuestion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
	Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,Sms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
	Job,JobNo,LocalNo,PwQuNo)
	VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer','email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','0',
	'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END

And when I try to remove anything thats says OMG_Gameweb it just gives more errors. I saw somewhere that someone said to patch the loging over it but didnt really say anything else and im not sure what they mean by that.

09/15/2013 10:36 nubness#4

Since we're not totally aware of your real situation, why don't you simply attach the OMG_GameWeb database ? It never harms.

09/22/2013 14:51 Autrux#5

#closed