Is there an API that has built in functions/methods to manage a SQL Server Host?
You could just connect as sysadmin and execute the sql commands, but i think there is something out-of-the-box for this.
|
feedback
|
|
What you want is SMO (SQL Management Objects). It is the API for managing SQL through managed code. Have a look at this MSDN article: http://msdn.microsoft.com/en-us/library/ms162169.aspx | |||
|
feedback
|
|
Have a look at Microsoft's PowerShell. I suspect it is what you're after. http://technet.microsoft.com/en-us/scriptcenter/powershell.aspx | |||
feedback
|
|
No, SQL Server interface is SQL Language. There are some Object models, but nothng .NET specific. Check http://msdn.microsoft.com/en-us/library/aa274764(SQL.80).aspx for the administration objects. | |||||
feedback
|
