Posts
Sort by recent activity
No support for SQL 2014?
I get an error:
SQL Server 2005/2008/2012 required for LiveDatabase Reading.
This is when trying to create a new project on a schema with no data on SQL 2014 during the Creating Project->Create Pro...
SQL Prompt 6 copy not working
I've noticed that with the EAP of SQL Prompt 6 the copy button is gone from the object pop-up window that contains the script/summary when you mouse over a proc/func in a query window. There is now...
SQL Prompt 6 issue with SQL Test 1
I recently installed the EAP of SQL Prompt 6 at the recommendation of one of the support folks, V5 had been crashing VS2012 on close - and the EAP 6 version did indeed seem to fix it.
However, now ...
SQL Prompt causing VS 2012 crash on exit
Since installing the newest version of SQL Prompt 5.3.8.2 the other day, I noticed that Visual Studio 2012 now crashes on exit every single time. Windows will then pop up a window offering me a sol...
SQL Compare sync through SSMS 2012 causes SSMS to...
...think it has crashed on close. I always have the script open in SSMS to review it before running the sync, usually for only a few stored procs/funcs at a time, and each time after I execute, cl...
SQL Prompt mangles statements when certain key combinations
...occur.
An example:INSERT INTO admin.TestTable
( ID ,
TestColumn ,
TestColumnDateTime
)
VALUES ( 0 , -- ID - int
'' , -- TestColumn - ch...
Improper syntax for table variables
When I bring up SQL Prompt intellisense from this point:DECLARE @Table TABLE ( ID INT )
INSERT INTO @Table
( ID
)
SELECT TOP 10
object_id
...
Missing snippets
I've recently done a lot of uninstalling and re-installing of SQL Prompt to try and resolve a different problem that I've posted here about. I think I have found a way around that problem, however ...
SQL Prompt 5.3.4.1 Crashing SSMS on CTRL-K, CTRL-Y
Starting this morning SQL Prompt has started crashing every time I use the CTRL-K, CTRL-Y key combinations. When I debug this is what I see:
System.NullReferenceException was unhandled
Message=Obje...
SQL Prompt and case statements
I'm finding that SQL prompt stops working if I am adding a column before a case statement, for instance the following SQL code:CREATE TABLE [dbo].[TableTest](
[ColumnOne	...