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 |
|
gongxia649
So Suave
344 Posts |
 Posted - 2006-05-11 : 10:20:41
|
| how do i create a log file after i exec a proc. |
|
|
gongxia649
So Suave
344 Posts |
Posted - 2006-05-11 : 14:39:16
|
| bump |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
gongxia649
So Suave
344 Posts |
Posted - 2006-05-11 : 15:46:27
|
| lets say.select * from itemsresult is going to show on query analyzer.i also want to show the results in a log file. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
gongxia649
So Suave
344 Posts |
Posted - 2006-05-11 : 20:39:38
|
| using a trigger can create a log file?i didnt know that |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-12 : 01:27:12
|
| If you are trying to create an "audit" of changes you would be better to insert the changed rows into a separate audit table - rather than to "export" them to a file.That way you can report on the changes for specific criteria etc., but you can also produce chronological reports of changes - which is all you would get from a log file!But there again maybe the log file is to communicate the changes to some other application?What problem you are trying to solve?Kristen |
|
|
|
|
|
|
create log file