Leon,

thanks for your very detailed reply. Much appreciated. I was worried that you were going to say as much.

I'll look into those options you suggested.

Again, thanks a lot.

Karl...

Chris' solution above is even better

Karl Grambow

If I understand what you want correctly, you want to create a table with the same structure as your employee table but you don't want the new table to have...

The users do not have to be sysadmins to run the job. You can add them to the TargetServersRole role in msdb and this will allow users to run...

I haven't been able to find any documentation on the xp_fixeddrives sproc. I needed similar functionality to what you're trying to do and I just happened to stumble across...

If you have the NT Resource kit installed you can run srvinfo (I'm pretty sure you need the NT R Kit) from the command prompt, using xp_cmdshell as Andy explains...

I'm not sure if the above post helped you resolve your issue.

If not, go to DOS command prompt - change directory to winnt\system32 and run following

commands:

Regsvr32...

Hery, can you confirm whether you are doing the restore from Enterprise Manager or Query Analyzer?

From EM manager when restoring from a published database you can get the following error:

[...