Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Hyukevain
Yak Posting Veteran
66 Posts |
 Posted - 2005-01-25 : 20:23:46
|
| Hi,I develop a client server application program and I use SQL Server 7 as my Database.I use DTS package to execute some SQL command. Because I don't install SQL Server 7 on client computer so I need to run the DTS package from server.SQL Server 7 doesn't support any parameterize syntax when execute DTS so my DTS package will take the setting from windows registry (I use remote registry to write the setting from client computer to server). When I use master..xp_cmdshell to execute the DTS package, some error pop up. It seem that when I use xp_cmdshell, my DTS package cannot read from registry, maybe this because some exclusive privilledge from SQL Server 7 that don't allow that.Is there any other way to run command from remote computer without using xp_cmdshell from SQL Server and can I have some example about it ?Regards,Mike |
|
|
Hyukevain
Yak Posting Veteran
66 Posts |
Posted - 2005-01-26 : 00:21:15
|
| I've check it and the problem occur because even I said read from HKey_Current_User, but the DTS read from Hkey_Users ! Is the any solution to solve this problem, coz with remote registry, I can't write to HKey_Users. |
 |
|
|
|
|
|
Execute Remote Command