January 6, 2017 at 12:26 pm
Hi All,
I posted a question before, but this questions is different then the other one.
I have both sql server 2008 and sql server 2012 on my computer. In the sqlserver 2008, I have a directory path like below:
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SSME.exe
and for sql server 2012, I have a directory path like below:
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\
In sql server 2008, I can see ssme.exe, but not in SQLserver 2012 directory path. I have the full version of sql server 2012 not the express version. I have the CD too.
From the run command if I do ssme.exe, it opens the sql server 2008 because it navigates to the below directory which has sql server 2008 installed.
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SSME.exe
I have windows 7 and the system is X64-bit
How can I get the SSME.exe for SQL server 2012.
Any help will be greatly appreciated.
January 6, 2017 at 12:31 pm
anjaliagarwal5 (1/6/2017)
Hi All,I posted a question before, but this questions is different then the other one.
I have both sql server 2008 and sql server 2012 on my computer. In the sqlserver 2008, I have a directory path like below:
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SSME.exe
and for sql server 2012, I have a directory path like below:
C:\Program Files\Microsoft SQL Server\110\Tools\Binn\ManagementStudio
In sql server 2008, I can see ssme.exe, but not in SQLserver 2012 directory path. I have the full version of sql server 2012 not the express version. I have the CD too.
From the run command if I do ssme.exe, it opens the sql server 2008 because it navigates to the below directory which has sql server 2008 installed.
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SSME.exe
I have windows 7 and the system is X64-bit
How can I get the SSME.exe for SQL server 2012.
Any help will be greatly appreciated.
Don't you have a shortcut in the start menu? You can right click that and view properties to see where it is pointed to. The default location is something like this.
"C:\Program Files (x86)\Microsoft SQL Server\110\Tools\Binn\ManagementStudio\Ssms.exe"
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 6, 2017 at 12:56 pm
Why do you want to use one specific version? Both can connect to any version.
If possible, you should remove those SSMS versions and install SSMS 16.5 which is the latest stable release. https://msdn.microsoft.com/en-us/library/mt238290.aspx
January 6, 2017 at 1:46 pm
if you have older versions of Integration services still running, such as 2008 or 2008 R2, SSMS 2016 cannot connect to those:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply