Along the same lines, how does one control an instance in SQL 2005? I mean, how could I create databases and tables within programmatically (via a service)? Ultimately I need my application to guide a user through the process of creating a database and tables within it via a winform connected through WCF services. It would make sense to have only the high level commends be passed via the service, and have the service implementation take care of the actual syntax the DB requires.
So should this be via a dgv that has pull-downs for each column type with the types that sql 2005 will support? I guess I get a little scattered when it comes next to the part of how the client should communicate to the server... In other words, as a serialized XML object, as plain XML, as an object of primitives, etc. I'm not certain only due to the nature of each request being unique among others. TIA! pat :)
