Not sure about ASP but you could use ASP to call a VB control that executes the package:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dtsprog/dtspapps_2hb7.asp

Create FUNCTION dbo.fn_GetDbName ()

RETURNS varchar(30)

AS

BEGIN

RETURN 'dbName'

END

Then to use the function:

declare @dbName as varchar(30)

select @dbName=fn_GetDbName()

Sounds like a good job for xmlHTTP object (not sure if its still this in ASP.net). You can get info in the XML SDK or check out some of...

Not sure but the output should be a standard http response. I will try some things out and get back to you. The other thing you could do...

To tell you the truth Ive never know anyone who was using Windows Authentication on SQL server in conjunction with a web application that used basic authentication. Generally what...

Im not sure I would try to accomplish all of that with TSQL in a stored procedure. You could however write a vb application or even a vb script...

Try creating a standard html file in your virtual directory and see if you can bring it up in your browser, this way you will know it the web site...

Thanks; everyone for the responses to my article. I will try to address everyone in the next day or two. Lets start with spowell_2 because your solution is...

Taken from TSQL Help file:

Temporary Tables

You can create local and global temporary tables. Local temporary tables are visible only in the current session; global temporary tables are visible to all...

Pulled this from msdn:

Example

This code fragment shows the usage of the BodyFormat property in preparing and sending an HTML message:

Dim myMail

Set myMail = CreateObject("CDONTS.NewMail")

HTML =...

One way you can get around this is by preceeding any numbers in the column with a single quote (') This tells excel to treat the number as text.

I don't see the problem on my sql 2000 box sp1. Why are you using ODBC? Why not the SQL OLE DB Provider for sql server? Do you...

Not sure if this will be of any help but can't hurt to check it out.

http://msdn.microsoft.com/library/default.asp?url=/workshop/delivery/channel/overview/overview.asp

No sorry xmlHttp will not push information. All it does it make html requests to a web server. If your client had a web server running you could...

Im not an expert on the Http protocol but I do not believe that it works this way. I pulled this from microsofts web site:

HTTP

HTTP, or Hypertext Transfer Protocol,...