SQL Server 2012 Express Management Studio does not show columns of tables in tempdb

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » General » SQL Server 2012 Express Management Studio...

SQL Server 2012 Express Management Studio does not show columns of tables in tempdb

Rate Topic

Display Mode

Topic Options

Author

Message

ritter_bruce

Posted Friday, January 18, 2013 4:05 PM

Forum 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

bitbucket-25253

Posted Friday, January 18, 2013 4:54 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:12 PM
Points: 5,103, Visits: 20,208

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 »

Permissions