Creating SQL Database Programmatically

  • Thread starter Thread starter Ian Semmel
  • Start date Start date
I

Ian Semmel

I can create a database by executing sql commands from files and create the
database and tables ok, but after I have closed the connection, I cannoy access
the database with anything - VS, SQL Server Management Studio etc without
rebooting the computer. It says it 'is in use by another program.

Is there some step that I am missing out on ?
 
Perhaps it's something to do with the 'user instance' property of the connection
string ?

Not that I really know the ramifications of this.
 
hmm, it seems that the entire server was shutdown since only a reboot
helps where the sql services start by system startup.
Are you refering to "closed the connection" by YourConnection.Close()?
 
Back
Top