maximilion2 Posted July 25, 2011 Share 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.. Link to comment Share on other sites More sharing options...
0 Face Posted July 25, 2011 Share Posted July 25, 2011 you are missing some files! Link to comment Share on other sites More sharing options...
0 maximilion2 Posted July 25, 2011 Author Share Posted July 25, 2011 you are missing some files! what files? any idea where i can find them? Link to comment Share on other sites More sharing options...
0 mcbigmac Posted July 25, 2011 Share 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. Link to comment Share on other sites More sharing options...
0 maximilion2 Posted July 25, 2011 Author Share 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?? Link to comment Share on other sites More sharing options...
0 Sighed Posted July 25, 2011 Share 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. Link to comment Share on other sites More sharing options...
0 maximilion2 Posted July 25, 2011 Author Share 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 :( Link to comment Share on other sites More sharing options...
0 relic Posted July 25, 2011 Share Posted July 25, 2011 just relog and its done if you cant reload it :) Link to comment Share on other sites More sharing options...
0 maximilion2 Posted July 25, 2011 Author Share 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.. Link to comment Share on other sites More sharing options...
0 maximilion2 Posted July 25, 2011 Author Share Posted July 25, 2011 maybe my dbscript isn't working good? Link to comment Share on other sites More sharing options...
0 fendar Posted August 2, 2011 Share 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 Link to comment Share on other sites More sharing options...
0 supersam999 Posted July 2, 2012 Share Posted July 2, 2012 I have same problem , I made first create and still same error, Can anyone help me with fix it? Link to comment Share on other sites More sharing options...
0 Sighed Posted July 4, 2012 Share 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 ? Link to comment Share on other sites More sharing options...
0 maximilion2 Posted July 4, 2012 Author Share Posted July 4, 2012 i fixed it long time ago when i was developing off lol Link to comment Share on other sites More sharing options...
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..
Link to comment
Share on other sites
13 answers to this question
Recommended Posts