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 |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2014-11-13 : 02:21:49
|
| Hi All,Is there a way to create a procedure which can transfer the SQL Data to Notepad with , column identifier. Other than SSISPlease suggest |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-11-13 : 08:52:13
|
| you could use xp_cmdshell to call BCP to write the data to a file then call Notepad on that file. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
SQL to Notepad