dbTalk Databases Forums  

mismatch version between db engine and ssms in sql server 2005

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss mismatch version between db engine and ssms in sql server 2005 in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
Luca Carraro \(FiloDiArianna.it\)
 
Posts: n/a

Default Re: mismatch version between db engine and ssms in sql server 2005 - 10-25-2008 , 02:16 PM






Thank you Erland, this is exactly what I wanted to know.

L.
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> ha scritto nel messaggio
news:Xns9B42C653D7F7CYazorman (AT) 127 (DOT) 0.0.1...
Quote:
Luca Carraro(FiloDiArianna.it) (REMTOMAILluca (AT) lalberodargento (DOT) it) writes:
First of all, thank you for your reply, Aaron.

So - just in case file version from the OS is not reliable - how can I
discover if my client tools are updated?

You can check the file directly, in this case
90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe in the installation directory
for SQL Server.

On my machine, SSMS says 3042, but the file version is 3073, as I have
applied a security update.

I know for a fact that SSMS in CU9 is not the same as in SP2, as CU5
added the capability for SSMS 2005 to connect to SQL 2008.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #32  
Old   
Luca Carraro \(FiloDiArianna.it\)
 
Posts: n/a

Default Re: mismatch version between db engine and ssms in sql server 2005 - 10-25-2008 , 02:16 PM






Thank you Erland, this is exactly what I wanted to know.

L.
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> ha scritto nel messaggio
news:Xns9B42C653D7F7CYazorman (AT) 127 (DOT) 0.0.1...
Quote:
Luca Carraro(FiloDiArianna.it) (REMTOMAILluca (AT) lalberodargento (DOT) it) writes:
First of all, thank you for your reply, Aaron.

So - just in case file version from the OS is not reliable - how can I
discover if my client tools are updated?

You can check the file directly, in this case
90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe in the installation directory
for SQL Server.

On my machine, SSMS says 3042, but the file version is 3073, as I have
applied a security update.

I know for a fact that SSMS in CU9 is not the same as in SP2, as CU5
added the capability for SSMS 2005 to connect to SQL 2008.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #33  
Old   
Luca Carraro \(FiloDiArianna.it\)
 
Posts: n/a

Default Re: mismatch version between db engine and ssms in sql server 2005 - 10-25-2008 , 02:16 PM



Thank you Erland, this is exactly what I wanted to know.

L.
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> ha scritto nel messaggio
news:Xns9B42C653D7F7CYazorman (AT) 127 (DOT) 0.0.1...
Quote:
Luca Carraro(FiloDiArianna.it) (REMTOMAILluca (AT) lalberodargento (DOT) it) writes:
First of all, thank you for your reply, Aaron.

So - just in case file version from the OS is not reliable - how can I
discover if my client tools are updated?

You can check the file directly, in this case
90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe in the installation directory
for SQL Server.

On my machine, SSMS says 3042, but the file version is 3073, as I have
applied a security update.

I know for a fact that SSMS in CU9 is not the same as in SP2, as CU5
added the capability for SSMS 2005 to connect to SQL 2008.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #34  
Old   
Luca Carraro \(FiloDiArianna.it\)
 
Posts: n/a

Default Re: mismatch version between db engine and ssms in sql server 2005 - 10-25-2008 , 02:16 PM



Thank you Erland, this is exactly what I wanted to know.

L.
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> ha scritto nel messaggio
news:Xns9B42C653D7F7CYazorman (AT) 127 (DOT) 0.0.1...
Quote:
Luca Carraro(FiloDiArianna.it) (REMTOMAILluca (AT) lalberodargento (DOT) it) writes:
First of all, thank you for your reply, Aaron.

So - just in case file version from the OS is not reliable - how can I
discover if my client tools are updated?

You can check the file directly, in this case
90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe in the installation directory
for SQL Server.

On my machine, SSMS says 3042, but the file version is 3073, as I have
applied a security update.

I know for a fact that SSMS in CU9 is not the same as in SP2, as CU5
added the capability for SSMS 2005 to connect to SQL 2008.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #35  
Old   
Luca Carraro \(FiloDiArianna.it\)
 
Posts: n/a

Default Re: mismatch version between db engine and ssms in sql server 2005 - 10-25-2008 , 02:16 PM



Thank you Erland, this is exactly what I wanted to know.

L.
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> ha scritto nel messaggio
news:Xns9B42C653D7F7CYazorman (AT) 127 (DOT) 0.0.1...
Quote:
Luca Carraro(FiloDiArianna.it) (REMTOMAILluca (AT) lalberodargento (DOT) it) writes:
First of all, thank you for your reply, Aaron.

So - just in case file version from the OS is not reliable - how can I
discover if my client tools are updated?

You can check the file directly, in this case
90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe in the installation directory
for SQL Server.

On my machine, SSMS says 3042, but the file version is 3073, as I have
applied a security update.

I know for a fact that SSMS in CU9 is not the same as in SP2, as CU5
added the capability for SSMS 2005 to connect to SQL 2008.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #36  
Old   
Luca Carraro \(FiloDiArianna.it\)
 
Posts: n/a

Default Re: mismatch version between db engine and ssms in sql server 2005 - 10-25-2008 , 02:16 PM



Thank you Erland, this is exactly what I wanted to know.

L.
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> ha scritto nel messaggio
news:Xns9B42C653D7F7CYazorman (AT) 127 (DOT) 0.0.1...
Quote:
Luca Carraro(FiloDiArianna.it) (REMTOMAILluca (AT) lalberodargento (DOT) it) writes:
First of all, thank you for your reply, Aaron.

So - just in case file version from the OS is not reliable - how can I
discover if my client tools are updated?

You can check the file directly, in this case
90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe in the installation directory
for SQL Server.

On my machine, SSMS says 3042, but the file version is 3073, as I have
applied a security update.

I know for a fact that SSMS in CU9 is not the same as in SP2, as CU5
added the capability for SSMS 2005 to connect to SQL 2008.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #37  
Old   
Luca Carraro \(FiloDiArianna.it\)
 
Posts: n/a

Default Re: mismatch version between db engine and ssms in sql server 2005 - 10-25-2008 , 02:16 PM



Thank you Erland, this is exactly what I wanted to know.

L.
"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> ha scritto nel messaggio
news:Xns9B42C653D7F7CYazorman (AT) 127 (DOT) 0.0.1...
Quote:
Luca Carraro(FiloDiArianna.it) (REMTOMAILluca (AT) lalberodargento (DOT) it) writes:
First of all, thank you for your reply, Aaron.

So - just in case file version from the OS is not reliable - how can I
discover if my client tools are updated?

You can check the file directly, in this case
90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe in the installation directory
for SQL Server.

On my machine, SSMS says 3042, but the file version is 3073, as I have
applied a security update.

I know for a fact that SSMS in CU9 is not the same as in SP2, as CU5
added the capability for SSMS 2005 to connect to SQL 2008.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.