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 |
|
anujahnavi
Starting Member
2 Posts |
 Posted - 2008-01-03 : 01:14:22
|
| i want to save the result of the query to a xml file .when any dml operations done on the table then the whole table must be appeared in the xml format in xml file.("Select * from Table_name").Can any one help me out.this must be dont directly .not by using any of the tools.Suppose in sqlserver express we can do this by using 'bcp' tool.But i dont want that .Plzz Help me out.Thanks & Regards ,Anujahnavi S.anujahanvi |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-01-03 : 01:26:46
|
easiest is to use SQL Profiler for this. why not use a decent tool that has already undergone extensive use/testing? why roll your own?EDIT: just noticed you are using express, and profiler doesn't come with express (I think). sorry! perhaps this will help you out: http://sqlprofiler.googlepages.com
elsasoft.org |
 |
|
|
|
|
|
Save query result to a xml file through triggers