5 events
when toggle format what by license comment
Oct 28, 2016 at 5:48 vote accept mayur rathi
Oct 25, 2016 at 12:33 comment added Daniel Hutmacher It's the dynamic SQL that makes it work, because it changes the security context. :)
Oct 25, 2016 at 12:32 comment added mayur rathi Btw this solution does work.. but can we implement it without dynamic SQL..
Oct 25, 2016 at 12:26 comment added mayur rathi Actually I'm not duplicating the entire schema.. I'm just keeping the user specific 4-5 tables which has most of the data for all the users.. and does not have anything to do with other users.. that makes each query to handle limited amount of data rather than having to go through all the data to from all other users. Common set of tables will still be in dbo schema
Oct 25, 2016 at 12:16 history answered Daniel Hutmacher CC BY-SA 3.0