You are correct. Thank you for the swift response

I finally got it to work. The only change I made was to change the owner of the sql job to the service account. That seemed to do it... At...

Yes, I can use NET STOP and NET START to stop and start the service in question...

results of the xp_cmdshell query for USERNAME = svc_sqldev and USERPROFILE = C:\Documents and Settings\svc_sqldev which is as expected.

I have logged onto the server as the agent account ( a domain account) and the ssis runs fine when run manually. We have also set this agent account as...

Just to be clear, this ssis package fails ONLY when run as a job. The SSIS and all code runs well when it is started manually in Visual Studio.

DAM

Error is as follows:

Date2/24/2010 11:47:21 AM

LogJob History (JOBNAME)

Step ID1

ServerSERVERNAME

Job NameJOBNAME

Step NameRun SSIS

Duration00:00:02

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries Attempted0

Message

Executed as user: DOMAIN\USERNAME. Microsoft (R) SQL Server Execute Package Utility...

Bru,

Thanks for the response. Running the app as an administrator does work.

DAM

I have answered my own question... When using the NET START command, a / is used instead of a -.

So the correct syntax is NET START MSSQLSERVER /g512.

Once the correct...

I am using the -g switch from the command line starting sql server using the following syntax

NET START MSSQLSERVER -g512.

The server starts, but when I look in the log,...

When I first restart the server, by default the max free space isd around 150Mb. As we work on the server and run the app the max free space decreases...

That is interesting... I will try at first opportunity. Another quick question...

When I use the -g switch, the max free size is not increasing. I am assuming it is because...

Paul,

The program is called Datatel Colleague. It is an ERP for educational institutions. At one time, the code for functions was just that, functions written in tsql. Since migrating to...

Sorry Jeff,

Sunday was a day for Golf and football... I did see your request for what the CLR (C# code) does. Unfortunately, the application is an off the shelf

ERP and...

Yes, AWE is enabled... with about 20GB max server memory

Daniel