SMO Temp Tables

• Alexander-623609

  SSC Enthusiast

  Points: 102

  More actions

  February 22, 2010 at 8:18 am

  #98993

  Hi All,

  I created an application (VB.NET) using SMO. This application acts like SQL Server Analyzer.

  My problem is that I'm trying to use temp table but I'm having no joy.

  When I execute the following:

  select * into #Temp from tblPrinters

  select * from #Temp

  My data is displayed. However, if I then execute

  select * from #Temp

  I get an error that the object does not exists. How do I continue to have access to the temp table until I drop it.

  Thanks

  Alex

• Steve Cullen

  SSCertifiable

  Points: 5598

  More actions

  February 22, 2010 at 8:37 am

  #1122996

  temp tables are designed to be removed automatically when they fall out of scope.

  I suggest you create a non temp table, if you wish to delete it when you are finished.

  Converting oxygen into carbon dioxide, since 1955.

• Alexander-623609

  SSC Enthusiast

  Points: 102

  More actions

  February 22, 2010 at 8:44 am

  #1123006

  But how do I keep in in scope? With DMO, this was not an issue, it worked just like the SQL QA. There mus be a way to keep my temp table until I drop it.

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  February 22, 2010 at 9:41 am

  #1123081

  Alexander-623609 (2/22/2010)

  ---

  But how do I keep in in scope? With DMO, this was not an issue, it worked just like the SQL QA. There mus be a way to keep my temp table until I drop it.

  Show us your VB.net/SMO code, please.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]