I wrote an application to use SQL SMO to find all SQL Servers, databases, jobs and job outcomes. This application is executed through a scheduled task using a local service account. This service accou
I\'ve been looking at the possibility of creating a CLR trigger for insert, but every tutorial found gives me examples of using ado.net objects to do the logic - this is not very convenient way..(I do
I am trying to add new roles to a SQL 2005 database via the SMO assemblies. The Roles.Add method just does not seem to add the new role. I have my user account set as securityadmin and sysadmin.
I have the SQL2008 version of SMO and although it uses this class internally I can\'t figure how to bring it into scope so I can declare vari开发者_开发百科ables to hold values of this type.
I\'ve read a dozen different blogs, as well as reading through the msdn examples and they just aren\'t working for me.
SQL Server 2008 Using all the correct references I dare say: System.Data.SqlClient; Microsoft.SqlServer.Management.Smo;
加载中,请稍侯......