I\'m picking up a support call on a legacy piece of software. It has the following imports: using Microsoft.SqlServer.Management.Smo;
Using a source script component in SSIS, I am attempting to retreive details of all objec开发者_运维百科ts which depend on a table. So far, I have the object type and name but can\'t retreive the sche
I would appreciate some advice on the best method of managing multiple SQL connections .net (VB) My application connects to four instances of SQL Server (2000, 2005, 2008, 2008R2) restoring databases
for that past couple of weeks I have been creating generic script that is able to copy databases. The goal is to be able to specify any database on some server and copy it to some other location, and
I am interating through a list of Microsoft.SqlServer.Management.Smo.Server objects and adding them to a hashtable like so:
I have a powershell script to iterate through a list of LinkedServer objects in a SQL Server with some code like this:
How I can restore the database from another database ? When i do from file restore i do like this: Restore sqlRestore = new Restore();
I have a bak file that has in it a back up of a database . I want to restore this database to a new location and I need to retrieve the database name from this file any idea how to do so ?
I\'m trying to find a way to have the SQL Server \'SQL Agent\' run a particular piece of 开发者_JS百科code on job step events. I had hoped that there was a way using SMO to register a callback method
I am working with Server object fromMicrosoft.SqlServer.Management.Smo namespace. How i can check that it connected successfully to the server i couldnt see there any property related to it .
加载中,请稍侯......