maximilion2 Posted July 25, 2011 Posted July 25, 2011 Hi all.When i put this in sql server management studio drop database lin2clancomm drop database lin2comm drop database lin2db drop database lin2log drop database lin2report drop database lin2user drop database lin2world drop database petition go create database lin2clancomm create database lin2comm create database lin2db create database lin2log create database lin2report create database lin2user create database lin2world create database petition go then that message appears: Msg 3701, Level 11, State 1, Line 1 Cannot drop the database 'lin2clancomm', because it does not exist or you do not have permission. Msg 3701, Level 11, State 1, Line 2 Cannot drop the database 'lin2comm', because it does not exist or you do not have permission. Msg 3701, Level 11, State 1, Line 3 Cannot drop the database 'lin2db', because it does not exist or you do not have permission. Msg 3701, Level 11, State 1, Line 4 Cannot drop the database 'lin2log', because it does not exist or you do not have permission. Msg 3701, Level 11, State 1, Line 5 Cannot drop the database 'lin2report', because it does not exist or you do not have permission. Msg 3701, Level 11, State 1, Line 6 Cannot drop the database 'lin2user', because it does not exist or you do not have permission. Msg 3701, Level 11, State 1, Line 7 Cannot drop the database 'lin2world', because it does not exist or you do not have permission. Msg 3701, Level 11, State 1, Line 8 Cannot drop the database 'petition', because it does not exist or you do not have permission. Any idea? i logged in with sa and psw..
0 maximilion2 Posted July 25, 2011 Author Posted July 25, 2011 you are missing some files! what files? any idea where i can find them?
0 mcbigmac Posted July 25, 2011 Posted July 25, 2011 you are missing some files! If you have no idea wtf your talking about, don't try to lecture people. If you can read the TSQL script, you can see it tries to drop(delete/flush) the Databases first and then creates them. Incase some already existed and are corrupted/badly structured etc. Hence, no error.
0 maximilion2 Posted July 25, 2011 Author Posted July 25, 2011 If you have no idea wtf your talking about, don't try to lecture people. If you can read the TSQL script, you can see it tries to drop(delete/flush) the Databases first and then creates them. Incase some already existed and are corrupted/badly structured etc. Hence, no error. so how can i fix it??
0 Sighed Posted July 25, 2011 Posted July 25, 2011 so how can i fix it?? Just right click on databases and press reload, what happened is that you are trying to delete databases that don't exist, so the errors come from it, but that's all, you don't get more errors cause after that the databases are correctly created.
0 maximilion2 Posted July 25, 2011 Author Posted July 25, 2011 Just right click on databases and press reload, what happened is that you are trying to delete databases that don't exist, so the errors come from it, but that's all, you don't get more errors cause after that the databases are correctly created. i pressed right click but no see reload :(
0 maximilion2 Posted July 25, 2011 Author Posted July 25, 2011 just relog and its done if you cant reload it :) oks i relloged but same :( i can see databases but there aren't any files in tables..
0 fendar Posted August 2, 2011 Posted August 2, 2011 just read error you are trying to delete databases which are not in SQL server if you are running this script for first time than use only Create .... part after than you may drop databases
0 supersam999 Posted July 2, 2012 Posted July 2, 2012 I have same problem , I made first create and still same error, Can anyone help me with fix it?
0 Sighed Posted July 4, 2012 Posted July 4, 2012 I got a question for all of you. If the database don't exist... Why The Fuck You Are Running A Query That Deletes Them First ?
0 maximilion2 Posted July 4, 2012 Author Posted July 4, 2012 i fixed it long time ago when i was developing off lol
Question
maximilion2
Hi all.When i put this in sql server management studio
drop database lin2clancomm
drop database lin2comm
drop database lin2db
drop database lin2log
drop database lin2report
drop database lin2user
drop database lin2world
drop database petition
go
create database lin2clancomm
create database lin2comm
create database lin2db
create database lin2log
create database lin2report
create database lin2user
create database lin2world
create database petition
go
then that message appears:
Msg 3701, Level 11, State 1, Line 1
Cannot drop the database 'lin2clancomm', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 1, Line 2
Cannot drop the database 'lin2comm', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 1, Line 3
Cannot drop the database 'lin2db', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 1, Line 4
Cannot drop the database 'lin2log', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 1, Line 5
Cannot drop the database 'lin2report', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 1, Line 6
Cannot drop the database 'lin2user', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 1, Line 7
Cannot drop the database 'lin2world', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 1, Line 8
Cannot drop the database 'petition', because it does not exist or you do not have permission.
Any idea? i logged in with sa and psw..
13 answers to this question
Recommended Posts