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 |
|
greenmtnsun
Starting Member
13 Posts |
 Posted - 2006-08-29 : 16:17:07
|
| I'm wondering if we can get a definitive word on the post below:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=578917&SiteID=1Its a real problem with no solution available. So far I can't find a work around and concur with the final analysis of the post. I've posted this over on the MSDN forums and no one replied.<A quick summary>In SQL 2000 Enterprise Manager, one was able to edit and commit data on-the-fly directly from the results pane. Action->Open Table->Query with the SQL Pane shown gives you an interface similar to Query Analyzer. One could write a complex select statement with where clauses and joins, and the results pane would show the resulting data.The question is this: How do you edit data in the results grid in SQL 2005 Management Studio as you would in SQL 2000 Enterprise Manager when you Open Table via Query (Action->Open Table->Query), and what option/configuration setting or panel would you need to enable/show to make this a permanent feature? In other words, what is the equivalent of Action->Open Table->Query in Management Studio?I also found this link that makes me wonder if its a setting: (search for "open table")http://msdn.microsoft.com/SQL/community/webcasts/ManagementStudioQandA.aspx<conclusion>So far it seems it can't be done. Like they removed the feature in favor of application developers creating apps to take care of this for you, which is greatly hampering our environment.Any word? Are there free alternatives out there for my user, who can't afford to pay much money for a third party tool? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-29 : 16:20:54
|
| Free alternative is to use T-SQL to view and update data. Why do you need a GUI tool to do it?Tara Kizer |
 |
|
|
greenmtnsun
Starting Member
13 Posts |
Posted - 2006-08-29 : 16:28:23
|
| I showed the user ways to write the queries in SQL and found the user feels SQL/TSQL is too slow to write, prefers visual tool that can "quickly" update data without any hassles. She wants to be able to field a call from someone and change data fast and on the fly. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-29 : 16:37:18
|
| Have you installed SQL Server 2005 service pack 1 on the PC? Service packs need to be applied to both the database server and to the PCs that have the client tools installed.Tara Kizer |
|
|
|
greenmtnsun
Starting Member
13 Posts |
Posted - 2006-08-29 : 16:52:06
|
| I wouldn't have been the one to do that. How would I tell? I posted stuff from both client and server to see if I could answer yoru question.SERVER:Microsoft SQL Server Management Studio 9.00.2047.00Microsoft Analysis Services Client Tools 2005.090.2047.00Microsoft Data Access Components (MDAC) 2000.086.1830.00 (srv03_sp1_rtm.050324-1447)Microsoft MSXML 2.6 3.0 4.0 6.0Microsoft Internet Explorer 6.0.3790.1830Microsoft .NET Framework 2.0.50727.42Operating System 5.2.3790CLIENT:Microsoft SQL Server Management Studio Express 9.00.2047.00Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer 6.0.2900.2180Microsoft .NET Framework 2.0.50727.42Operating System 5.1.2600Also, do you know of a specific fix in SP1 in this regard, or are you wondering if it is fixed? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-29 : 17:02:24
|
| I'm just wondering. I use T-SQL for all of my data access. I'm not sure how to tell if the client tools have been updated on the client machine. I only know how to check the database engine. I'm going to go out on a limb here though and say that the client hasn't been updated with SP1 as most people don't do this or don't know about this.Tara Kizer |
|
|
|
greenmtnsun
Starting Member
13 Posts |
Posted - 2006-08-29 : 17:20:23
|
| Oopps. I guess we had our answer above. (Although I just reloaded SP1 on my machine. No Luck.) My Server is on SP1 and so is my client.So... Back to square one. Do you or anyone else know anything about this issue? |
|
|
|
|
|
|
Open Table not editable, anyone know a workaround?