Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

User error trying to "Alter to" in 2008 R2 SSMS Expand / Collapse
Author
Message
Posted Monday, October 22, 2012 3:42 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, August 18, 2014 10:21 AM
Points: 743, Visits: 291
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
Posted Tuesday, October 23, 2012 1:24 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Monday, August 18, 2014 10:21 AM
Points: 743, Visits: 291
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 »

Add to briefcase

Permissions Expand / Collapse