Include the following in “Troubleshooting Issues” of Chapter 7, “Troubleshooting” in the Web Services User’s Guide.
The sp_webservices add command may return the following error when generating proxy tables:
Warning: Row size (3347 bytes) could exceed row size limit, which is 1962 bytes. Msg 208, Level 16, State 1: Server 'JMALVARADO', Line 1: tempdb..ws_4338e6e122cd4ef0a not found. Specify owner.objectname or uses to check whether the object exists (sp_help may produce lots of output). No proxy tables were created for the WSDL URL: [http://www.xignite.com/xquotes.asmx?WSDL] (return status = 0)
This error occurs because the remote server representing the Web Services Consumer has been added using sp_addserver with a class other than “sds.” Use sp_helpserver in isql:
1> sp_helpserver ws 2> go
In this example, ws is the name of the Web Services Consumer. This is the default. The remote server class is returned in the indicated column of the result:
name network_name class ... ---- ------------ ----- ... ws ws null ...
Change the class of the remote server to “sds” by using sp_dropserver and sp_addserver in isql:
1> sp_dropserver ws_name 2> go ... 1> sp_addserver ws_name, sds, ws_name 2> go
In this example, ws_name is the name chosen for the Web Services Consumer.