Hi,

I have a SQL 2008 DB I'm try to Publish as a SQL 2005 DB with the Database
Publishing Wizard Tool.

It gets all the objects OK... but scripting Objects step fails.

Error: [dbo].[Classify], column "DatePosted" is of type [None]. This type is
not supported.

I examine the table Classify and column "DatePosted" is of type date.

How such I handle this? Or what type should I use?

King

There is no Date type for SQL-Server 2005, only the DateTime (Date + Time)
and the ShortDateTime. I would say that you will have to convert the Date
type to either one of these two possibilities.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"King Coffee" <kcoffee (AT) hotmail (DOT) com> wrote

Hi Sylvain... I think you meant SmallDateTime.

King... SQL 2008 allows Date, Time and several other date and time
variations for your data types.

--
HTH
Kalen
----------------------------------------
Kalen Delaney
SQL Server MVP
www.SQLServerInternals.com

"Sylvain Lafontaine" <sylvainlafontaine2009 (AT) yahoo (DOT) ca> wrote

King Coffee (kcoffee (AT) hotmail (DOT) com) writes:
So you have developed a database in SQL 2008, and now you want to script
it to create it on SQL 2005?

The date data type was introduced in SQL 2008, and is not available in
SQL 2005. So if you need your database to be running on SQL 2005, you need
to change to the datetime data type. This data type always includes a time
portion, but for dates the time portion should always be midnight.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx