SQA 2000 looking at SQL7 DB - Rows go missing???!!!
-
I open up SQA (2000) connecting with windows authentication looking at a SQL 7 Server.
Put in a number of random (fairly simple)selects to get an example for testing.
Do a number of selects from a table called plan_ which work fine.
Then when doing a JOINed select between the plan_ table and another table I get no rows (I'm expecting something if it is correct). So I try to find the problem and eventually end up doing
select* FROM plan_
and getting no rows.
A) There are definitely rows there - I had them earlier and colleague can see them.
B) I close down that instance of SQA and all others and paste the code in still 0 rows
C) I had the same problem the other day and it cleared itself
D) There have been no BEGIN TRANSACTION lines run nor GO statements in the SQA window.
I think it has got something to do with the SQA 2000 version as it was not happening in the past.
Any ideas on this madness!!!
-
What's SQA? And I have never seen this in working with 2000 querying v7.
Are you sure someone isn't working with this table and removing rows? If someone else can see them, are you sure there are no multiple plan_ tables with different owners?
-
Sorry! SQA is ISQLW.EXE - the "SQL Query Analyser".
100% sure that the records are not being deleted.
3 users and we only need to select for what we are doing.
By the way, it's back to normal now. It does unnerve me though, because it's happened before so it is likely to happen again. It would be nice to clear/reset whatever is causing it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply