Posts
Sort by recent activity
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...
Expanding SELECT * across databases - incorrect prefix added
V3.5.0.323
With a query joining across two databases and only one of the tables qualified, the other taking the current database, when the SELECT * of the table in the current database is expanded ...
Snippet/Editor management application
excellent program
probably worth adding to this sticky though that 3.5 has this functionality built in (so far as I can tell)