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.