I am running into this issue with Visual Studio 2008 Team System SP1 database project. It will allow me to drag one script but not multiple. I am publishing this to my blog to investigate, so let me explain.
I have a database project with an active connection to the database and a few scripts. My goal is to drag my scripts as shown below to the active instance (a SQL Server 2008 instance to be exact)
If I highlight one sql script and drag it to the instance and I get this message:
It works and the script executed after I select yes. Note the text on the dialog, it clearly talks about multiples queries/scripts. Plural!
The problem arises when I select multiple scripts and drag them. At that point I am not allowed to drop:
Does anyone reading provide insight? Thanks!