Availability Groups require a Windows Failover Cluster:

http://msdn.microsoft.com/en-us/library/ff878487.aspx#SystemReqsForAOAG

As far as a step by step guide, take a look at this:

http://www.brentozar.com/archive/2011/07/how-set-up-sql-server-denali-availability-groups/[/url]

What are you aiming to accomplish with Availability Groups?

SQLnbe (8/20/2014)

Jim,

What I have...

One thought is to look at @@SERVERNAME. Maybe you could raise an error or something if it doesn't match the name of the dev box?

It is throwing the error trying to compare the first two characters of your varchar column to integer values. Try putting 18, 26, and 28 in single quotes.

CREATE TABLE...

While I don't have a workaround for your solution, the second error appears to be the most telling. It looks like SQL Server doesn't like the NVARCHAR to VARBINARY conversion.

In...

It's certainly not best practice, but the question was about variables in dynamic T-SQL. The link provided addresses injection. There is probably an entirely better way to accomplish the end...

When using dynamic T-SQL you need to concatenate the variables.

SET @sqlstring = 'UPDATE table SET column = ' + @variable

More here