Do you have Vista's UAC turned off?  If not, I would attempt the connections after turning User Account Control off as well. 

I see where you have the firewall and...

You can return the results as a recordset with the name in the row or as an output parameter.

Something like this:

CREATE PROCEDURE dbo.MyProc

(

 @tg varchar(10),

 @namereturn varchar(25) OUTPUT

)

AS

...

Select @namereturn = somecolumn...

How is the connection string testing going?

I recommend changing a one or two of the stored procedures to use #temp tables instead of table variables.  Use: if exist, drop the temp table in two places as a best...

It appears that the Balance column is not numeric but char(16).  You need to do one of the following:

a)  change the Balance column to a money or float datatype

b)  Select...

The other thought, if you are setting the 12.25 to a int variable or column, change to the appropriate datatype that will handle decimals, (i.e. money or decimal).

Generically:

'text string characters here' + Cast(12345.25 as varchar(12)) + ' more characters here'

In a Select statement from a table

Select ColumnVarChar + Cast(ColumnMoney as varchar(12)) From YourTable

In a stored procedure using...

You comment "don't have lots of time to spend in this" is concerning.  Is this important enough to even continue?  The replacement for time, might be throwing hardware/money at it.

My...

Are you attempting to connect

     A) an Access application (mdb or adp) to a SQL 2005 server?

or

     B) a SQL 2005 server to an access mdb database file?

It is possible that the domain user name CHARLEY\ACT7 has had a password change.  I would edit the SQLServerAgent service Log On As properties, entering the correct password for the...

I think you are faced with two options:

A)  Modify the application that creates the database to generate new stored procedures/views after the databases are online.  Eliminates the cursor and dynamic...

Is sqlcmd included in SQL 2000 Enterprise manager or are you trying to connect EM tools to SQL 2005?  If so that may be the issue.  Is you are using...

Renaming the sql servers may not be the only issue that you run into when 'cloning'.  You may need to reinstall MSDTC and clean up any DCOM GUID/permission issues. 

I...

You need to find you master and msdb files and move them back to the original location.  Move only the user database mdf, ldf and if any ndf files to...

I would attempt to use both the sql profiler and the windows system performance tools to monitor the cpu and disk usage during the day.  correlating the slow times in...