SEO

#1 (**permalink**) 04-08-2008, 06:17 PM

I tried renaming a temporary table so that i can access it in other
session.

Session 1:
Session 2:
Use tempdb;
create table #mytable ( col int);
sp_rename #mytable, XYZ
select * from XYZ // Works fine
select * from XYZ // Works fine

select * from #mytable //the SQL connection terminates
And i got the stack trace.

Is it proper to rename the #temp tables. Is my approach correct.

If yes, that means I have hit a bug in Sybase..

Any comments.

#2 (**permalink**) 04-08-2008, 06:17 PM

Session 1:
create table #mytable ( col int);
sp_rename #mytable, XYZ
select * from XYZ // Works fine

Session 2:
Use tempdb;
select * from XYZ // Works fine

Session 1:
select * from #mytable //the SQL connection terminates
And i got the stack trace.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Renaming temporary tables terminated connection.