Yes, You can have the same table name under different owners. Default owner in SQL is dbo. But you could make the owner be the user.
User1 = user1.client User2 = user2.client When querying the user client table you must use a fully qualified table name that includes the owner. Mark Potter -----Original Message----- From: Unmoderated discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] Behalf Of Bruno N Sent: Sunday, February 27, 2005 11:20 PM To: [email protected] Subject: [ADVANCED-DOTNET] ASP.NET + SQL Hi guys I building a hosting web service in ASP.NET, every user can have its own tables. Is it possible to configure SQL Server to allow every client to have its own tables, like, two users having the Client table. dont know if i made myself clear. Thanks in advance Bruno N =================================== This list is hosted by DevelopMentor� http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor� http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
