newid() is a function that returns a uniqueidentifier.

rowguid is a setting that you can place on a uniqueidentifier datatype column to allow it to be used for replication.  All tables that...

this may be cleaner

case when col1 = 1 then 'yes'

case when col2 = 1 then 'no'

else

'maybe'

end

note that if a condition is met then it stops looking so if...

nested case statements look like this

case when col1 = 1 then 'yes' else

case when col2 = 1 then 'no' else

'maybe'

end

end

when you run it manually are you logged into the server or are you on a workstaion connected via enterprise manager? 

where is the dll file located?

I have had this problem getting fixed lenght from a legacy machine where the final field was not always populated.  I wrote this vbs script to pad the rows and...

try this, it won't delete the data but should display what you are looking for

SELECT    TimeOfCapture, Value1, Value2, Value3) FROM         FactoryTable

join (select max(timeofcapture) as maxtoc from factorytable group by convert(varchar,timeofcapture,101),datepart(hh,timeofcapture)

WHERE     (MONTH(TimeOfCapture)...

938 Can't find a better way then bouncing him off the tree top.

if you are just looking go find the name associated with the ip address then use ping -a ipaddress from the command line.   

you would also need to create a modify_date field with an update trigger that sets it to getdate() on record update to track the updates

vbs scipt to append:

set fso=createobject("scripting.filesystemobject")

set nfl = fso.createtextfile("c:\\pathtoresultfile\resultfile.txt")

set fl= fso.OpenTextFile("c:\pathtofile1\file1.txt")

do while not fl.atendofstream

 nfl.writeline fl.readline

loop

set fl= fso.OpenTextFile("c:\pathtofile1\file2.txt")

do while not fl.atendofstream

 nfl.writeline fl.readline

loop

set fl= fso.OpenTextFile("c:\pathtofile1\file3.txt")

do while not fl.atendofstream

 nfl.writeline fl.readline

loop

nfl.close

set nfl=nothing

or you can use

select...

If the list of files is in a table you could build a DTS loop to import all of the files.  If you want to import all of the files...

The other option is to put the comand line with argument in a batch file and run the batch file from the scheduler.  If your month end jobs are all...

Have you tried putting the exe into an execute process task in a DTS package and then scheduling the DTS package?  The task is designed to take parameters for executables.