User error trying to "Alter to" in 2008 R2 SSMS

  • A developer with Management Studio gets the attached error when trying to generate the "script table as" --> "Create to" or "Alter to" choice. I am able to do so with no issues. The server he is attached to is 2008 R2. Double-checked his SSMS is 2008 R2. We both have old copies of 2005 SSMS. I'm an SA, he is dbo.

    The error states that Date is invalid on 2005 target which doesn't make sense. Any idea of why this is failing for him and not me? See attachment for exact error popup.

    Thanks!

  • Solved it myself.

    Options; SQL Server object Explorer; Scripting; Script for server version: SQL Server 2008 R2.

    The other fellow had it set to SQL Server 2005

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply