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 |
|
bilencekic
Posting Yak Master
121 Posts |
 Posted - 2006-08-25 : 07:00:58
|
| why not EXEC xp_cmdshell 'c:\text.txt'orEXEC xp_cmdshell 'Notepad.exe'doesn't work ? query analizer waits and waits but nothing happens.how to run an exe ?MS BLESS US |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-08-25 : 07:12:08
|
| notepad.exe has a graphical user interface.Since xp_cmdshell cannot interact with the user interface, notepad just waits and waits.CODO ERGO SUM |
 |
|
|
bilencekic
Posting Yak Master
121 Posts |
Posted - 2006-08-25 : 07:43:06
|
| san i set a server name when using xp_Sendmaail ?beucase i have to send daily mails to users by getting some datas from databasebut mail server and database server are on diffrent locations.MS BLESS US |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
|
|
|
xp_cmdshell