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.
| Author |
Topic |
|
Shelly
Starting Member
1 Post |
 Posted - 2010-01-11 : 02:51:08
|
| Do i have some possibility to create a temp table that :1. Can be used in many connetions of this user. In first window of application i'm created a table and in second window i wont to see it.2. Visible for one user only. The user that created it. # temp table i can't use in many connections. In the second window the SQL do not know that table.## temp table see all users. In the second window i see all data in the table. Not only my data.Using the user number or something like this is not so good. May be sql 2008 have more possibilitys? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-11 : 09:35:09
|
| i think what you need to store user detail also on ##table and then retrieve details based on logged in user. |
 |
|
|
|
|
|
temp table for single user but many connections