Deprecated feature 'Table hint without WITH' is not supported in this version of SQL Server. RSS

• • Reply
  

  bhanu2217

  Member

  527 Points

  458 Posts

  Deprecated feature 'Table hint without WITH' is not supported in this version of SQL Server.

  Apr 22, 2012 07:04 AM|LINK

  I am trying to migrate my ASP.NET application on SQL Server 2008(ASP.NET Membership/Security)

  I tried SQL Azure Migration Wizard v3.8.6 and also http://msdn.microsoft.com/en-us/library/ee621790.aspx

  Script generated by both these processes gives following error

  Msg 40512, Level 16, State 1, Procedure aspnet_Membership_GetNumberOfUsersOnline, Line 13
  Deprecated feature 'Table hint without WITH' is not supported in this version of SQL Server.

  Windows 8 Professional 64 Bit.
  Visual Studio 2012
  Sql Server 2012
  -------------------------------------
  www.HermesWritings.com
  • Edited by bhanu2217 on Apr 22, 2012 07:19 AM
• • Reply
  

  bhanu2217

  Member

  527 Points

  458 Posts

  Re: Deprecated feature 'Table hint without WITH' is not supported in this version of SQL Server.

  Apr 22, 2012 07:12 AM|LINK

  Solution

  http://niftyandcrackerjack.com/migrate-ms-sql-with-asp-membership-to-sql-azure/

  Windows 8 Professional 64 Bit.
  Visual Studio 2012
  Sql Server 2012
  -------------------------------------
  www.HermesWritings.com
  • Edited by bhanu2217 on Apr 22, 2012 07:12 AM
  • Edited by bhanu2217 on Apr 22, 2012 07:15 AM
  • Edited by bhanu2217 on Apr 22, 2012 07:16 AM
  • Edited by bhanu2217 on Apr 22, 2012 08:08 AM
  • Marked as answer by bhanu2217 on Apr 22, 2012 08:08 AM