Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Temp Tables in SQL Server 2000

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-02 : 10:06:47
Rashmi writes "I am connecting to a SQL server database using VB 6.0 and ADO. My question is, by using ADOX.Catalog object I am able to read all the tables and their properties for a 'normal' database, but unable to do so for tempdb. This is while using the same active connection. My main idea is to check if #tempA exists in tempdb or not, and then create/drop the table. All this I want to accomplish with ADO and VB."
   

- Advertisement -