I'm usually writing most queries in MSSMS since I find it a lot easier.
I've recently encountered an odd situation where data is being overwritten between databases if SQL query report is using the "USE" command, below is an example of my setup :
Production Env . example db name is : CompanyDb
Test Env (old dated replica of the CompanyDb) :TestCompanyDb
What Happen to me was I was creating a query on the CompanyDb ,
but when I started writing the query I used the "Use CompanyDb", and then I queried my data.
I proceeded to my test SBO company against TestCompanyDb and pasted the query .
What followed is that I started receiving "Database Structure Changed" messages from SBO .
and I could see that some of my data was overwritten (eg. UF , Menus etc etc.)
I'm trying to pay close attention ever since not to use USE command on SQL report UF , but this caused a lot of "damage" and I'm afraid that if my test Database was even older I wouldn't have been able to easliy fix this.
Any input from BOYUM regarding this / if you can confirm / replicate this scenario is much appreciated, perhaps it's a bug , or maybe I was doing something awfully wrong.
Thank you ,
Please sign in to leave a comment.