April 28, 2011 at 10:53 am
Is there a way to edit more than 200 records in the grid in Studio Manager?
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD
April 28, 2011 at 11:00 am
You can change that value under Tools --> Options --> SQL Server Object Explorer
Then change the value of Value for Edit Top <n> Rows Command to whatever value you'd like.
However, I'd suggest that if you want to change large numbers of records you'd be better served using UPDATE statements. It is faster and you're less likely to get wrong results through typoes.
--------------------------------------
When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
--------------------------------------
It’s unpleasantly like being drunk.
What’s so unpleasant about being drunk?
You ask a glass of water. -- Douglas Adams
April 28, 2011 at 11:11 am
You can right-click the grid and choose Pane > SQL and edit the query manually as needed. There is also a button to open the SQL Pane on the "Query Designer" toolbar.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
April 28, 2011 at 9:46 pm
Thank you that worked great!
Warm Regards,
Arthur Lorenzini
Sioux Falls, SD
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply