Creating tables as DBO

[Erics44]

Hi
I have a VB .net front end and an action on it that runs a stored procedure that creates a table in my SQL server. When a user runs the stored procedure the table is created and named with the users user ID as a part of the table name so something like

UserID.tblTable

Does anyone know how I prevent this from happening? I would just like the table to be called tblTable.
Thanks for your time

 

[bborissov]

CREATE Table dbo.TableName (....)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.

 

[Erics44]

as simple as that

brilliant thanks

 

[SQLDenis]

The user has to have database owner privileges for tis to happen

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/