|
Home > Archive > MS SQL Server > March 2006 > where is the temporary table created by sp_helprotect?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
where is the temporary table created by sp_helprotect?
|
|
|
| Hi,
Looking at the source code of sp_helprotect, I noticed it has
CREATE Table #t1_Prots
If sp_helprotect does not do 'DROP Table #t1_Prots', where is table
#t1_Prots saved? I cannot find it in any database.
Thanks,
Bing
| |
| Jeffrey K. Ericson 2006-03-08, 8:23 pm |
| Temp tables are created in tempDB although I beleive the actuaul object name
my differ. #<tablename> objects are destroyed when the connection is closed.
"bing" wrote:
> Hi,
>
> Looking at the source code of sp_helprotect, I noticed it has
>
> CREATE Table #t1_Prots
>
> If sp_helprotect does not do 'DROP Table #t1_Prots', where is table
> #t1_Prots saved? I cannot find it in any database.
>
> Thanks,
>
> Bing
| |
| Alex Cieszinski 2006-03-09, 7:23 am |
| If temporary table was created in stored procedure code then it will be
automatically destroyed when stored procedure have ended - no need to drop
it manually
"bing" <bing@discussions.microsoft.com> wrote in message
news:AFEB0090-7449-4CF7-B9C4- 046A642A4701@microso
ft.com...
> Hi,
>
> Looking at the source code of sp_helprotect, I noticed it has
>
> CREATE Table #t1_Prots
>
> If sp_helprotect does not do 'DROP Table #t1_Prots', where is table
> #t1_Prots saved? I cannot find it in any database.
>
> Thanks,
>
> Bing
| |
|
| Thanks folks for your responses. I was confused as a newbie because
sp_helplogins creates temp tables as well and at the end it does DROP on
those temp tables. But sp_helprotect does not do DROP.
Bing
"Alex Cieszinski" wrote:
> If temporary table was created in stored procedure code then it will be
> automatically destroyed when stored procedure have ended - no need to drop
> it manually
>
> "bing" <bing@discussions.microsoft.com> wrote in message
> news:AFEB0090-7449-4CF7-B9C4- 046A642A4701@microso
ft.com...
>
>
>
|
|
|
|
|