Re: SQL Server Management Studio dependencies

[Greg Keogh]

Dr L, you're completely right. Here is the proof of the unexpected
dependency during SSMS2012 setup:

[image: Inline images 1]

Easily overlooked during an install, but at least it explains what
happened. It's still running but I can see it's made Program
Files\Microsoft Visual Studio 10.0 with Common7, IDE and Packages folders.

Greg K


On 3 November 2013 16:27, Greg Keogh  wrote:

> I have a new Win7 VM with VS2013 freshly installed, so I'll install SSMS
> 2012 and see what happens, see if (or how much) footprint of VS2010 comes
> along with it -- Greg
>
>
> On 3 November 2013 15:20, GregAtGregLowDotCom  wrote:
>
>> Same logic applies to SSMS2008 and SSMS2008R2 and their dependency on the
>> VS2008 shell.
>>
>>
>>
>> Regards,
>>
>>
>>
>> Greg
>>
>>
>>
>> Dr Greg Low
>>
>>
>>
>> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913
>> fax
>>
>> SQL Down Under | Web: www.sqldownunder.com
>>
>>
>>
>> *From:* ozdotnet-boun...@ozdotnet.com [mailto:
>> ozdotnet-boun...@ozdotnet.com] *On Behalf Of *GregAtGregLowDotCom
>> *Sent:* Sunday, 3 November 2013 3:19 PM
>> *To:* ozDotNet
>> *Subject:* RE: SQL Server Management Studio dependencies
>>
>>
>>
>> You can’t have SSMS2012 without some aspects of VS2010 as SSMS2012 lives
>> within the VS2010 shell. That’s like trying to run a VS2010 add-in without
>> VS2010.
>>
>>
>>
>> Regards,
>>
>>
>>
>> Greg
>>
>>
>>
>> Dr Greg Low
>>
>>
>>
>> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913
>> fax
>>
>> SQL Down Under | Web: www.sqldownunder.com
>>
>>
>>
>> *From:* ozdotnet-boun...@ozdotnet.com [
>> mailto:ozdotnet-boun...@ozdotnet.com ] *On
>> Behalf Of *Greg Keogh
>> *Sent:* Sunday, 3 November 2013 1:28 PM
>> *To:* ozDotNet
>> *Subject:* Re: SQL Server Management Studio dependencies
>>
>>
>>
>> So running repair on SSMS 2012 would have just put back the components of
>> the VS2010 shell.
>>
>>
>>
>> Oh drats! That's the reverse of what I'm trying to do. I've got to figure
>> out how to utterly remove VS2010 (if it's possible).
>>
>>
>>
>> When I finish today's hobby coding I'll run a global search through the
>> registry to try and get clues about which products have their lives
>> entwined with VS2010, then see if it's safe to attempt to untangle them.
>>
>>
>>
>> Greg K
>>
>
>
<>

Re: SQL Server Management Studio dependencies

[Greg Keogh]

I have a new Win7 VM with VS2013 freshly installed, so I'll install SSMS
2012 and see what happens, see if (or how much) footprint of VS2010 comes
along with it -- Greg


On 3 November 2013 15:20, GregAtGregLowDotCom  wrote:

> Same logic applies to SSMS2008 and SSMS2008R2 and their dependency on the
> VS2008 shell.
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> Dr Greg Low
>
>
>
> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913
> fax
>
> SQL Down Under | Web: www.sqldownunder.com
>
>
>
> *From:* ozdotnet-boun...@ozdotnet.com [mailto:
> ozdotnet-boun...@ozdotnet.com] *On Behalf Of *GregAtGregLowDotCom
> *Sent:* Sunday, 3 November 2013 3:19 PM
> *To:* ozDotNet
> *Subject:* RE: SQL Server Management Studio dependencies
>
>
>
> You can’t have SSMS2012 without some aspects of VS2010 as SSMS2012 lives
> within the VS2010 shell. That’s like trying to run a VS2010 add-in without
> VS2010.
>
>
>
> Regards,
>
>
>
> Greg
>
>
>
> Dr Greg Low
>
>
>
> 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913
> fax
>
> SQL Down Under | Web: www.sqldownunder.com
>
>
>
> *From:* ozdotnet-boun...@ozdotnet.com [
> mailto:ozdotnet-boun...@ozdotnet.com ] *On
> Behalf Of *Greg Keogh
> *Sent:* Sunday, 3 November 2013 1:28 PM
> *To:* ozDotNet
> *Subject:* Re: SQL Server Management Studio dependencies
>
>
>
> So running repair on SSMS 2012 would have just put back the components of
> the VS2010 shell.
>
>
>
> Oh drats! That's the reverse of what I'm trying to do. I've got to figure
> out how to utterly remove VS2010 (if it's possible).
>
>
>
> When I finish today's hobby coding I'll run a global search through the
> registry to try and get clues about which products have their lives
> entwined with VS2010, then see if it's safe to attempt to untangle them.
>
>
>
> Greg K
>

RE: SQL Server Management Studio dependencies

[GregAtGregLowDotCom]

Same logic applies to SSMS2008 and SSMS2008R2 and their dependency on the
VS2008 shell.

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax


SQL Down Under | Web:   www.sqldownunder.com

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of GregAtGregLowDotCom
Sent: Sunday, 3 November 2013 3:19 PM
To: ozDotNet
Subject: RE: SQL Server Management Studio dependencies

 

You can't have SSMS2012 without some aspects of VS2010 as SSMS2012 lives
within the VS2010 shell. That's like trying to run a VS2010 add-in without
VS2010.

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax


SQL Down Under | Web:   www.sqldownunder.com

 

From: ozdotnet-boun...@ozdotnet.com 
[mailto:ozdotnet-boun...@ozdotnet.com] On Behalf Of Greg Keogh
Sent: Sunday, 3 November 2013 1:28 PM
To: ozDotNet
Subject: Re: SQL Server Management Studio dependencies

 

So running repair on SSMS 2012 would have just put back the components of
the VS2010 shell.

 

Oh drats! That's the reverse of what I'm trying to do. I've got to figure
out how to utterly remove VS2010 (if it's possible).

 

When I finish today's hobby coding I'll run a global search through the
registry to try and get clues about which products have their lives entwined
with VS2010, then see if it's safe to attempt to untangle them.

 

Greg K

RE: SQL Server Management Studio dependencies

[GregAtGregLowDotCom]

You can't have SSMS2012 without some aspects of VS2010 as SSMS2012 lives
within the VS2010 shell. That's like trying to run a VS2010 add-in without
VS2010.

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax


SQL Down Under | Web:   www.sqldownunder.com

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Sunday, 3 November 2013 1:28 PM
To: ozDotNet
Subject: Re: SQL Server Management Studio dependencies

 

So running repair on SSMS 2012 would have just put back the components of
the VS2010 shell.

 

Oh drats! That's the reverse of what I'm trying to do. I've got to figure
out how to utterly remove VS2010 (if it's possible).

 

When I finish today's hobby coding I'll run a global search through the
registry to try and get clues about which products have their lives entwined
with VS2010, then see if it's safe to attempt to untangle them.

 

Greg K

Re: SQL Server Management Studio dependencies

[Greg Keogh]

>
> So running repair on SSMS 2012 would have just put back the components of
> the VS2010 shell.
>

Oh drats! That's the reverse of what I'm trying to do. I've got to figure
out how to utterly remove VS2010 (if it's possible).

When I finish today's hobby coding I'll run a global search through the
registry to try and get clues about which products have their lives
entwined with VS2010, then see if it's safe to attempt to untangle them.

Greg K

RE: I forget, but which API is used to develop against SQL Server, the one that allows people to create alternative interfaces for it.

[GregAtGregLowDotCom]

Hi Katherine, 

In this case, I think you're referring to SMO.
http://technet.microsoft.com/en-us/library/ms162169.aspx

Regards,

Greg

Dr Greg Low

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax

SQL Down Under | Web: www.sqldownunder.com

Hi all,
I was curious about this because I've seen a couple of web products that
basically create the Management studio in ASP.net or in some other
interface.  I forget which of Microsoft's APIs allows for that.  There are a
couple of open source projects that need to be updated pertaining to this,
and one of these days, I'd definitely like to take that on.  Can someone
remind me which API is possibly being used?  I know that it's extensible, or
else I wouldn't have seen what does exist out there, no matter how
out-of-date.  

RE: SQL Server Management Studio dependencies

[GregAtGregLowDotCom]

Hi Greg,

 

SSMS 2012 runs inside the VS2010 shell. It's probably not surprising that
removing VS2010 causes SSMS 2012 problems. I suppose it would be nice if
VS2010 had an understanding of all things that used its shell but it
doesn't. So running repair on SSMS 2012 would have just put back the
components of the VS2010 shell.

 

Regards,

 

Greg

 

Dr Greg Low

 

1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax


SQL Down Under | Web:   www.sqldownunder.com

 

From: ozdotnet-boun...@ozdotnet.com [mailto:ozdotnet-boun...@ozdotnet.com]
On Behalf Of Greg Keogh
Sent: Saturday, 2 November 2013 7:46 PM
To: ozDotNet
Subject: SQL Server Management Studio dependencies

 

Here's a bit of a warning ... Last week I uninstalled VS2010 as it was
running alongside VS2012 and it was of no use any more. Tonight I launch
SSMS 2012 and it says required components are missing and tells me to
reinstall. Web searches produce lots of hits, and suggestions about deleting
registry keys are worthless. I ran the SSMS 2012 installer exe again and
picked "Repair". This miraculously made it work again.

 

I also noticed that the registry keys under SSMS have dozens of references
to VS2010 folders. I changed some of the more obvious ones to point to
equivalent VS2012 folders, which fixed some other warning popups that I was
getting.

 

So basically there is an unholy tangle of dependencies between SSMS and VS
versions more subtle than I suspected, so be careful. I look forward to
building a brand new machine next Xmas to clear all of the detritus out. I'm
always irritated by the way many "big" products don't uninstall so easily or
so cleanly, leaving fragments all over the place.

 

Greg K

I forget, but which API is used to develop against SQL Server, the one that allows people to create alternative interfaces for it.

[Katherine Moss]

Hi all,
I was curious about this because I've seen a couple of web products that 
basically create the Management studio in ASP.net or in some other interface.  
I forget which of Microsoft's APIs allows for that.  There are a couple of open 
source projects that need to be updated pertaining to this, and one of these 
days, I'd definitely like to take that on.  Can someone remind me which API is 
possibly being used?  I know that it's extensible, or else I wouldn't have seen 
what does exist out there, no matter how out-of-date.  

SQL Server Management Studio dependencies

[Greg Keogh]

Here's a bit of a warning ... Last week I uninstalled VS2010 as it was
running alongside VS2012 and it was of no use any more. Tonight I launch
SSMS 2012 and it says required components are missing and tells me to
reinstall. Web searches produce lots of hits, and suggestions about
deleting registry keys are worthless. I ran the SSMS 2012 installer exe
again and picked "Repair". This miraculously made it work again.

I also noticed that the registry keys under SSMS have dozens of references
to VS2010 folders. I changed some of the more obvious ones to point to
equivalent VS2012 folders, which fixed some other warning popups that I was
getting.

So basically there is an unholy tangle of dependencies between SSMS and VS
versions more subtle than I suspected, so be careful. I look forward to
building a brand new machine next Xmas to clear all of the detritus out.
I'm always irritated by the way many "big" products don't uninstall so
easily or so cleanly, leaving fragments all over the place.

Greg K