Use Profiler

If none of your known persons are supposed to logon using "sa" , turn  Security Audit Level to ALL for debugging.

If required alter sp_password to log any executions of that...

If Disk Space is only concern, I would have done following,  

Switch DB recovery mode to SIMPLE (just while the process is running)

Update the column to null in a loop (...

select 'alter table ' + o.name + ' alter column   '+  c.name  + ' varchar(' + convert(varchar, c.length )  + ') '

from syscolumns c inner join sysobjects o on c.id...

I had SQL 2000. & Did forgot to check BOL about this.

BINARY_CHECKSUM is not available in SQL 7. 0

Try using  BINARY_CHECKSUM

Binary_CHECKSUM Returns the binary checksum value computed over a row of a table or over a list of expressions. BINARY_CHECKSUM can be used to detect...

A quick way that I used to use this scripts on Case Sensitive Servers

was to load the script in Query Analyser

CTRL + A (select ALL)

CTRL + SHIFT + L...

You could achieve this by using dtsrunui.exe that ships with client tools. User has to do a logon, retrieve list of dts available, fill in parameters and execute package.

I...

Try this

adocm.ActiveConnection = AdoDREAMConn

adocm.CommandType = adCmdStoredProc

adocm.CommandText = "SP_EXPORT_SUPPLIER"

adocm.Parameters.Refresh  ' or manually append parameters ....

adocm.Parameters(1) =  param1_value

adocm.Parameters(2) =  param2_value

.

.

.

adocm.Parameters(n) =  param_n_value

MsgBox adocm.Parameters( out_param_number  )

MsgBox adocm.Parameters( 0  )  ' for return value of...

I suggest following rating system for Forums.

1. While posting the poster will rate his posting on a scale of 0 to 5 (not usefull to Very helpful).

2. The Starting member of...

Can you post the error messages when you try and run sqlsrvr from command line without any parameteres ?

Also did you restart the service using Control Panel -> Admin Tools...

See Windows NT Resouce Kit for such tools

Adding a print @Cmd to above proc and running it as a startup displays

[autoexec] copy ".2" "200403031522.log"

So i guess only the xp_regenumvalues does not work in startup proc....

I have altered the proc as per below.

The results,

The proc does fire. It also uses appr. DLL for xp_cmdshell and xp_regenumvalues , but still fails to...

This is still not solved ..................

I got one more PM and a email.

On reading PM, I get another email saying "This is friendly notification to inform you that Amit Jethva...

See http://support.microsoft.com/?id=306843