Passing XML between 2005 and 2000
Tech-Archive recommends: Fix windows errors by optimizing your registry
Is it possible to pass a large XML file between 2005 and 2000 sql
servers. I have an input parameter field of ntext on sql 2000. How
do i call this stored procedure from sql 2005?
exec LinkedServer.Database.Owner.StoredProcedure @parameter
What type does @parameter need to be on 2005? I can't have a local
variable of type ntext. I can't transfer xml type across linked
servers.
Any suggestions.
.
Relevant Pages
- Re: sql 2005 active/passive cluster options
... that is storing data on a seperate SQL 2005 Standard box. ... SQL server had an hardware fault causing application downtime for ... their product is an active/passive sql cluster. ... terms of active/passive failover I need two identical servers (since ...
(microsoft.public.sqlserver.clustering) - RE: permissions compatible with pre-Win2000 servers
... Based on your reply, the NT machine which running SQL 7 is not a PDC, BDC, ... With regards to the anonymouse connection to SQL, ... >Our concern is for our NT4 servers that are dedicated to running SQL7 ...
(microsoft.public.windows.server.migration) - Re: Performance Monitor / Database Storage using ODBC
... This solution would be just working temporarily (a few servers), ... Andrew J. Kelly SQL MVP ...
(microsoft.public.sqlserver.tools) - Re: Web App Security Model.
... SQL permissions are correctly restrictive (so worse case the allowed ... If these machines are standalone the threats posed by them are ... applications / implementation and whether their design has ... My company wants to have a few Windows Servers running web app's (ASPX ...
(microsoft.public.security) - RE: MS patch-scanner for Win-NT, 2K, IIS, SQL
... MS patch-scanner for Win-NT, 2K, IIS, SQL ... XML file from the following location - mssecure.xml Possible ... and on a NT 4 Server, but the scanner works fine on a W2K Server ...
(Focus-Microsoft) |
|
