..
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20536212.html
Hi Experts,
ASP receives an HTTP post with an XML string in it. ASP sends this string to a SP in SQL Server.
Now how do I instantia an XMLdocument COM object in SQL server and traverse the XM...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20931556.html
The following T-SQL code works when the VB6 ActiveX DLL is running in Debug mode within the VB6 IDE, but not when running from the compiled DLL. I have tried various things most recently changing t...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20946178.html
I have a problem running sp_OAMethod. My code looks like this..
DECLARE @retVal INT
DECLARE @comHandle INT
DECLARE @errorSource VARCHAR(8000)
DECLARE @errorDescription VARCHAR(8000)
DECLARE ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20967705.html
When we run
sp_helptext 'stored_procedure_name'
we can see the script for stored_procedure_name.
sp_OAMethod is saved in odsole70.dll. I couldn't see the script detail for sp_OAMethod by
...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21996934.html
I have a sql server stored procedure (code below) that basically opens a excel document that is linked to a data source, and then saves it as a new file. However I need the new file to just include...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22006677.html
I have a stored procedure that sends an email using an SMTP Mailer COM Component, ASPmail. It works fine but I want to know if there is a way to retreive the return code if the RecipientAddress is...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20561612.html
I can send email using CDO mail but i can't seem to add an attachment. can any body find any problems with this code? i'm using SQL Server 2000 (running on Win2k Server) with SMTP service for rel...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20644858.html
I have a stored procedure that calls a dll on the system. It works fine most of the time but every 8 or 9 executes it fails with the message - "Error The parameter is incorrect."
Does anyone ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20662393.html
I have the following stored proc (see below) which works very well to save a big chunk of text to a text file. How can this be modified to accept one line at a time and append the text to my text ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21131954.html
Zones:
MS SQL ServerDate Answered: 09/15/2004 Grade: A Views: 164
