You have to take a few things into consideration when deciding how often to run jobs.

1. How long does the job take to complete and how many users will be...

Why not assign them to a single schema that has read permissions set for all users of the other schemas? Seems like they could all have read-only access to...

I suggest that you install 2005 first and then 2008. This is due to the incompatiblity of the 2008 SSMS with 2005.

If you do install 2008 first, be sure...

If the rows are truely duplicates you could do:

INSERT INTO tempTbl

SELECT DISTINCT * FROM origTbl

And then delete everything from the first table and insert the distinct rows back in.

Looking at this again I noticed that you are casting the CuryTotInvc value to a varchar in the function, but not in the straight query that runs properly.

Try making the...

That is very strange. There is no direct reference to Tbl1003 in the code. Is 'sol' a synonym for Tbl1003, prehaps?

If you could provide a script to reproduce...

First thing I would check is the status of the SQL Server Browser. If it is already running, then take a look at this article for some things to...

Do you get a specific error message when the user tries to run a query?

That may help. It just seems strange that sa from the remote client works different...

I would still think permissions, but don't have any brilliant ideas.

Can you install the non R2 version of client tools and see if they (still?) connect ok?

Just an INSERT INTO for each row in 2005.

In SQL Server 2008 you can use the VALUES row constructor.

First thing I would check is whether the SQL Server instance is started in the Services control panel.

You can certainly do this. Unless you expect a wide range of possible values, you can pre-populate the parameter values with a query that does the calculation.

Try this link...

This is a duplicate post. Please do not post a question more than once.

http://www.sqlservercentral.com/Forums/Forum392-1.aspx

Looks like the initial dataset needs to be uploaded. Try this:

http://msdn.microsoft.com/en-us/library/bb630283.aspx

Yeah, saw that after posting. Keep getting side tracked by work.