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

• ritter_bruce

  SSC Enthusiast

  Points: 185

  More actions

  January 18, 2013 at 4:05 pm

  #147813

  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?

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  January 18, 2013 at 4:54 pm

  #1578908

  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[/url]
  Before posting a performance problem please read[/url]