i able write simple script able drop localdb database @ will.
first have stop instance kill active connections running in vs package manager
sqllocaldb.exe stop v11.0 then need drop db have connecting (localdb)\v11.0 master db linqpad or ssms
drop database mydb but don't want switch windows this, i'd write script. can't figure out how execute second query command line. i've tried this
sqlcmd.exe -s "(localdb)\v11.0" -d "master" -q "drop database mydb" which gives me error
sqlcmd.exe : sqlcmd: error: microsoft sql server native client 11.0 : named pipes provider: not open connection sql server [2]. .
it looks should work if use capital letter "s"
sqlcmd.exe -s "(localdb)\v11.0" -d "master" -q "drop database mydb" you'd want use capital "q" sqlcmd exit immediately.
