Creating DB tables w/ ASP dynamically...?

<i><b>Originally posted by : Blake Patterson (blake@blakespot.com)</b></i><br /><br /> I cannot seem to find any example code demonstrating the dynamic creation of a table on a db (MS SQL server). Is this technically possible? I tried to use:<br /><br />Set conn = Server.CreateObject("ADODB.Connection")<br />connection.open "testdb", "testAdmin", "password"<br />Set records = connection.execute("create table btable1 (colone int primary key, coltwo int)")<br /><br /> ...and I cannot see the table in the table view under the proper DB using SQL Server Enterprise Manager on the DB server, but when I goto the Users section of the DB, and click 'Permissions', the table IS listed there, so I try to grant "SELECT" permission to a user, for instance, and I get this error:<br /><br />Error 21776 [SQL-DMO] The name 'TestAdmin.btable1' was not found in the Tables collection. If the name is a qualified name use [] to separate various parts of the name, and try again.<br /><br /> ...odd. As I SEE if there under the Permissions section with a table icon. What gives?? Thanks.<br /><br />blake@blakespot.com<br /><br />