Hi,
I'm looking for a solution to run querys (create databases ed) after a silent installation of SQL 2005 Express edition (example with a .sql file). So users can run a installation unattended with all databases installed and so on.
What I got is a document about how to run a silent installation (document " Using Command Prompt Options to install SQL Server Express") but this docs there's no solution how to run querys after the installation.
Thanks
Robert-Paul
I think you want to use sqlcmd.exe after installation. This really isn't a setup issue. You will probably get a better answer in either the Tools or DB Engine forums.|||Moving this post to the new SQL Express forum. Hope they can answer your question.
-Jeffrey
|||Hi Robert- Paul,
You should use SQLCmd to run .sql scripts after a silent installation. You can find more information about SQLCmd in Books Online, which you can either download or find online at http://msdn2.microsoft.com. In general, you can call SQLCmd the same way you'd call any command line tool with a command line something like this:
SQLCmd -E -S <machinename>\SQLEXPRESS -i C:\myscript.sql
Regards,
Mike Wachal - SQL Express team
