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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-07-10 : 03:06:00
|
| Hi,My new project is to go through a list of tasks against each sql server 2005 machines. Each task has a different sql query which gets executed and the data is returned for each task.I am thinking of having each task with the relevant sql inside an xml file. i.e.<tasks> <task> <name>get the version of sql server</name> <sql>sql code here</sql> </task> <task> <name>get domain name</name> <sql>sql code here</sql> </task> <task> ... </task></tasks>Then a winform application goes through this list in the xml file and for each task it's sql gets executed against the master database.1)Is what I am doing correct?2)Should I do this project without the need of a UI?Thanks |
|
|
|
|
|
execute sql from xml