Help with ##table

Hi,

I am trying to drop a global temp table (##table) with sa rights and I get no joy. Does anyone have an idea what this could be caused by. The table is used by a sp which checks if the table is there and it drops it if its there.

Tnx for help.

Hi Kudah

Just tested creating,selecting from and dropping a global temp tabl;e with no issues. Your best bet is to post the code of the SP if possible and if not the ## table creation script and any supporting error messages.

Cheers

Charl

|||

Are you getting an error message? Can you post part of the code?
Normally this shouldn't be an issue.

|||create table ##a(name varchar(90))
select * from tempdb.##aa
if (select count(*) from tempdb..sysobjects where name='##a' ) > 0
print 'table is available'
else
print 'table dropped'
The above should give you proper results
-srikanthr
|||Quite possible that another user might be accessing the ##table since it is a global temporary table.

Help with ##table

Hi,

I am trying to drop a global temp table (##table) with sa rights and I get no joy. Does anyone have an idea what this could be caused by. The table is used by a sp which checks if the table is there and it drops it if its there.

Tnx for help.

Hi Kudah

Just tested creating,selecting from and dropping a global temp tabl;e with no issues. Your best bet is to post the code of the SP if possible and if not the ## table creation script and any supporting error messages.

Cheers

Charl

|||

Are you getting an error message? Can you post part of the code?
Normally this shouldn't be an issue.

|||create table ##a(name varchar(90))
select * from tempdb.##aa
if (select count(*) from tempdb..sysobjects where name='##a' ) > 0
print 'table is available'
else
print 'table dropped'
The above should give you proper results
-srikanthr
|||Quite possible that another user might be accessing the ##table since it is a global temporary table.

Help required for database design

I have to make a e commerce web site likewww.handango.com. I am not getting any idea about it's database design. Can anyone help me in database design for site like handango.com.

Ecommerce is very complex so I think you should start with the commerce starter kit ERD which you can create by just installing the starter kit. Try the link below to download the kit. The reason is you can change tables to meet your needs and sometimes add new tables. Hope this helps.

http://www.commercestarterkit.org/