Question

Does anyone know why:
i have an application running and it depends on my sql
databases
when i execute a query in QA, it runs smoothly with no
problems.
when i execute the same query using sql data tools
(enterprise manager -> open database -> choose table right
click and choose query -> execute query there) it causes
locks with the queries executed by the application...
any ideas?EM uses cursors and stuff in order to present the result in the grid. EM was
never designed to be an end-user data entry tool. I suggest you do your
query test in QA and let the users modify the data using your application.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Claudy" <anonymous@.discussions.microsoft.com> wrote in message
news:507001c3ffa5$55611ba0$a101280a@.phx.gbl...
> Does anyone know why:
> i have an application running and it depends on my sql
> databases
> when i execute a query in QA, it runs smoothly with no
> problems.
> when i execute the same query using sql data tools
> (enterprise manager -> open database -> choose table right
> click and choose query -> execute query there) it causes
> locks with the queries executed by the application...
> any ideas?