GoDaddy Website Builder for $1/Mo.!

Adbrite

Tuesday, June 24, 2008

Minimum year value in SQL server 2008(date data type)

Minimum year value in SQL server 2008(date data type)

SQL server 2008 comes with lots of new features and they separated SQL server datetime data type as Date and Time (datetime data type also available).SQL server previous versions (SQL 2000, SQL 2005) there is limit for min date (year-1753) and max date (year-9999). But when you notice SQL server 2008 date data type min date is 0001.



/*
Date 24/06/2008
SQL SERVER 2000 and 2005
*/
DROP TABLE dateCheck;
CREATE TABLE dateCheck(dateCol datetime);
GO
--can
INSERT INTO dateCheck(dateCol) VALUES ('12/31/1753')
GO
--can't
INSERT INTO dateCheck(dateCol) VALUES ('01/01/1752')
GO
SELECT * FROM dateCheck
GO

/*
Date 24/06/2008
SQL SERVER 2008
*/
--datetime data type
DROP TABLE dateCheckDateTime;
CREATE TABLE dateCheck(dateCol datetime);
GO
--can
INSERT INTO dateCheck(dateCol) VALUES ('12/31/1753');
--can't
INSERT INTO dateCheck(dateCol) VALUES ('01/01/1752');
GO
SELECT * FROM dateCheck;
GO
--date data type
DROP TABLE dateCheckDate;
CREATE TABLE dateCheckDate(dateCol date);
GO
--can
INSERT INTO dateCheckDate(dateCol) VALUES ('01/01/1753');
INSERT INTO dateCheckDate(dateCol) VALUES ('01/01/1752');
INSERT INTO dateCheckDate(dateCol) VALUES ('01/01/0001');
GO
SELECT * FROM dateCheckDate;
GO

SQL SERVER 2005 - MSXML6 SETUP Fail

SQL SERVER 2005 - MSXML6 SETUP Fail

MSXML6 is the latest MSXML product from Microsoft, and is contain with SQL Server 2005, Visual Studio 2005, .NET Framework (3.0,3.5) , Windows Vista and Windows XP Service Pack 3.When you going to install SQL server 2005, some certain situation you can notice MSXML6 setup fail to install and all setup program will be fail. And when you going to run individual setup files, under SQL server 2005 setup folder (“\ Tools\Setup\msxml6.msi”) it will gives you following error “The system administrator has set policies to prevent this installation”

MS says about this http://support.microsoft.com/kb/928469







Solution;

1)Go to add remove programs and remove MSXML 6.0 Parser if available
2)Then removing few registry values you can sort out this problem.
HKEY_CLASSES_ROOT\Installer\Products\
Go to above path and check product name call “MSXML 6.0 Parser” and remove all the related values and reinstall SQL server 2005 setup.
Related links,
http://blogs.msdn.com/quanto/archive/2005/06/29/434136.aspx