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 - 2005-04-29 : 07:31:36
|
| chetan writes "when i try to make a change in a table field, using Enterprise manager it shows 'Transaction cannot be performed in 'FireHose Mode'....What shall I do to to sort out this problem" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-04-29 : 07:31:58
|
| Don't use Enterprise Manager to made data modifications. Use Query Analyzer instead. |
 |
|
|
KLang23
Posting Yak Master
115 Posts |
Posted - 2005-04-29 : 16:28:19
|
| Of course you can use EM to make data changes. Bad idea in Production, where everything should be scripted, but in a Development environment on in your own sandbox, it is perfectly OK."Firehose" mode indicates that EM has not fetched all rows. It goes a bit deeper than that, but in order to change data in EM when a large result set is returned, right-click on the very left side of the data-entry pane (grid) and select "Last". That will get you to then end of the dataset, and once you reposition yourself back to the desired row, you may make changes. If the result set is very large, you could be waiting a while, consuming lots of resources, and causing grief for other users. I think that is why the recommendation use use QA was presented.You can also click on the "SQL" button to narrow-down the result set by specifying a predicate ("where") clause. |
|
|
|
|
|
|
firehose mode