1) keep Mohammed Uddin's note in mind : you cannot influence the running job ! (except stopping it)

2) there is no then...

fwiw

login using your sqlserver service account and alter its local user settings. and hope nothing else breaks due to this.

as you can see, dateformat is a client-problem. What I mean is that the format is set using the client-settings for the logged in user !

That is why dateformatting is...

... So, I'm using a stored procedure which reads: xp_cmdshell osql sp_reportSP blah blah ...

within your sp...

no. the available nodes for the sqlserver-instance is totaly managed by the cluster-administrator-software.

The sqlserverinstancename is something you cannot change. drop/create is the way for that.

what you see is the encrypted hexadecimal text representing the packagename

you can add another jobstep cmdexec-type with

dtsrun.exe /N package_name

you can find more info in books online (search dtsrun)

what happens if you start sqlserver with minimal config from the commandprompt ?

sqlservr.exe -f

look for startup procs and disable them

Alter PROCEDURE [dbo].[Get_TableValues]

              @Value as varchar (100)

AS

begin

set nocount on

if @Value  = 'Model_No'

     Select Distinct Model_No FROM [IT].[dbo].[test]

if @Value = 'Proj_Engineer'

     Select Distinct Proj_Engineer FROM [IT].[dbo].[test]

end

- you can you profiler to generate a trace-script to be executed trace-to-file.

Then schedule a sqljob to activate the trace.

You might even put the trace-part in a stored proc, if...

check out datediff(mm, lowerdate, higherdate)

yes.

prior to sql2005 sqlserver would search for ...

databaseName.YOURLOGINUSER.orders    

then for databaseName.DBO.orders    

with sql2005 it will start searching for ...

databaseName.YOURDEFAULTSCHEMA.orders    

then for databaseName.DBO.orders    

is this a backup file ?

If yes, maybe there is a backup-device pointing to it ...

exec sp_helpdevice

you can rerout it using

begin tran

exec sp_dropdevice @logicalname = 'yourdevicename'

exec sp_addumpdevice  @devtype =...