Steve,

despite what John said...

lnConn = SQLSTRINGCONNECT( "driver={SQL Server};server=(local);trusted_connection=yes;" )
sqlexec( lnConn, "create database test" )
sqlexec( lnConn, "use test" )
sqlexec( lnConn, "create table test1 ( i1 int )" )
sqlexec( lnConn, "insert into test1 values ( 1 )" )
sqlexec( lnConn, "select * from test1" )

works fine and dandy for me. You do need to have sufficient rights on the server to create databases and tables though.

>How can I use VFP 6.0 to create a database and add tables to SQL Server?