SQL Management Studio and Visual Studio 2005

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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?

.

Relevant Pages

  • VS.NET 2005 and SQL Server Management Studio
    ... I have just started working with SQL Server Management Studio and ... managing database scripts in a database project under VS.NET. ... and have it open up in management studio to be modified. ... Unfortunately, for some reason every time I try to open a script, it ...
    (microsoft.public.vsnet.ide)
  • Re: SQL Management Studio and Visual Studio 2005
    ... Andrew J. Kelly SQL MVP ... managing database scripts in a database project under VS.NET. ... and have it open up in management studio to be modified. ... Unfortunately, for some reason every time I try to open a script, it ...
    (microsoft.public.sqlserver.tools)
  • Problems running SQL scripts outside Management Studio
    ... I have a script that populates some tables in a database. ... When the scripts are executed via Management Studio the values are loaded ... reading each line of the text file and executing at each "GO" the ...
    (microsoft.public.sqlserver.tools)
  • RE: Strange Behavior w SQL Server Management Studio
    ... >> Alright I am having a couple of strange problems with SQL Server Management ... In SS Management Studio I can attempt to run the ... >> between batches or I get the error messages below. ...
    (microsoft.public.sqlserver.tools)
  • Datenbank via Script erzeugen - Berechtigungen?
    ... SQL Server Management Studio verwende. ... Wenn ich das Script aber aus dem Programm starte geht es nicht. ... per Script zu erzeugen. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)