>I've the need to create a TempTable in SQL server, if that TempTable doesn't exist yet.
>
>I can create it with:
>SQLEXEC(lnActiveConnection,"create table #TempQuery ID char(36) PRIMARY KEY)")
>
>but I can't verify its existence neither with:
>SQLEXEC(lnActiveConnection,"EXEC sp_tables @table_name = '#TempQuery';")
>(the statement return 0 records) nor with:
>SQLEXEC(lnActiveConnection,"EXEC sp_tables @table_name = '#TempQuery', @table_owner = 'dbo', @table_qualifier = 'tempdb';")
>(this statement return -1).
>
>How to get the information?
>TIA
>Bruno Maddalozzo
Quick google search brought this
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67736I haven't tested it yet.
If it's not broken, fix it until it is.
My Blog