SQL SERVER Management Studio 2008 can't list all tables under SQL2005 database

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL SERVER Management Studio 2008 can't list...

34 posts, Page 4 of 4

«««1 2 3 4

SQL SERVER Management Studio 2008 can't list all tables under SQL2005 database

Rate Topic

Display Mode

Topic Options

Author

Message

Shawn Melton

Posted Saturday, May 29, 2010 11:08 PM

Right there with Babe

Group: General Forum Members
Last Login: Monday, February 13, 2012 8:23 AM
Points: 749, Visits: 1,804

Bug got reported to Microsoft back in December 2008, although Microsoft did not post a response until April 2009.
https://connect.microsoft.com/SQLServer/feedback/details/387616/tables-node-does-not-show-all-schemas-in-ssmse-2008

It states the INNER JOIN is the issue, as Peter and Paul ( w00t

and Mary, now how many times do you see this come up Smile

). MS goes on to state it will be fixed in SQL 11. So would that not be SQL Server 2008 R2 BigGrin

. Anyone have SSMS 2008 R2 loaded that could test this, or have tested it?
Hehe

, just need one more to make it even.

--------------------------------------------------------------
Shawn Melton
@MeltonDBA

Post #930106

SQL Kiwi

Posted Saturday, May 29, 2010 11:39 PM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:48 PM
Points: 10,136, Visits: 8,865

MeltonDBA (5/29/2010)

Excellent find! I voted it up. There's a partial workaround there too which is good.

It states the INNER JOIN is the issue, as Peter and Paul ( w00t

and Mary, now how many times do you see this come up Smile

Hmmm...we could do with a Mary on the forums, it's true Laugh

Showing your age a bit there Melton? Tongue

MS goes on to state it will be fixed in SQL 11. So would that not be SQL Server 2008 R2 BigGrin

Nope, R2 is not a major release - it's version 10.5 (Kilimanjaro)
SQL11 is code named Denali - and that's where I would expect this to be fixed.

Paul White

SQLblog.com/blogs/Paul_White
@SQL_Kiwi

Post #930110

Henry_Lee

Posted Monday, June 07, 2010 10:18 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, February 20, 2012 10:15 AM
Points: 254, Visits: 1,004

Good day all,

I know I'm late to this party, but I just want to thank every one who contributed to this thread. I've been battling this behavior for weeks, convinced I was missing something simple...

Henry Lee

Post #933588

Eddy White

Posted Tuesday, February 15, 2011 1:27 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 03, 2012 2:44 PM
Points: 5, Visits: 104

We have been dealing with this very issue.
I find it quite interesting that SSMS 2005 and 2008 version are not checking for the SQL Server version that is being connected to. I have also confirmed that SSMS is sending different SQL code to the database server at connection time. We do use GRANT VIEW DEFINITION for our DEV, TEST and (yes) some Production databases. We STILL have the problem of the SSMS v 2008 not showing what a person can view, when SSMS 2005 can. STUPID!!!

So, my 2 questions are:
We have encountered this with SSMS 2008 Express editions. Is this unique to the version of SSMS 2008?
Have we been able to differentiate the SSMS 2008 (a.k.a full client install as provided with SQL Server 2008) vs SSMS 2008 Express Edition?

If this issue the query being run by SSMS 2008 that it is sending to SQL Server 2005. WE, the SQL Server community, have a serious issue with the use of SSMS 2008 in an enterprise where SQL Server 2005 is still in use and in my opinion, I believe this is a backward-compatibility issue and MS needs to address this asap!

Eddy White, DBA

Post #1064537

« Prev Topic | Next Topic »

34 posts, Page 4 of 4

«««1 2 3 4

Permissions