It was not a large number of reports that we needed to move so we decided to just redeploy them in the new machine.

However I read that in SQL Server 2005...

thanks.

One more thing, I am trying to call the extended stored procedure from within a function. I have just read somewhere on another forum that a Remote function calls are...

Thanks for your reply.

No, spid(s) involved are > 50

I first run the select @@trancount to see if there was any transaction pending.

There was one so I then committed it. After that I was able to go back to the...

I just found answer for SQL Server 2005:

Set both PUBLICATION and DISTRIBUTOR databases SYNC WITH BACKUP

However, can this be implemented in SQL Server 2000?

Have you checked to put the name of the owner of the table if it is other than dbo?

I was hoping that there could be a away around it.

Thanks for your reply.

Thank you very much to all for your time.

Thank you very much for your reply. Which one should I install first? 2000 or 2005?

Thank you very much to both of you for your replies. I just wanted to make sure that I am not missing something trivial.

Thanks for your input.

We have Oracle ODBC client tools to LINK an Oracle Server and query it via Query Analyzer.

The set up has been working fine until last week when we...

I checked the version of msado15.dll on the server and it is 2.82.1830.0 so I believe it is the latest version.

Your @param variables are all varchars so in order to concatenate them try the following and see what happens:

SELECT @sql= 'SELECT col2,col3, col4, col5, col6, CAST (SUM (col8) AS decimal(9,2))...

Thank you very much.