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 |
|
magesh
Starting Member
23 Posts |
 Posted - 2005-08-16 : 00:19:07
|
| Hi all,when i run OSQL -L command in DOS prompt it displays SQL server installations in my LAN but when i execute exec xp_cmdshell 'OSQL -L' it displays only few SQL server installations..what is the reason behind this difference..Magesh |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-08-16 : 06:59:37
|
| 1 is run from directly your client1 is called from your client via QA, but actually executed on the server itself....and possibly it (the server) doesn't 'see' the other servers. |
 |
|
|
magesh
Starting Member
23 Posts |
Posted - 2005-08-17 : 00:57:32
|
| thanks Andrew.I understand the functional difference between these two executions..Magesh |
|
|
|
|
|
|
exec xp_cmdshell 'OSQL -L'