... 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 =...

if you are running a default instance of sqlserver :

from books online:

net stop mssqlserver

Stops an instance of SQL Server either remotely or locally if you are running the Microsoft...

Seen it .... been there ..... done that .... burned out ..... revived ... bailed out ...

Now I'm having a job that's giving me the occasion to develop my...

Do you mind me posing the question why you would do something like that ???

If it is sqlserver consuming to much memory, you...

maybe this will get you on track ...

INF: How to Shrink the SQL Server Transaction Log

http://www.support.microsoft.com/kb/256650

and yes, you may have to repeat this action a couple of times

same player shoot again .... hit ball when lights are on

Indeed, sometimes we tend to overlook the obvious

Look what I found in my archives ...

Select  'print '' proc to be recompiled : ' ...