Only one field description change allowed

Documents SQL Server 2005, 2008, 2012 and Azure databases.

Moderator: JonathanWatts

Only one field description change allowed

Postby krayl » Mon Aug 25, 2014 7:45 pm

I am updating the field descriptions.
In the 3.0 version, I make a change to the text. Then I update a second description. Now there are 2 sets of icons that will either update the text or delete. I select to update the description thinking that this will perform better than the previous version and update all changes in the database. Instead the entire panel showing the table hangs with no other updates allowed until I select a different table and reselect the original table.
I started this in version 2 of SQLDoc where I was able to make multiple updates to the table prior to updating the database with all changes.
This new version makes SQLDoc completely inefficient and unusable.
krayl
 
Posts: 2
Joined: Mon Aug 25, 2014 7:35 pm

Postby Brian Donahue » Thu Aug 28, 2014 3:22 pm

I'm sorry that SQL Doc doesn't seem to be performing well. Updating the description runs a query on the database that updates an extended property on the database that you are documenting. it should be fairly quick, but it sounds like the SQL Server is not processing the query in a timely fashion. Is this behavior evident on all databases and servers, or just one?
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby krayl » Thu Aug 28, 2014 7:13 pm

I don't think I am being very clear.

SQLDOC2 allowed the user to make multiple edits to the table or field descriptions and apply all of the edits at once.

SQLDOC3 [b]only [/b]allows the user to make 1 edit per update and then locks up after the update until selecting another table or object.

This is the case on every instance and database that I have accessed.
krayl
 
Posts: 2
Joined: Mon Aug 25, 2014 7:35 pm

SQL Doc + MSSQL 2014 = hangs out + save only one item

Postby alientresor » Sun Aug 31, 2014 9:08 pm

I've got exactly the same problem, in previous versions I was able to create documentation in 1-2 days.
Now with these problems it is almost impossible to create any docs :(

Hope You will fix it.
alientresor
 
Posts: 1
Joined: Sun Aug 31, 2014 9:03 pm

Postby Brian Donahue » Wed Sep 10, 2014 8:11 am

Can you please clarify "multiple edits"? I do not fully understand what/where you are editing. Is this about editing extended properties directly on the SQL Server?

As SQL Doc is almost completely rewritten for v3 it would not be possible to simply go through SQL Doc's code and compare to see what has changed and solve the problem that way. So from my perspective I have to throw away comments about how it used to work in the previous version and concentrate on what/where the problem is in this version, try to reproduce it, and pass the reproduction on to development so they can do whatever they do.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Mon Sep 15, 2014 9:57 am

In SQL Doc 2, when you edit an extended property (description) on a column, it opened a dialog where you could save the change or cancel. I do not see the ability to edit and save multiple extended properties at one time.

If SQL Doc 3 is "hanging" when attempting to edit the extended property, can we please identify that as the issue as there is more chance of getting that fixed than "rolling back" a UI change that has been determined to make a cleaner, more usable UI.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re: Only one field description change allowed

Postby beenhazed » Mon Sep 22, 2014 8:56 pm

It looks like that whenever a description is entered and saved to the database, the page with the comments locks up, and doesn't allow you to save any other descriptions you have entered, or even scroll the page or work with any other fields on that page. You have to select another object (in the object tree to the left), then reselect the previous object, and make changes to only one object at a time (on the right). It doesn't popup a window for multiple object saving like SQL Doc 2 did.
I should also point out that I am on Windows 8.1, connecting SQL Doc 3 to SQL Server 2012 CU7.
beenhazed
 
Posts: 6
Joined: Tue Dec 30, 2008 10:15 pm

Re: Only one field description change allowed

Postby Brian Donahue » Tue Sep 23, 2014 11:16 am

Is this when you exec sp_addextendedproperty on the database in an SSMS query window to add an MS_Description at the same time SQL Doc's preview window is open? I tried that and it was not exhibiting the same lock-up in my case.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re: Only one field description change allowed

Postby beenhazed » Wed Sep 24, 2014 8:43 pm

No, it is not an external process that is conflicting. SQL Docs 3 is freezing up the details frame after you hit the "Save changes to database" button. You cannot click on another button or field, or scroll in that window. But, you can select another object in the tree frame view, then reselect the object you were working on, and add something else, but you can only work one description at a time. I have a screen cap video of what is happening, if you would like that. It shows the clicks with the circle, so you can see me trying to click on things, and it not working. Let me know where or how to get the attachment zip file (about 5 MB) to you.
beenhazed
 
Posts: 6
Joined: Tue Dec 30, 2008 10:15 pm

Re: Only one field description change allowed

Postby Brian Donahue » Thu Sep 25, 2014 8:33 am

You may upload your screencast to ftp://Z25737:3ugFXxA1@supportftp.red-ga ... ers/Z25737 if you are able to use FTP.
Thanks!
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Re: Only one field description change allowed

Postby beenhazed » Thu Sep 25, 2014 4:28 pm

I am receiving an error when trying to connect. The error is

Squid sent the following FTP command:

CWD users

and then received this reply

Permission denied

It looks like I cannot go into that directory. Please advise.
beenhazed
 
Posts: 6
Joined: Tue Dec 30, 2008 10:15 pm


Return to SQL Doc 3

Who is online

Users browsing this forum: No registered users and 1 guest