Browse by Tags

SMO Enumerations in Powershell
17 March 11 11:20 PM | MartinBell | 1 comment(s)
Sometimes and example is the quickest way to see how to do something. Unfortunately when you can find one it can make it very difficult to work out what to do. SMO enumerations was one example of this so when I worked out what to do I submitted the example to MSDN. This post shows the enumeration for a termination clause and a recoverymodel....
Filed under: ,
SMO doesn't always raise an error when handling login failures
17 January 11 09:28 AM | MartinBell | 2 comment(s)
SMO error handling is not consistent when it comes to login failures. This is not a good for a programming having to handle errors as patterns can't necessarily be used ....
Filed under:
Using Powershell to not script database collations for columns
19 November 10 10:10 PM | MartinBell | with no comments
When it comes to column collations SMO doesn't readily do what I want it to do, so I thought I could use the power of Powershell to overcome it!...
Filed under: , ,
Powershell and SQL Authentication
01 January 10 03:25 PM | MartinBell | 3 comment(s)
How much use is Powershell to a DBA when Windows Authentication is not available?...
Filed under: , ,
Powershell and SMO scripting – Part 3
22 August 09 05:04 PM | MartinBell | 3 comment(s)
In SQL Server 2008 Management Studio you can now script a table definition plus the data as INSERT statements, so how can you do that programatically with Powershell? In the third in my series of investigations I will look at how it can be done....
Filed under: , ,
Powershell and SMO scripting – Part 2
15 August 09 06:00 PM | MartinBell | 7 comment(s)
In the post I look further into using SMO and Powershell to script table constraints and indexes.....
Filed under: , ,
Powershell and SMO scripting – Part 1
13 August 09 09:18 PM | MartinBell | 2 comment(s)
One of the great things you can do with Powershell is that you can use the classes from SMO. ...
Filed under: , ,

This Blog

SQL Blogs