Based on my experience, this problem occurs when changing local system account. You need to modify settings in your domain with domain admin privilege. Although you use an intranet, if...

PlusSELECT * FROM master..sysprocesses

Someone changed the account/

When using SELECT statement, system may lock the data pages while reading data. It is quite normal to the occurance of such locks. If the locks last too long, you...

Using cursor (master..sysdatabases, xx..sysobjects)?

Using sp_msforeachdb?

Using sp_msforeachtable?

That might be problem. Does the local account have the privilege to access the text file? Or more precisely, does the account you used have the privilege to access the...

You may try

SELECT ... FROM ... WITH (NOLOCK)

I believe you have to use ActiveX. That is the power of DTS.

No.

SELECT CAST(2000.00 AS INT)

Are you sure you have privilege to access the text file?

I tested the following script without any error.

SELECT DATENAME(Year, CONVERT(DATETIME,'20060318', 102))

I believe that we may have to convert the integer to string.

How about something like:

SELECT DATENAME(YEAR, CONVERT(DATETIME, run_date, 102)) +',' + DATENAME(MONTH, CONVERT(DATETIME, run_date, 102)) + ',' + DATENAME(DAY, CONVERT(DATETIME, run_date, 102)) = ',' DATENAME(WEEKDAY, CONVERT(DATETIME, run_date, 102))

Did you try to run the stored procedure debug on the local machine?

In order ot dig out up to the tsql/vbscript, you may have to use SQL Server Profiler, I believe.