SQL Management Studio and Visual Studio 2005

6 Oct 2006 6:27 PM

darren.yu

Hey All,

I have just started working with SQL Server Management Studio and
VS.NET 2005 and am trying to do a little bit of integration between the
two programs.

We are using sourcesafe for source control.

Because of Management Studio's rather lacking Solution/Project support
(Doesn't let you have folders inside projects!), I was planning on
managing database scripts in a database project under VS.NET. As a
result, It'd be nice if I could double click on a sql file in .NET 2005
and have it open up in management studio to be modified.

Unfortunately, for some reason every time I try to open a script, it
starts a new instance of mngt studio instead of opening the script in
the existing window, in a tab!

Does anybody know a work around or fix?

6 Oct 2006 9:38 PM

Andrew J. Kelly

I cant answer that but you might want to have a look at this before going
too much further:
http://msdn.microsoft.com/vstudio/teamsystem/dbpro/

--
Andrew J. Kelly SQL MVP

<darren***@gmail.com> wrote in message

Show quote

news:1160159243.238098.223350@i42g2000cwa.googlegroups.com...
> Hey All,
>
> I have just started working with SQL Server Management Studio and
> VS.NET 2005 and am trying to do a little bit of integration between the
> two programs.
>
> We are using sourcesafe for source control.
>
> Because of Management Studio's rather lacking Solution/Project support
> (Doesn't let you have folders inside projects!), I was planning on
> managing database scripts in a database project under VS.NET. As a
> result, It'd be nice if I could double click on a sql file in .NET 2005
> and have it open up in management studio to be modified.
>
> Unfortunately, for some reason every time I try to open a script, it
> starts a new instance of mngt studio instead of opening the script in
> the existing window, in a tab!
>
> Does anybody know a work around or fix?
>

7 Oct 2006 1:48 AM

Sue Hoegemeier

Don't know of any fix. But another option would be to just
work from Management Studio and when you want to open a .sql
file, just go to the Menu to Edit and select Insert File as
Text and open SQL files in whatever directory.

-Sue

On 6 Oct 2006 11:27:23 -0700, darren***@gmail.com wrote:

Show quote

>Hey All,
>
>I have just started working with SQL Server Management Studio and
>VS.NET 2005 and am trying to do a little bit of integration between the
>two programs.
>
>We are using sourcesafe for source control.
>
>Because of Management Studio's rather lacking Solution/Project support
>(Doesn't let you have folders inside projects!), I was planning on
>managing database scripts in a database project under VS.NET. As a
>result, It'd be nice if I could double click on a sql file in .NET 2005
>and have it open up in management studio to be modified.
>
>Unfortunately, for some reason every time I try to open a script, it
>starts a new instance of mngt studio instead of opening the script in
>the existing window, in a tab!
>
>Does anybody know a work around or fix?