What type of Windows account is the user?

Is the user in the same domain as the SQL Server?

Same domain as the account used for the proxy?

Where is...

Deborah,

In Enterprise Manager:

1.) Go to the "Managemenet" folder for the SQL Server that runs the jobs.

2.) Right-Click and choose "Properties" from the Pop-Up Menu

3.) Select the "Job System"...

Ian,

When you say "performance issues" do you mean locking?

How are you attempting to connect?

SYMPTOMS

When you try to connect to a clustered Microsoft SQL Server 2000 named instance by using the "servername\instancename" syntax, you receive the following error message:...

Deborah,

If you are attempting to execute a DOS batch file (".bat") then your DTS package is attempting to execute the extended stored procedure "xp_cmdshell". The execution of the...

Hi Hans,

Are you calling a stored procedure or sql script that uses a cursor or counting loop?

It sounds like a CONDITIONAL statement isn't being executed properly or a...

I agree, it sounds like the "row-size" limit. Are you implicitly declaring the datatype/size of each column? If not then you maybe defaulting to the varchar(8000) or nvarchar(4000)....

The problem sounds like the user doesn't have permissions for the extended stored procedures needed to perform command-line tasks. This is a standard security practice implemented by most DBAs...