1. Is the tempdb in teh SQL server (2005) is a global database that is shared among other user defined databases?
2. Is is possible to create User defined temp databases like tempdb and how?
i have create a temp table
create table #usr_with_rls
(idx int primary key,
l_name nvarchar(50), desig nvarchar(50))
and it was created in the tempdb database. but the sp that creates the this table is in another database, therefore
3. How do i create this temp table "urs_with_rls" in my datbase and not in the tempdb?
4. I need to remove this temp datanase "urs_with_rls" from the server, onces teh sp completes it execution, how do i do that?
View Complete Post