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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » User error trying to "Alter to" in 2008 R2...

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

Rate Topic

Display Mode

Topic Options

Author

Message

MisplacedChildhood

Posted Monday, October 22, 2012 3:42 PM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 1:58 PM
Points: 743, Visits: 286

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!

Post Attachments

SSMS_popup.jpg (5 views, 24.66 KB)

Post #1375756

MisplacedChildhood

Posted Tuesday, October 23, 2012 1:24 PM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 1:58 PM
Points: 743, Visits: 286

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

Post #1376218

« Prev Topic | Next Topic »

Permissions