smo

相关标签：javascript jquery android 多少钱 iPhone

Microsoft.SqlServer.Management.Smo Namespace - what do I need to install to resolve it?

I\'m picking up a support call on a legacy piece of software. It has the following imports: using Microsoft.SqlServer.Management.Smo;[详细]

2023-02-06 05:39 分类：问答
Get schema name for dependent objects with 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[详细]

2023-02-04 02:48 分类：问答
Advice on connecting to multiple SQL Instances .NET to SQL Server

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[详细]

2023-02-02 11:41 分类：问答
SqlBulkCopy is slow, doesn't utilize full network speed

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[详细]

2023-01-30 15:16 分类：问答
How to append to powershell Hashtable value?

I am interating through a list of Microsoft.SqlServer.Management.Smo.Server objects and adding them to a hashtable like so:[详细]

2023-01-29 10:00 分类：问答
Accessing LinkedServer properties via SQL Server SMO API

I have a powershell script to iterate through a list of LinkedServer objects in a SQL Server with some code like this:[详细]

2023-01-28 03:52 分类：问答
Restoring database from another database SMO

How I can restore the database from another database ? When i do from file restore i do like this: Restore sqlRestore = new Restore();[详细]

2023-01-25 11:39 分类：问答
Retrieving database name from bak file

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 ?[详细]

2023-01-25 04:31 分类：问答
Get SQL Agent job status without polling?

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[详细]

2023-01-24 18:36 分类：问答
Checking that Server object connected

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 .[详细]

2023-01-24 07:01 分类：问答