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.

  • Recent Comments

    Thanks for this simple yet delightful code....
    Hey guys I'm having the same problem as Netanel KL { “Error HRESUL...
    Soluciono el problema con el primero (First step solved it for me)....
    Thank you! I was looking for this. You save my day!...
    Thank you! This was a big help. My requirement was a little differen...
    Thanks, after a small path adjustment it worked for Visual Studio 2015...
    Good call!...
    Thank you .. this helped...
    How about when you have a long string with no space? I tried it and it...
    Thank you, I ran into this same issues with Visual Studio 2015 after i...
  • Blog Stats

    • 138,462 hits