SQL Server Compatability

[RoninZA]

Hi -

I need to set the compatability of a database on a SQL Server 2005 to "SQL Server 2005(90)" programmatically. Ideally I would like to use the SMO objects as I already have these objects looking at the database and doing things on it, but a T/SQL script should be fine as well.

Thanks!

[RoninZA]

OK, I figured it out. Reference Microsoft.SqlServer.Smo and Microsoft.SqlServer.SqlEnum

using Microsoft.SqlServer.Management.Smo;
using Microsoft.SqlServer.Management.Common;
.
.
Server server = new Server(new ServerConnection(Server, Username, Password).Connect());
Database database = new Database(server, connection.Database);
database.CompatibilityLevel = CompatibilityLevel.Version90;