Red Gate forums: SQL Refactor 1

RE: Unused Params & Variables

frisky — Fri, 02 Mar 2012 11:59:05 GMT

Joojooflop wrote:

This appears to have been fixed in SQL Prompt 5.

Haven't noticed any fixes. Still get the error in my original message when doing this with "Find Unused cell phone spy variables and parameters".

RE: Unused Params & Variables

Joojooflop — Thu, 28 Apr 2011 17:42:41 GMT

This appears to have been fixed in SQL Prompt 5.

RE: Unused Params & Variables

mnowill — Thu, 28 Apr 2011 15:45:08 GMT

I am having the same issue and can reproduce the the same situations as Joojooflop

RE: Unexpected line wrapping

james.billings — Mon, 31 Jan 2011 13:12:11 GMT

Thanks for your post.

If you haven't already, can you check to see if the problem persists if you use the latest cumulative patch? You'll find it here

SQL Refactor has now been replaced with SQL Prompt 5 in case you didn't know - if your serial number has a valid support & upgrades add-on then you can use Prompt 5 for free.

Unexpected line wrapping

snkscore — Thu, 27 Jan 2011 16:26:25 GMT

When I use Layout SQL on a Create Table statement, all of the varchar columns have their "NULL" wrapped onto the next line.

For example this line:
[EventType] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

Becomes this:
[EventType] [varchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL,

The NULL is indented 26 spaces from where [EventType] is located.

The original line is 76 characters including all spaces. Even thought my "Line Wrap" value in SQL Refactor was set to 78, I tried changing it to 120 and then eventually I turned it off all together, but the NULLs continue to wrap.

Any idea?

SQL Refactor is retired: now part of SQL Prompt 5

Luke Jefferson — Mon, 10 Jan 2011 10:26:31 GMT

SQL Prompt 5 now integrates SQL Refactor functionality. SQL Refactor users should contact sqldev.info@red-gate.com for entitlement and upgrade information.

Please visit the following page for more information:

http://www.red-gate.com/products/sql-development/sql-prompt/sql-refactor

Luke Jefferson
Product Manager
Red Gate Software
E: luke.jefferson@red-gate.com

RE: SQL Refactor 1.3 install Fails to load on SSMS 2008 R2

monkeygrind — Wed, 29 Dec 2010 22:01:02 GMT

I just tried it and it worked fine for me.(Win2k8, SQL2k8R2). So it's active again, I think.

RE: Can I copy the script summary?

jacob_r_jensen — Thu, 23 Dec 2010 10:43:43 GMT

I too would love to have the option to use the gathered information outside the summary report. If it were possible to call the summary report from a script and pipe the results to a file, it would really be a great help in building flow charts and execution schemas for my stored processes.

RE: Feature Request: Expand wildcard with qualified column names

chriskelly — Mon, 20 Dec 2010 15:00:26 GMT

Thank you for your suggestion.

Unfortunately there will be no further development work on SQL Refactor. This is because the functionality (including Qualify Object names) has been incorporated into SQL Prompt, which has just been released (as SQL Prompt 5).

If you are able to, I would recommend trying out SQL Prompt 5 to see whether there has been an improvement over SQL Refactor. If not, then please reply to this post and we will raise a Bug Report for the development team to look into.

Feature Request: Expand wildcard with qualified column names

whenriksen — Thu, 16 Dec 2010 22:53:11 GMT

Can an option be added to qualify column names when expanding a wildcard?

I regularly run into tables with matching column names. When I use the expand wildcard feature with a join, I end up with 'ambigous column' references since the matching column names are not qualified.

At that point the Qualify Object Names feature won't fix it because Refactor no longer knows which column belongs to which table.

RE: A couple of suggestions

thirster42 — Mon, 13 Dec 2010 19:44:10 GMT

Chris Auckland wrote:

Thanks for your post and suggestion.

I've logged your feature request with the internal tracking code SP-3643. Hopefully it will be approved for a future version.

With regards to the template information, it seems to be working ok for me.

I had a look around and found the following post:
<http://stackoverflow.com/questions/1250120/ctrl-shift-m-no-longer-working-in-sql-server-management-studio>

Although, I'm using SSMS 2008, and it works for me.

What are the actual symptoms when you use the ctrl-shift-M combination?

i'm running SSMS 2008, and when i hit the command nothing happens.

RE: A couple of suggestions

Chris Auckland — Mon, 06 Dec 2010 19:37:27 GMT

RE: New Feature Request

Linda Hawksworth — Mon, 06 Dec 2010 12:24:57 GMT

Many thanks for your suggestion. I have logged it in our tracking system with reference SP-3639 (logged against SQL Prompt 5 as SQL Prompt and SQL Refactor are being merged into SQL Prompt v5.).

RE: SQL Refactor 1.3 install Fails to load on SSMS 2008 R2

neuracnu — Thu, 02 Dec 2010 22:59:53 GMT

Anu Deshpande wrote:

Thanks for your post.

We upload all our patches either on our website or on our forums.

You can download the latest patch for SQL Refactor from here:

http://www.red-gate.com/MessageBoard/viewtopic.php?t=9960

Yes, I read that. The download link in that thread (ftp://support.red-gate.com/Patches/SQL_Refactor/SQL_Refactor_1_Cumulative_Patch.zip) does not work and appears to have been down since May 2010 - the FTP site is dead. Can we get a working link to it?

New Feature Request

bcunnin — Thu, 02 Dec 2010 19:34:09 GMT

I have used SQL Refactor for a while now and really appreciate the features that make it easier to understand existing code, which is what I use it for the most. However, I would like to propose a new feature. I would really like to see a tool in SQL Refactor to remove all unnecessary table aliases. By unnecessary I mean any alias in a query where the table that is aliased only appears once. If the table is joined in twice, like for a self-join, then just leave those alias(s) alone, but remove any other aliases that may appear in the query and replace the alias names with qualified names.

The reason that I�m interested in this feature is two-fold. One, when learning a new schema, I think that it is enough to have to learn one name for each table. To have to learn two names for a table ought to be unnecessary. Secondly, I have run into something I never thought I would see: a stored procedure where the same table in different queries in the procedure are aliased to different values. For example, in one query in the stored procedure the table �KpiValue� is aliased to �v� and in the next query in the same procedure it is aliased to �kv�. Yuck.

It seems to me that SQL Refactor probably already has a lot of the stuff in it that this feature would need, so I hope that it wouldn�t be too difficult of a feature to add. Thank you for your time.