In the fourth level of this series, we will examine how you can use the scripting classes to create the code to manage your SQL Server instances and databases.
2024-01-20 (first published: 2023-12-13)
1,803 reads
This stairway series tries to help the reader become comfortable with server management objects (SMO). These objects are a programmatic way of accessing SQL Server functions and objects through an API from .NET. This series will help you learn the basics with practical applications for your work.
2024-01-20 (first published: 2023-11-30)
1,298 reads
2018-05-15
753 reads
2017-02-14
946 reads
Learn how to get started working with SMO and PowerShell.
2024-01-20 (first published: 2016-05-11)
13,682 reads
Generate Script All Table and Specific Table By Using SMO C#
2014-09-01 (first published: 2014-08-07)
5,668 reads
SMO can be a valuable tool for working with SQL Server when you don't have access to all the tools that come with the platform. In this article, SMO helps solve an issue with a SQL Server.
2012-07-26
701 reads
In this tip, I am going to show you how you can use SMO (SQL Server Management Objects) classes to transfer database objects and data to another server or database.
2010-01-06
3,931 reads
In this tip, I am going to discuss how you can get started with SMO and how you can programmatically manage a SQL Server instance with your choice of programming language.
2009-09-04
3,737 reads
SQL Management Objects(SMO)can be used for customized automation of various database.This article gives an implementation for SMO using C#.
2008-06-18
5,522 reads
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Setting page visibility and the active page are often overlooked last steps when publishing...
Comments posted to this topic are about the item Password Guidance
Comments posted to this topic are about the item Using table variables in T-SQL
I am trying to check out elastic query between two test instances we have...
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers