Alter database in Entity Framework migration

Question

I want to enable broker for my database in an Entity Framework migration. I add a migration to my project and write this code in the Up method :

Sql("ALTER DATABASE current SET ENABLE_BROKER", true);

This code runs correctly for SQL Server 2014, but when I change my target database to SQL Server 2008 R2 Express, I get this error:

Incorrect syntax near the keyword 'current'

How do I change the code to run properly for all type of SQL Server instances?

David Browne - Microsoft · Accepted Answer · 2017-08-28 18:06:40Z

1

Before SQL 2012 you have to use the database name. Something like this batch:

declare @sql nvarchar(max) = N'ALTER DATABASE ['+db_name()+N'] SET ENABLE_BROKER;'
exec( @sql );

should work.

answered Aug 28, 2017 at 18:06

90.7k7 gold badges52 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1