I recently copied a MSSQL2000 DB to a MSSQL2008 DB. Afterwards I ran a script to update all the text/varchar fields in the tables to the same collation as the model db. However, all my copied views st
I am new to .Net Programming and would like to know if Reflection is suitable for traversing an Object to discover Collections within an instance of a class.
My C# application uses SMO to d开发者_JAVA百科o various things with SQL Server instance chosen by a user. Particularly, it changes authentication mode:
How do you make SMO release it\'s connections? I have this code: public static class SqlServerConnectionFactory
I am developing an application to carry out pre-defined \"tasks\" on MSSQL database tables. It is really a tool to help with some repetitive data conversion/import tasks we have.
1) If there is already a login \'user1\' then I create a user \'user1\' for database \'db1\' by callingCreateDatabaseUserfunction
I have a script for restoring a database with PowerShell and SMO. Now I know that I can pass a event handler into PercentComplete on the restore object and get the progress of the restore as it happen
How do I deploy to a shared hosting environment... code and database (full blown SQL). What is your favorite way to get a 50MB single project ASP.NET Web Application Project开发者_如何学运维 and data
How I can connect开发者_Go百科 to the SQL instance using SMO with VB6.0?I don\'t think you can because Microsoft.SqlServer.Smo.dll is not an ActiveX DLL, but depending on what it is you want to do you
My question is straight forward, how can I program SQL SMO to take local backup, by connecting to a remote server. I want to save the bak file to a local machine which isconnecting to the remote serve
加载中,请稍侯......