Friday, March 23, 2012

How to Run Script in SQL 2000 EM

I'm sure this is a simple problem, but my experience is limited.
I have script to create a large table.
I'm told that I should open Enterprise Manager and Run the Script, and it will create the table.
How do I run the script? :o
Thank you.Sounds like a miscommunication, actually. Query Analyzer is the tool fo choice for scripts. You should be able to access QA from Enterprise Mangler via the tools menu, or one of the buttons on the tool bars. Been a while since I looked for those, though.|||Your advise proved to be correct.
Enterprise Manager/Tools/Query Analyzer
Paste the script, Press F5

No comments:

Post a Comment