You're creating a new web task each time instead of running it using sp_runwebtask? Can you explain a bit about what you're trying to accomplish and why?

Andy

Robert,

I took a look at the util you referenced - it successfully decrypted a proc encrypted in SQL2K. According to the help file, encryption is stronger in SQL 2000 than...

Chris,

If you run across useful links you'd like to share, our preference is that you enter them here:

http://www.sqlservercentral.com/articles/addarticle.asp

That way Brian & Steve know to take a look at...

Brian, I think I saw the single user thing fixed in one of the more recent service packs. Prior to that I had a job that checked all db's each...

I couldnt find anything relevant on MSDN or Google. Given that it works when you try it manually, my guess is that your SQL service is slow starting and it...

Dont sweat the experience. Trust me, aint NOBODY on here knows it all! We're glad to help any way we can.

The right answer depends on your data types, so I...

The downside to this is you potentially have a single point of failure - the network share with the DSN/UDL. Other options along this same line are to broadcast a...

Is SQL set to use all 4 processors? Is the OS seeing them? Doesnt hurt to check! Have you set any of the affinity/parallel options? What version and service pack...

On first thought I like the DSN idea. You could use a UDL instead if you're using an OLEDB connection rather than ODBC.

Andy

Shouldnt make a difference how you create the temp tables. If it turned out that everyone was using the same table structure, then you'd probably see a gain by creating...

Steve is on the money here (not that he ever isn't!), definitely you want to response.write or debug.print (in VB) to see the SQL. Looks to me like you're missing...

If you're treating it as a transaction you're not going to see anything until its done. Does the insert work with one row?

Andy

John,

I think the answer so far is that we don't have any information on this - if you find some, please post it!

Andy

We ran for several months using that combo before moving to SQL2K. No issues. Worth doing it for the ease of administering Win2K I think.

Andy

Have you reinitialized the subscription and tried sending over a clean copy?

Andy