Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-26 : 11:15:18
|
| J. writes "I am trying to quickly view some result sets from some quick select statements to compare data from several tables in Enterprise Manager (sql v. 7) for validation. The problem is, while I'm still looking at the data in the various tables on the console (open the table and perform a quick select statement), I get an annoying message that warns it is going to clear my tables. (While I have typed up to this point, I have gotten three messages, from each of the tables and expect another any second). I don't want to go into query analyzer, etc. etc. Because I am only comparing about 25 records from each set, and it's only to check if the data sent to the table has been calculated in my Cold Fusion app correctly or the conversion between several legacy systems was converted properly. (ah, there's another message) I reviewed Books Online, the forum, etc. etc. and the closest thing I found is something that tells me to go into the configuration files themselves. I wasn't even sure if that was addressing the problem. The small dataset of each of the tables is a small sample (oh, there's another warning message) to a bigger query with thousands of record that I am about to perform. But this annoying problem won't hardly give (ah, there's another...oh, and another -- oh, it cleared my data set, now I have to re-run the query) me a chance to review the data. See how annoying it is???? Isn't there some simple setting that can be changed? Laugh if you want, if it's been asked and answered, but take comfort in the knowledge that you have rescued someone from the happily padded cell." |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-08-26 : 11:58:55
|
| EM is not designed as an editing tool.You could use MSAccess with linked tables to open and edit records. |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-08-26 : 12:00:56
|
| J,It sounds like others have given you this advice already, but to reinforce it - EM is not a data browsing or retrieval tool. You should use Query Analyzer for this task. It might be a little more work to write the queries you want but you will be better off.BTW, you shouldn't be eyeball-comparing data anyway - you should write queries that perform the appropriate joins and comparisons to validate the data in a bullet-proof way.Jonathan Boott, MCDBA{0} |
|
|
|
spider_woman3000
Starting Member
1 Post |
Posted - 2002-08-27 : 13:10:22
|
| My primary application I am building is web-based and is in Cold Fusion. I am converting tables from several other RDBMS (an accounting system, FileMaker Pro, Access) and using the data to create new tables out in SQL server -- some of the fields are calculated fields during the conversion process and all I want to know is -- is there any way to increase the time out period for the tables so they will not clear before I have had a chance to look at the calculated and converted fields. I am doing rapid prototyping and using EM to make sure the calculations and conversions are correct in the tables (on a sampling of about 55k records) before moving on to the next step in the Cold Fusion app. I am not using EM for editing, developing, or as a primary retrieval tool -- only to look at the tables created against the source tables to make sure my conversion/calculation process in CF is correct? |
|
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
|
|
Tables clear too quickly