Records are not visible
-
I have a query which inserts data from one database to another. The two tables are identical. The problem is that when viewed through enterprise manager, you can see all the records(200 of them). However, when doing a select * in query analyser, it shows the results as 0. Has anyone ever come across this? If so, please let me know whats happening here. If you restart sql, you can then see the records in query analyser.
-
I have a query which inserts data from one database to another. The two tables are identical. The problem is that when viewed through enterprise manager, you can see all the records(200 of them). However, when doing a select * in query analyser, it shows the results as 0. Has anyone ever come across this? If so, please let me know whats happening here. If you restart sql, you can then see the records in query analyser.
Sometimes in SQL 2000 you can end up with two tables that are named the same, but have different owners. So when you view in Enterprise Manager, you may be viewing the table owned by dbo, but when logged into query analyzer, you may be viewing the table owned by joeblow.