Browse by Tags

Tagged Content List
  • Blog Post: 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 pick up the information...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 Service...
Page 1 of 1 (4 items)