Comments
Sort by recent activity
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 =...
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 ...