February 3, 2012 at 3:20 am
Hello,
I am using SQL Server 2008R2 SP1 and have a problem when it comes to getting SSMS to script certain tables.
If I right-click on a table within SSMS and then point to "Script table as .." and then point to "CREATE To .." and then select "New Query Editor Window" the following error message appears.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Script failed for Table 'Archive.Results'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Script+Table&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Column Finish_Time in object Results contains type Time, which is not supported in the target server version, SQL Server 2005. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0026+)&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I have apparently noticed that this error only seems to occur when I try to script any table that contains any of the new SS2008 data types like DATE or TIME. If I run this option on tables that do not contain such types there's no problem.
February 3, 2012 at 3:30 am
raotor (2/3/2012)
Hello,I am using SQL Server 2008R2 SP1 and have a problem when it comes to getting SSMS to script certain tables.
If I right-click on a table within SSMS and then point to "Script table as .." and then point to "CREATE To .." and then select "New Query Editor Window" the following error message appears.
So the server is 2008R2(?), what version is the management studio that you're using to connect to it?
February 3, 2012 at 4:08 am
Cadavre (2/3/2012)
raotor (2/3/2012)
Hello,I am using SQL Server 2008R2 SP1 and have a problem when it comes to getting SSMS to script certain tables.
If I right-click on a table within SSMS and then point to "Script table as .." and then point to "CREATE To .." and then select "New Query Editor Window" the following error message appears.
So the server is 2008R2(?), what version is the management studio that you're using to connect to it?
Selecting the Help/About option from within SSMS I have the following version displauyed for SSMS:
Microsoft SQL Server Management Studio 10.50.2500.0
February 3, 2012 at 4:27 am
I think the problem lies in:
"Column Finish_Time in object Results contains type Time, which is not supported in the target server version, SQL Server 2005"
Try to install SSMS 2008 in your workstation.
February 3, 2012 at 5:11 am
jcb (2/3/2012)
I think the problem lies in:"Column Finish_Time in object Results contains type Time, which is not supported in the target server version, SQL Server 2005"
Try to install SSMS 2008 in your workstation.
I thought that my SSMS version (10.50 ...) was that which was shipped with SS2008R2 as it share the same version number.
I did previously have an SS2005 installation, but I uninstalled everything and did a fresh installation of SS2008R2.
How would I install just the SSMS component of my SS2008R2 Developers Edition?
February 3, 2012 at 5:48 am
If you migrated from a 2005 enviroment maybe something is still missing.
I tryed to set compability level and
Tools > Options > SQL Server Object Explorer > Scripting for server 2005 option
ALTER DATABASE XXX
SET COMPATIBILITY_LEVEL = 90
GO
create table teste (test time)
GO
drop table teste
GO
But I cannot reproduce the error.
Since my is a fresh from scratch 2008 enviroment maybe I cannot reproduce it at all.
February 3, 2012 at 6:11 am
jcb (2/3/2012)
If you migrated from a 2005 enviroment maybe something is still missing.I tryed to set compability level and
Tools > Options > SQL Server Object Explorer > Scripting for server 2005 option
ALTER DATABASE XXX
SET COMPATIBILITY_LEVEL = 90
GO
create table teste (test time)
GO
drop table teste
GO
But I cannot reproduce the error.
Since my is a fresh from scratch 2008 enviroment maybe I cannot reproduce it at all.
Hmmmm .. It does seem that something was left over from my SS2005 installation despite me uninstalling everything. The problem with a lot of Microsoft - and others for that matter - software is that you never get a completely clean uninstall and there's often something left behind.
Well, thans very much for trying this out for me. At least I know that there isn't an inherent problem with SS2008R2.
February 7, 2012 at 11:59 am
I had the same issue, and was able to fix it by going to the Tools menu, select Options and when the Dialog box appears, expand the SQL Server Object Explorer item, then select Scripting, and you will see an option called "Script for server version" and you can change that to SQL Server 2008.
Mine was set at SQL Server 2005, I guess as a leftover from migrating from 2005 to 2008.
February 7, 2012 at 2:37 pm
klowman (2/7/2012)
I had the same issue, and was able to fix it by going to the Tools menu, select Options and when the Dialog box appears, expand the SQL Server Object Explorer item, then select Scripting, and you will see an option called "Script for server version" and you can change that to SQL Server 2008.Mine was set at SQL Server 2005, I guess as a leftover from migrating from 2005 to 2008.
Bingo!! 🙂
That was it! You're kind help has fixed this issue and I'm very grateful, thank you.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply