Both activities a temp table in a UDF and the population of a temp table variable from and exec proc are not allowed temp (The errors say it all).  Why do...

Did you change your username or password? I am assuming you changed your domain logins password. Do you have a local account created on the host where MS SQL Server...

The only thing I can think of is change the path from default to the actual path to the backup dir and I would also check the box for use...

There will be no performance gain if both files are on the same raid array (the data is striped accross all drives in array).

Linked server can have sql and procedures ran against them and remote servers can only use procedure calls.

The easiest way I have found to set up a linked server:

First create...

What login prompt EM/isql? You would need to log out and back into windows to log in as this domain user. You could create a global group add your co-workers...

isql -Uusername -Sservername -iscript.sql -oscript.out

Query Analyzer

I hope you find that the developers are openeing a connection, executing a query and then not doing .close on the object.

Obviously these locks are not copmaptible! Connection pooling should leave shared locks at the DB level when the process is done with the connection. What is the application doing is...

No, don't do the sum just ad the case to this column or the same column with the case and still do the sum in the other query:

<CFQUERY name="RICSV" datasource="#Application.DSN#">

  ...

I have never trusted the default directory and always use a path instead (f:\Data\Microsoft SQL Server\MSSQL\Backup). You can alsoccheck and see if the job has actualy executed the delete old files...

Just do the case in the master query!

You will need to find constants that exist in every row. Can you post a few rows of data in greek format (no real ssn's or addresses)

Is the sql case sensitive in coldfusion?

master query=Compliant75pctRule

detailed query=compliant75pctRule

Do you have any control over the text file you are trying to load?