Does this program have any GUI components, like msgboxes or similar?

xp_cmdshell is for commandline programs only - no GUI (or other interactive parts) will work.

/Kenneth

'shaky' is just a synonym for 'not ideal'

You're right - dropped connections and such would risk leaving the semaphores stuck.

The sp_getapplock variant seems...

Seems like a catch 22 situation.

As you've noted, the emptyfile option 'locks' the original logfile to be ever used again, and the fact that it's the first logfile created in...

This sounds shaky at best.

I'd suggest that you instead create a semaphore table - maybe a datecolumn and an isRunning column - then have the proc check this table before...

If you have one RAID 5 array and divide that single array into two logical partitions, then no - there will be no performance gain for this type of partitioning....

No.

Permissions are granted to users, not connections.

Connections do not have a security context.

You could code the proc to check if it's running, and if so exit itself. (probably with some...

Why not restore it with a different name rather than DTS?

/Kenneth

-- BOL --

Permissions

Only members of the sysadmin fixed server role can execute sp_detach_db.

-- End BOL --

BOL is your friend, many words of wisdom can be found there.

=;o)

/Kenneth

Well, to be perfectly honest, in my current system I use the yyyy-mm-dd style. It is however made a "standard" - so mainly that is why it's been used. We...

This proves how ambigous these dateformats with delimiters are, and how easy they can be misread.

And you show in your other post how easy it can be to get the...

This is not true - and I have been bitten by this a few times.

Never ever use the literal forms - these are dependant on the regional language settings in...

How did you try to remove the logfile?

Did you use ALTER DATABASE with the REMOVE FILE option?

According to BOL this should be how it's done, assuming the file is truly...

If time is your main concern, are you sure that a UDF will be faster than an inline conversion?

If you don't know the datesettings on a server beforehand, then I...

So what is the 'expected' result?

The example seems to return '1' - hence the 'S' + '1' produces 'S1'

/Kenneth

Try to provide the schemas and some sample data along with the actual query that repros this behaviour.

(names may be changed to protect the innocents