ASP and creating tables in Microsoft SQL

[Darksbane]

Currently whenever I create a new table in Microsoft SQL Server through my website it sets the owner of the table to the whatever global user is set on the server the ASP code resides on. This is all OK until you try to run the ASP code on a different server (with a different user set). For some reason tables created by anything but the dbo or that user are inaccessable (even after changing the permissions so they should be allowed). Is there a way through a query in ASP to change the owner of a table created? If there is I can just change the owner of every table created to dbo so both servers can access it.

Any help is appreciated,

Darksbane

[whammy]

The owner shouldn't matter... have you set up the DSNs for the database in IIS?

You will then need to make sure that the computer accessing it has that DSN username and password in its ODBC data sources.