SQL Server Management Objects (SMO) are .NET objects for management of Microsoft SQL Server.
Can anybody explain me what I wrong I am doing in the following piece of code: DataTable dt=SmoApplication.EnumAvailableSqlServer(…
c# .net sql-server smoI use SQL Server SMO to restore a .bak to a new database, but failed to work. sql server is 2012 …
c# sql-server sql-server-2012 smoI am using Microsoft.SqlServer.Management.Smo. My Code: Server server = new Server(new ServerConnection( new SqlConnection(ConnectionString)); server.ConnectionContext.…
c# smo sqlcommand command-timeoutI am trying to return the physical file path of a database's mdf/ldf files. I have tried using the …
sql-server smoI'm picking up a support call on a legacy piece of software. It has the following imports: using Microsoft.SqlServer.…
c# sql-server visual-studio smoI need to perform a database restore from my application. Before doing this, I want to kill all processes as …
sql-server smoI would like to automate script generation (in SSMS --> Tasks --> Generate Scripts) in SSMS 2008. I have …
sql-server sql-server-2008 powershell automation smoMy database has tables, views and all. And I need a way to generate SQL script for all the DDL …
sql-server powershell smoI have an application which performs backups and restores of SQL databases, this works fine on the local machine, however …
c# sql smoTaking a database backup from another server I'm trying to restore to sqlexpress on the localhost. This restore will work …
sql sql-server powershell restore smo