ncomper
asked on
running SQL script in Studio Manager SQL 2005
Hi All
I have been handed a .sql file and told to run it against a specific Database, as im not a DBA i need to know how i run this,
From googling i have worked out if i go into studio manager and click on my database then click New Query i get the blanc page where i need to trye the query
If my file is on the root of C and is called Clear_SQL.sql , the database is QAonline could someone please let me know how i run this.
Thanks
I have been handed a .sql file and told to run it against a specific Database, as im not a DBA i need to know how i run this,
From googling i have worked out if i go into studio manager and click on my database then click New Query i get the blanc page where i need to trye the query
If my file is on the root of C and is called Clear_SQL.sql , the database is QAonline could someone please let me know how i run this.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Or
Dont cleck on New Query
Open existing Query in that open the sql file that you have given