Posted by Simon Hayes on 09/28/05 16:00

If it works correctly from Query Analyzer, then the problem is most
likely Enterprise Manager, but you don't say exactly what happens - is
there an error message? If you haven't applied the latest MSSQL
servicepack (SP4) to your client, then that would be worth a go - if
that doesn't help, then you could try uninstalling and reinstalling the
client tools completely.

Even if you fix the problem, I would continue to work with QA for this
purpose, because then you can save your admin scripts, put them in
source control, run them against multiple servers and databases etc. EM
is certainly useful, but QA is preferable for many tasks:

http://www.aspfaq.com/show.asp?id=2455

Simon

[Back to original message]