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..

you are missing some files!

you are missing some files!

 

what files? any idea where i can find them?

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.

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??

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.

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 :(

just relog and its done if you cant reload it :)

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..

maybe my dbscript isn't working good?

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

I have same problem , I made first create and still same error, Can anyone help me with fix it?

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 ?

i fixed it long time ago when i was developing off lol