Posts
Sort by recent activity
Unexpected null value has been encountered
Version 3.9.0.43 Pro
User was getting following error
Unable to refresh or cache database [<SERVER>].[<DB>] due to the following error: An unexpected null value has been...
[FYI] 3.8/RC0 - remove the SQL Server 2005 Express Tools
Thought I'd post this here to save anyone with SQL Prompt 3.8 installed and planning to install SQL 2008 RC0 some hassle.
As has been posted already, 3.8 doesn't work with RC0. However, worse than ...
ArgumentOutOfRangeException Unhandled Exception
When ctrl-tabbing between management studio windows, I'm getting this error relatively frequently. It happens both when sql prompt is enabled and disabled.
Clicking on continue just makes the error...
sysname - Unable to insert value for unknown user-defined or
For a table that includes columns of datatype sysname, the automagical build of the INSERT statement (which is brilliant, BTW), doesn't work properly
eg:CREATE TABLE DummyTable (COL1 sysname, C...
v3.6 - NullReferenceException crash
Closing multiple windows in management studio using Ctrl-F4 held down
after two or three closed I got this error which looped until I killed SqlWb.exeSee the end of this message for details on invo...
RSS feed for this forum
Is there (or could there be) a separate RSS feed for each forum on the site?
I'm very keen to keep up to date with SQL Prompt, but the RSS feed I've found (http://www.red-gate.com/MessageBoard/rss....
Unhandled Exception
One of our developers gets this error when caching a DB with SQLPrompt on a box on which they have restricted access.
Interestingly if the cache db entry is deleted first the error is handled bette...
procedure name completion with parms after GRANT
when typing
GRANT EXECUTE ON uspMyStoredProc
and using sql prompt to complete the sproc name, I get
GRANT EXECUTE ON uspMyStoredProc
@Parm1 = ?, -- int
@Parm2 = ? -- varchar
whereas actually in...
Incorrect expansion of table alias
version 3.5.0.333
If you alias a table as 'ctat', SQL Prompt always expands the snippet ct (create table) even if you scroll down the list to select ctat.
I've reproduced this using the following d...
3.5 installer
Is there an installer for just SQL Prompt (the newly-released v3.5)?
When I go to the upgrade centre and enter our licence code the URL given is for the SQL Prompt Bundle (29mb vs 2.5mb for just th...