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.

 All Forums
 Other Forums
 Other Topics
 Bind the login ID to one specific table

Author  Topic 

dasu
Posting Yak Master

104 Posts

Posted - 2006-02-25 : 09:20:03
Hi Guys,
My Sybase server has 3 temp databases(tempdb,tempdb1,tempdb2).
as part of application we are creating temp tables(#temp) which are stored in tempdb,tempdb1 and tempdb2 databases dynamically.is there any way to bind all temp tables of one particular user to one specific DB?.If possible send me the procedure to do that.
Pleaes send me the apropriate URLS for above problem.

THANKS IN ADVANCE.
THANKS
Dasu.G

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-02-25 : 09:24:12
This is a MS SQL Server forumn. Try posting your question in dbforums.com

----------------------------------
'KH'

It is inevitable
Go to Top of Page
   

- Advertisement -