Ensure that you have connected to the SQL server, via Enterprise Manager,
using the same login ID and password you did when using query analyser.
For example, you may have connected to the SQL server via EM using say, a
generic NT account. When using Query analyser, you may have connected using
sa, or the datbase/table owners.
The queries then, depending on what they are, will vary, as the logins have
Anyway, ensure you are using the Query Analyser account for both
>Hello everyone..I have problems to query data with SQL Enterprise
>Manager, but it has a "Unknown Error", and I can't access the data in
>the tables of the SQL database....But if I use the SQL Query Analyzer,
>I can access the data with the same query commands that I use with the
>SQL Enterprise MAnager...Someone can help me?
>PS: excuse my english, I'm learning it yet :-)
>Sent via Deja.com http://www.deja.com/
>Before you buy.