I figured out the problem. It seems that in the SP where the code reads:

' "' + @param1 + '"'

There were double quotes, which made the query treat param1...

Thanks for your help. I guess I'll just try and change the functionality.

I kinda figured that... however, I did come up with an idea you may be able to help me with. I noticed you can pass ntext datatypes so I...

1. Currently the asp on the local server reads and writes local files, would prefer to update the database and have SQL create/update the text files to the local drive...

OK, getting the appropriate rights is not a problem. How would I handle creating a trigger for an update to wite out a long text value to a specified...

I have a job scheduled that needs to run at a lower priority than the other scheduled jobs. This job is a non-interactive job and it shouldn't take priority...

Both servers are running SQL Server 2000.

When I set up the remote server as linked server instead of a remote server and I try to open our website and run a report (which executes a RPC)...

Yes, but it didn't work. Still searching for a workaround...

We already have a remote server defined with a user, which works. If we try and add a linked server it says the server already exists. We removed...

Hi Greg,

The SQL Server Agent is trying to pass Windows authentication instead of SQL authentication. Since these servers are not in the same domain, this doesn't work. I...

Sorry I got in on this late, but I did contract programming for MCI (before their merger/byout whatever and all the layoffs). We were using SQL Server for...

UPDATE: It is now working!

I did a response.write on my execute statement and pasted it into query analyzer (the query was actually running a stored proc) and ran it. ...

Thanks again.

That will make my SP code so much more compact and easier to manage.

You have been a tremendous help!

It worked!

Thanks for all your help! I am going to start using PRINT more often for debugging my SPs. I have been trying to find code on the...