I need help from our Genius DBA's!
Can i login another user when i was actually using SA account? is it possible in query?
I was thinking like this:
as I was logged on as SA and I created a table named dbo.Product, then I created a new user named User1 with the same access as I do, then I will shift to that user and create a table named User1.Product. There I have created table with the same name with different schema. But what I'm trying to reach is when every time I add a new record in Product table only the logged on user will add record to which I have created table.
Logged on user: User1, added new record in Product table values 'U-Prod1', and 'U-Prod1'
then user: SA, added new record in Product table values 'SA-Prod1', and 'SA-Prod1'
when User1 add record it will basically saved to User.Product table and SA will be saved in dbo.Product table, so right there I could get my own clustered tables based on the logged on member, only that I could only create table maximum to SQL's table limit. but wont be a problem.
I just want to know how will I be able to do that query.
ToM™ (Possibility will come out of nothing)