Activity overview
Latest activity by edockx
Hello
I've recently updated SQL Prompt and am now running version 5.0.0.651 in combination with SQL Source Control, Compare, Data Compare, Search (all of which are running their most recent version).
After the update I noticed that SSMS became sluggish whenever the query editor window receives focus.
After reading the above posts, I tried uninstalling SQL Search, but that didn't fix it. Neither did repairing the .Net framework 4.0 installation (and rebooting my pc).
I can easily reproduce it by switching from SSMS to another program and then back to SSMS. If I immediatly try to scroll through my code (about 80 lines), SSMS freezes for at least 5 seconds. When I disable SQL Prompt, it reacts instantly.
Hopefully you guys can reproduce this as well and come up with a solution.
Best regards
Erwin Dockx / comments
Hello
I've recently updated SQL Prompt and am now running version 5.0.0.651 in combination with SQL Source Control, Compare, Data Compare, Search (all of which are running their most recent version...
hello David and Brian
I'm experiencing the same issue, with the latest update installed (8.1.1.74).
In my case it occurs when trying to generate the scripts for a comparison between a database and a scripts folder. The records are also limited with a "where" filter (to 1 record).
Generating a script for a change "Source Only" gives no errors. But when I try to generate a script for 1 record that has different data, the error is thrown.
More specifically I have chosen "Update scripts folder" and none of the two checkboxes are selected. When I click "Next", the dialog pops up and puts a red cross in front of "Calculating script changes" and at the bottom the "Object reference not set to an instance of an object" message is shown.
I don't know if this is helpful, but the data being scripts includes a binary column.
Thanks for looking into this.
grts
Erwin Dockx / comments
hello David and Brian
I'm experiencing the same issue, with the latest update installed (8.1.1.74).
In my case it occurs when trying to generate the scripts for a comparison between a database and ...
The name is the IP address, this is the CREATE script :
/****** Object: LinkedServer [192.9.200.10] Script Date: 10/02/2008 15:15:21 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'192.9.200.10', @srvproduct=N'SQL Server'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'192.9.200.10', @optname=N'use remote collation', @optvalue=N'true'
I reference the linked server as follows:
...
inner join [192.9.200.10].[Verso].[dbo].[TableName]
...
/ comments
The name is the IP address, this is the CREATE script :
/****** Object: LinkedServer [192.9.200.10] Script Date: 10/02/2008 15:15:21 ******/
EXEC master.dbo.sp_addlinkedserver @server =...
"Connections to ignore" does not work for linked server
I've added the linked server and "all databases" to be ignored, but the connect dialogue keeps appearing.
SQL Prompt version 3.9.0.43
Cache Management slows down Management Studio startup
Hi
I've been using SQL Prompt for a few months now and have noticed that it can slow down the Management Studio's startup.
When there are several schema's from different servers and databases in th...
CTE support
Hi,
Are there plans to support CTE's in future versions of SQL Prompt?
Thanks in advance