To overcome this we can use commands in the command prompt to run the scripts instead. Below Is an exmaple of such a script:
osql -S <SQL Server IP/Name> -d <DB Name> -E -i <sql script file path>
-S ServerName Such as localhost
-d database if you are creating database by script then no need to use this
-U userid you can define when database is defined in above script
-P password
-E trusted connection
No comments:
Post a Comment