Visual Studio 2008 Database Project: Unable to drag multiple SQL Scripts

Posted by OmegaMan at December 21, 2009

Category: Bug Reports

Tags: ,

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.

Scenario

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)

Database Target

If I highlight one sql script and drag it to the instance and I get this message:

Single

It works and the script executed after I select yes. Note the text on the dialog, it clearly talks about multiples queries/scripts. Plural!

Problem

The problem arises when I select multiple scripts and drag them. At that point I am not allowed to drop:

Denial

Does anyone reading provide insight? Thanks!

Share

2 Comments

  1. Bruce Boughton says

    What order would you expect the scripts to execute in?

    Reply
    • omegaman says

      When one uses File Explorer and selects multiple files and then drops them; the target software gets the files in the order which the user selected them. That would be what I would guess. But I realize that scenario would present different issues as well. 🙂

      Reply

Leave a comment

(required)
(required) (will not be published)

This site uses Akismet to reduce spam. Learn how your comment data is processed.