smo
Restart log shipping when out of sync
The scenario is. A database secondary server are for different reason out of sync or is suspected that is not sync.Someone has made the secondary databases online by mistake or other mishaps. If you n[详细]
2023-02-25 01:22 分类：问答SMO Server connection not closed
I\'m writing a C# application that upgrades client machines from one application version to another. The first step is to create a backup of a SQL database. I\'m doing this using SMO and it works fin[详细]
2023-02-21 21:06 分类：问答Building .Net application entities after deployment
I am working on a product in which some business entities are defined after deployment based on inputs from the site administrator. The application then prepares a schema and creates sql objects (prim[详细]
2023-02-20 20:16 分类：问答Compatibility Issues for SQL Server 2005 and SQL Server 2008
I\'m trying to execute a schema file on a SQL Server machine. I currently have both SQL Server 2005 and SQL Server 2008 installed. When I try to execute the .sql file (meant to execute on the 2008 ver[详细]
2023-02-19 15:47 分类：问答C# SMO - Scripting Table Data to File. Throwing Error
I\'m trying to create a backup of the data contained within my database before I re-create the tables. I\'ve got so far as to connect to the server and create the file to store the SQL. The problem is[详细]
2023-02-18 17:21 分类：问答Copy a stored procedure from one SQL Server 2008 to another using SQL Server Management Objects
I am using the SQL Server Management Object lib in a C# application. I need to copy a stored procedure from a source server to a destination server on a different machine. I can retrieve the StoredPro[详细]
2023-02-14 13:51 分类：问答Error restoring database backup to new database with smo and powershell
Taking a database backup from another server I\'m trying to restore to sqlexpress on the localhost.This restore will work via the gui but I\'m having issues restoring it with powershell.I get the foll[详细]
2023-02-13 18:00 分类：问答Failure to create a SQL Azure login with SMO
The following piece of code works with regular SQL and SMO. I\'m trying to get it to work with SQL Azure. According to this MSDN article, a limited subset of functionality that I need (database and lo[详细]
2023-02-10 17:51 分类：问答SQL Server SMO on IIS with Windows Auth
I\'m getting a strange error when I enable windows authentication on IIS and try to run some database update scripts:[详细]
2023-02-07 15:05 分类：问答Job.EnumHistory returns wrong information about job duration using SQL Server Management Objects
I am doing some reporting on SQL Server jobs, using SQL Server Management Objects (SMO). This is the test-job:[详细]
2023-02-07 01:26 分类：问答
![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif)
加载中,请稍侯......