Thursday, December 27, 2007

Linked Server

Well add a linked server using the procedure sp_linkedserver and drop the same using sp_dropserver

Found an issue when data is being pushed from a Windows 2000 sql server to a Windows 2005 sql server using a link. The same would not succeed when the update statement used columns with spaces it seemed when the statement was passed to the remote server the square [] brackets around the field name were not getting carried this issue is confirmed as a bug on the microsoft site the work around for this could be to use a nested query for comparison with the field coz if compared with a memory variable it would generate an error.

1 comment:

seseth said...

you can look here i3f38a9t90 replica designer bags replica bags vancouver visit this web-site f8b52v9l61 high end replica bags replica bags wholesale mumbai replica bags cheap discover this j4y30s7m07 replica bags aaa