Red Gate forums: SQL Prompt 5 EAP

RE: Make join suggestions exclude date

Luke Jefferson — Thu, 06 Jan 2011 14:34:24 GMT

Hi,

Thanks for the post.

Request noted.

Regards,

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

RE: SQL Prompt Add-In No longer starting up in VS 2010

Sistemi — Tue, 04 Jan 2011 09:13:04 GMT

today i've got the same error message

i'm using vstudio 2010 on Windows 7 Ent x64

yesterday opening sql server 2008 management console i've requested to upgrade from sql prompt 4 to 5, all works fine..

today the error..

SQL Prompt 5.0 is now available

Paul Stephenson — Wed, 15 Dec 2010 16:24:23 GMT

SQL Prompt 5 is a major upgrade to SQL Prompt 4.

Download SQL Prompt 5

SQL Prompt 5 includes a number of significant new features:

Find Invalid Objects
SQL Prompt 5 enables you to easily find invalid objects in your database. This can be useful, for example, if you have inherited a legacy database and you want to know if objects are referencing other objects that no longer exist in the database.

Script Object as ALTER from a query window
If you are navigating a query that contains a reference to an object, SQL Prompt 5 enables you to script out that object directly from the query window by pressing F12.

View column dependencies
SQL Prompt 5 enables you to view a list of objects that reference a column.

SQL Refactor functionality
SQL Refactor has been retired with the release of SQL Prompt 5. Much of the functionality of SQL Refactor is now available in SQL Prompt Professional Edition, including the following:

Smart Rename
Qualify Object Names
Expand Wildcards
Split Table
Encapsulate as New Stored Procedure
Find Unused Variables and Parameters
Summarize Script

Requirements
SQL Prompt 5 is primarily designed to work with SQL Server Management Studio 2005 and SQL Server Management Studio 2008. Reduced functionality is also available in Visual Studio 2005, Visual Studio 2008 and Visual Studio 2010. Please note that SQL Prompt 5 no longer supports Query Analyzer; if you need to work with Query Analyzer then please continue to use SQL Prompt 4.

Microsoft .NET Framework 3.5 is required to use SQL Prompt 5. You can download the framework here.

Upgrading
SQL Prompt 5 is a major version that replaces earlier releases of SQL Prompt. The installer will automatically uninstall earlier versions of SQL Prompt if present.

Upgrading from SQL Prompt 4.x: customized options settings and snippets from SQL Prompt 4 will be automatically migrated to SQL Prompt 5.

Upgrading from SQL Prompt 3.x: none of your customized options settings or snippets from SQL Prompt 3 will be imported into SQL Prompt 5. You may wish to take screenshots before upgrading for your reference.

SQL Refactor: SQL Prompt 5 also replaces SQL Refactor. The installer will automatically uninstall SQL Refactor if it is present on the system. Saved layouts from SQL Refactor will not be automatically migrated: the Lay Out SQL feature is superseded by SQL Prompt�s Format SQL feature.

Licensing
Existing SQL Prompt users without the Support and Upgrades package: You will have a trial license when you install SQL Prompt 5. To continue using SQL Prompt 5 after the trial period, you will need to purchase a new license.

Existing SQL Prompt users with the Support and Upgrades package: If you already have a SQL Prompt 4 valid license number purchased with the Support and Upgrades package then you can use the same license to activate SQL Prompt 5 manually.

Existing SQL Refactor users with the Support and Upgrades package: If you already have a SQL Refactor valid license number purchased with the Support and Upgrades package then you are entitled to a free upgrade to SQL Prompt 5 Professional Edition. Please contact sales@red-gate.com for details.

Make join suggestions exclude date

meyerovb — Tue, 14 Dec 2010 15:49:16 GMT

I don't want date columns coming up as join conditions, as most of my tables have date columns named the same (InsertedDate, etc), it would be nice to be able to ignore that data type in join auto-complete.

Suggestion : find invalid columns

kevriley — Tue, 14 Dec 2010 15:38:26 GMT

I like both Find Invalid Objects and Column Dependencies, but what would also be useful is a hybrid of the 2 - Find Invalid Columns! In environments where the only data access is through SPs then it would be useful in highlighting potential columns that are no longer used/referenced.

Early Access survey thanks and winner

Paul Stephenson — Tue, 14 Dec 2010 14:41:52 GMT

Thank you to everyone who participated in the survey about our Early Access Program. Your feedback is very valuable to the SQL Prompt development team.

The randomly-selected winner of the $50 Amazon voucher was Aaron from Sterling, Ohio. Congratulations Aaron!

Paul Stephenson
SQL Prompt Project Manager
Red Gate Software

INSERT INTO ... doesn't return the correct column order

TSchwab — Tue, 14 Dec 2010 10:22:58 GMT

Hi,

I have a table function with a table as return value.
For example:

Code:

CREATE FUNCTION [dbo].[GetAddress] (
)
RETURNS @Result TABLE (
_ID INT
, LastName NVARCHAR(MAX)
, FirstName NVARCHAR(MAX)
, ZIPCode NVARCHAR(100)
)
AS
BEGIN

INSERT INTO @Result
(LastName
, [_ID]
, ZIPCode
, FirstName)
VALUES ( -- LastName
-- _ID
-- ZIPCode
-- FirstName
)

END
GO

When I type the INSERT INTO the SQL-Prompt returns the columns in the wrong order!

It works when the table is created with a DECLARE statement.

CREATE INDEX doesn't support INCLUDE

meyerovb — Thu, 09 Dec 2010 00:06:28 GMT

CREATE INDEX IX_XXX on dbo.XXX (C1, C2) INCLUDE(C3, C4)

After I type (C1, C2) and press space, INCLUDE is not offered.

SQL Prompt 5 Release Candidate 2

Paul Stephenson — Wed, 01 Dec 2010 16:30:45 GMT

The second SQL Prompt 5 release candidate is now ready for you to try.

Download it here

Thanks to your feedback, we have been able to address the following issues since the first Release Candidate:

Running SQL Prompt in Visual Studio 2010
Using SQL Prompt in conjunction with certain other SSMS add-ins

Please report any new issues here in the SQL Prompt EAP forum. Thanks for helping us with the development of SQL Prompt 5!

Paul Stephenson
SQL Prompt Project Manager at Red Gate Software

RE: SQL Prompt Add-In No longer starting up in VS 2010

Paul Stephenson — Mon, 29 Nov 2010 13:07:51 GMT

Many thanks for your report. We're looking into it.

Paul Stephenson
SQL Prompt Project Manager
Red Gate Software

RE: SQL Prompt Add-In No longer starting up in VS 2010

AndrewJacksonZA — Mon, 29 Nov 2010 07:29:40 GMT

Thanks Imar, I was about to post the same thing.

I'm running a 32bit installation of Windows XP SP3.

RE: SQL Prompt Add-In No longer starting up in VS 2010

Imar — Sun, 28 Nov 2010 14:17:48 GMT

More info: SQL Prompt works fine in VS 2008 on the same machine. Repairing and reinstalling SQL Prompt didn't fix the issue.

Cheers,

Imar

SQL Prompt Add-In No longer starting up in VS 2010

Imar — Sun, 28 Nov 2010 14:16:42 GMT

Hi there,

I reinstalled the latest version of SQL Prompt a few days ago and it seemed to work fine in VS 2010. Today, however, I get the error message:

---------------------------
Microsoft Visual Studio
---------------------------
The Add-in 'SQL Prompt 5' failed to load or caused an exception.
Would you like to remove this Add-in?
If you choose yes, the file it was loaded from, 'C:\Program Files (x86)\Red Gate\SQL Prompt 5\VSUI.AddIn', will be renamed.

Error Message: <Unknown Error>
Error number: 80131604

The latest log file at C:\Users\Imar\AppData\Local\Red Gate\SQL Prompt 5 tells me this:

28 Nov 2010 14:01:42,979 [1] INFO RedGate.SqlPrompt.Engine.LogService - Starting new SQL Prompt editor session
28 Nov 2010 14:01:42,990 [1] ERROR RedGate.SqlPrompt.Engine.Options.OptionsBase - Error deserializing options for RedGate.SQLPrompt.CommonUI.Options.UIOptions. Resetting to defaults.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'RedGate.SQLPrompt.CommonUI.Options.SqlPromptApplication' threw an exception. ---> System.InvalidCastException: Unable to cast object of type 'System.Collections.Generic.Dictionary`2[System.String,System.String]' to type 'System.Collections.Hashtable'.
at RedGate.SQLPrompt.CommonUI.Options.SqlPromptApplication.?(String algoOid)
at RedGate.SQLPrompt.CommonUI.Options.SqlPromptApplication.?()
at RedGate.SQLPrompt.CommonUI.Options.SqlPromptApplication..cctor()
--- End of inner exception stack trace ---
at RedGate.SQLPrompt.CommonUI.Options.SqlPromptApplication.add_LicenseChanged(EventHandler value)
at RedGate.SQLPrompt.CommonUI.Options.UIOptions..ctor()
at OptionsClass09e8dca7bb2c42bbb75a1d342298f87f..ctor()
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at RedGate.Shared.Utils.IO.Serialization.XMLSerializeFormatter.a(XmlReader , String , String )
at RedGate.Shared.Utils.IO.Serialization.XMLSerializeFormatter.DeserializeRootObject(TextReader reader, String name, String typeName)
at RedGate.SqlPrompt.Engine.Options.OptionsBase.?(Type optionsType, TextReader reader)
at RedGate.SqlPrompt.Engine.Options.OptionsBase.?(Type optionsType)
at RedGate.SqlPrompt.Engine.Options.OptionsBase.LoadOptions[T]()

I temporarily removed the XML files from my red Gate user folder but that didn't make any difference. Is there another location where my options are stored that I can clear?

SQL Prompt still works fine in SSMS.

Any ideas?

Imar

How do I Specify Where the Snippets Should be Stored?

AndrewJacksonZA — Fri, 26 Nov 2010 11:14:12 GMT

I'm trying to change the location of where the snippets are stored, but I can't seem to find where to do that.

The default location is C:\Documents and Settings\YourUserName\Local Settings\Application Data\Red Gate\SQL Prompt 5\Snippets

How do I change where the snippets are stored?

Thanks
Andrew

RE: Issues with "Find invalid objects"

kondrich — Fri, 26 Nov 2010 06:50:09 GMT

Hi Luke,

the connection to all monitored servers is within our LAN, no internet, no VPN.