Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2012 Express Management Studio does not show columns of tables in tempdb Expand / Collapse
Author
Message
Posted Friday, January 18, 2013 4:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 22, 2013 5:01 PM
Points: 1, Visits: 2
I am trying to diagnose T-sql that writes out temporary tables, but the SQL Server Management Studio returns an error when you attempt to examine the temporary tables - either by listing the contents, or examining the structure:

************** Exception Text **************
Microsoft.SqlServer.Management.Sdk.Sfc.EnumeratorException: Failed to retrieve data for this request. ---> Microsoft.SqlServer.Management.Sdk.Sfc.InvalidQueryExpressionEnumeratorException: urn could not be resolved at level Column.

The same thing happens if you try to look at the Index category, but with Index instead of Column in the error. I am using SQL Server Express 2008, and have tried SQL Server Management Studios 2008a nd 2012.

Anyone have any ideas on how to work around this?

Post #1409130
Posted Friday, January 18, 2013 4:54 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:31 AM
Points: 5,572, Visits: 24,796
Can you post your actual T-SQL might help us help you

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1409134
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse