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.
| Author |
Topic |
|
pvong
Yak Posting Veteran
58 Posts |
 Posted - 2015-02-19 : 15:45:24
|
I'm new and I'm just learning about Temp Tables. I was going to try my first Temp table and I noticed I already have a bunch of temp tables? I'm the only developer of this DB and I have never created a temp table before.Can someone tell me why this happened and how I get rid of them? I have no idea what kind of connections are creating and using these temp tables. I do us SSRS and SSIS everyday. Would either of these create temp tables? And why wouldn't it get rid of it. ------------------------------Using VS2010 / Learning in VB.Net / Win2008 R2 / SQL 2008 R2Be kind to the newbies because you were once there. |
|
|
pvong
Yak Posting Veteran
58 Posts |
Posted - 2015-02-20 : 13:14:01
|
| I stopped the DB last night and restarted it and the tables are gone but it's beginning to auto generate again. I can not find anything about SQL creating temp tables on it's own.------------------------------Using VS2010 / Learning in VB.Net / Win2008 R2 / SQL 2008 R2Be kind to the newbies because you were once there. |
 |
|
|
jcb267
Constraint Violating Yak Guru
291 Posts |
Posted - 2015-02-20 : 13:26:50
|
I use the drop table command frequently:USE [YOUR DB]DROP TABLE [YOUR TABLE] (eg #A01D6C9C)I am not sure why they keep generating. No one is creating them? |
|
|
|
|
|
|
SQL Temp Tables