Erro creating procedure oneligne ok two ligne errors!!

• Robert Klimes

  SSCoach

  Points: 17865

  More actions

  May 7, 2013 at 12:35 pm

  #1613116

  try using dynamic sql for your alter query

  declare @sql nvarchar(max)

  set @sql = 'ALTER DATABASE '+@TableName+' SET SINGLE_USER WITH ROLLBACK IMMEDIATE;'

  exec sp_executesql @sql;

  Bob
  -----------------------------------------------------------------------------
  How to post to get the best help[/url]