hi all
i have a 3rd party demo software called Crystal Command which lets you execute a crystal report in the background using command shell and save it/email it etc
exec master.dbo.xp_cmdshell @cmd
what i want to do is execute the cmd shell cmds in sql, but when i execute the command the query simply seems to run for ages and other times it runs ok.
on the same sql server i cant use openrowset from excel - it behaves in very much the same way - just looking as if its executing and never ending with no output - openrowset never returns anything!
i have since had to move my scripts and application to a sql 2000 server and link back to sql 2005 - this is working perfectly
- i can openrowset on other servers so my code is fine
has anyone else every experienced such issues?
i have a 3rd party demo software called Crystal Command which lets you execute a crystal report in the background using command shell and save it/email it etc
exec master.dbo.xp_cmdshell @cmd
what i want to do is execute the cmd shell cmds in sql, but when i execute the command the query simply seems to run for ages and other times it runs ok.
on the same sql server i cant use openrowset from excel - it behaves in very much the same way - just looking as if its executing and never ending with no output - openrowset never returns anything!
i have since had to move my scripts and application to a sql 2000 server and link back to sql 2005 - this is working perfectly
- i can openrowset on other servers so my code is fine
has anyone else every experienced such issues?
