The 'TargetServersrole' role in the msdb database gives access to control certain jobs. This may be what you are after

Regards

You can use the command line programs 'OSQL' or 'ISQL' to run .sql files from the command line without opening them.

command line commands can be run from inside Query...

If you are after the full database, you can run a backup/restore.

For coping data from tables, you can use dts or bcp.

You would need to run a one-off conversion to bring all the historic data in-line, and from that point onwards save the dates in UTC.

There is a basic table showing time zones/utc conversion at

http://setiathome.ssl.berkeley.edu/utc.html

Wouldn't using UTC time function sort this out i.e. using GETUTCDATE() rather than getdate()

Edited by - steven_white40 on 04/25/2003 06:24:54 AM

I wonder how feasible it would be to install the sql server 2000 eval edition (which I seem to remember Microsoft patched to sp3), then upgrade the server to the...

Take a look at the install log files, this may help you identity the problem.

Also if you run out of ideas you could try and install mdac separately. Then once...

Try the DATABASEPROPERTYEX function

eg.

SELECT DATABASEPROPERTYEX('Pubs', 'Recovery')

Have you checked the sql startup account for that server.

If the account has been set to 'change password on next login' etc it will not be able to obtain any...

I'd recheck your xp for leaks.

Look in the sql log directory on the server.

You should have a .dmp file which may give more information

When you run DTS via xp_cmdshell it will run on the sql server, rather than your pc

Does you .xls file exist in the c:\test directory on your sql server?

You can use server side traces to record this information, then load it into a table.

See the follwing link for more detils http://www.sqlservercentral.com/columnists/hji/trace.asp

Does it work if you execute the run the DTS package from the server?

DTS runs client side, hence if you run it via Enterprise manager on your pc it runs...