Unfortunately it's not a stored procedure, but a parameterized query.

I always use ROBOCOPY for this kind of thing. It was included in the resource kits for win nt and win 2000, I am not sure if it comes with...

As far as I remember, you can change the properties of the arrow that you drag from one action to another, so that it will only do the second part...

I did a little research myself.

To get the currently running processes, use:

SELECT

session_id,status,

command,sql_handle,database_id

,(

I did a little research myself, as I was looking for something like it as well.

To get the currently running processes, use:

SELECT

session_id,status,

update table1

set [server owner] = table2.[server owner]

from table2

where table1.[server name] = table2.[server name]

 (or something like that)

In sql 2000, I used

   SELECT @SQL = text

   FROM   ::fn_get_sql(@Handle)

where @Handle is the sql_handle from sysprocesses.

That seems to still work on 2005.