Random legacy question about query analyzer changing text in sp...

[jsteph]

Hi all,
Sorry in advance for an out of the blue question on a near obsolete sql-2000 query analyzer, but I'm going absolutely crazy.

I started to use our old sql-2000 server for some offline data crunching. So I had made some changes to a sp in query analyzer, executed it to test the changes.

Then about a half hour later I came back to the window and the changes were GONE!!! Yes, they still existed in the actual sp if I re-opened it in another window, However if I were to make one more tiny change in the original window where I first made the chagne and execute it--it would undo my previous changes.

This happened several times yesterday and nobody was near my machine or anything like that. I'm not making this up--the changes I typed in were gone completely. I did not accidentally hit ctrl z or anything like that. I don't wear tin-foil hats either, this really happened.

Does anyone recall any such issues with the sql-2000 query analyzer?
--Jim

 

[jsteph]

Ok...red-faced me sees that, while I may not be wearing tin-foil...I did have two instances of query analizer open and didn't notice the other one in the taskbar...must've clicked on the one I had opened previously...
Never mind...
--Jim

 

[Crowley16]

reminds me of a time when I first started using sql server, I was running a simple 1 line select statement, but it was returning 2 result sets...

puzzled over it a while, and asked a college if he could see why. After looking for 10 secs, he scrolls the window up a line...

doh...

--------------------
Procrastinate Now!