Script out jobs in SQL Server v2

  For those asking a couple of times if the JobScripter for SQL Server Agent jobs is also available in 2008… here it is ! The only difference is that the version v2 is now targeting to SMO Assemblies of SQL Server 2008 which is version 10.0. This sure means that you are able to…

4

Script out Jobs in SQL Server

Do you want to script out the jobs available in SQL Server Agent ? There a many ways to skin the cat. The probably easiest one is to us the built in functionality of SSMS. Simply select all the jobs (doing a STRG+A on the Object Explorer list) and choose Script. Script jobs separately (this…

12

Get all system databases of a server

The easiest way for querying all system databases of a server is to assume that databases create by a user come with a database_id >= 5 in sys.databases. But the problem is that distribution databsaes will not be kept into this consideration. Therefore SMO does the following behind the scenes (bioled down to the relevants facts)…

1

Changing the Login / Authentication Mode programmtically via SMO

Here are some instructions how to change the Login / authentication mode via Code. It just uses plain SMO capabilites:     After this you will have to make sure that the Service is restarted, if you want this to do via SMO look at the following sample. You need to know the ServiceName your…

2