When the SQL script executes, it simply changes databases twice, assuming the AdventureWorks and AdventureWorksDW databases are on your server. If you execute a production installation script, the ...

When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.