Execute SQL file in Enterprise Manager?
-
Firstly, i'm very new to Sql Server 2000. I'm just wondering why there isn't an option in the Enterprise Manager for selecting a database and executing SQL from a file on it. I've been using the osql command in the command prompt to perform my sql functions (create table, drop, alter, etc..) but i need to modify each one by specifying the (USE myDB) and then GO. Do i need to go through DTS and all that package stuff or is there an easier way? I havn't touched the Query Analyzer yet.
-
Firstly, i'm very new to Sql Server 2000. I'm just wondering why there isn't an option in the Enterprise Manager for selecting a database and executing SQL from a file on it. I've been using the osql command in the command prompt to perform my sql functions (create table, drop, alter, etc..) but i need to modify each one by specifying the (USE myDB) and then GO. Do i need to go through DTS and all that package stuff or is there an easier way? I havn't touched the Query Analyzer yet.