Prev: using CLR that returns table
Next: Insert query using date as where condition
From: Mahen on 29 Nov 2009 18:54
On Nov 29, 10:38 pm, Erland Sommarskog <esq...(a)sommarskog.se> wrote:
> Mahen (m...(a)eim.ae) writes:
> > I am using SQL server 2008
>
> > The following command:
> > CREATE TABLE Table1 ( Column1 time(7) )
> > results in the following message:
> > Msg 2715, Level 16, State 7, Line 1
> > Column or parameter #1: Cannot find data type time.
>
> > Please help. Thank you
>
> Run this command:
>
>    SELECT @@version
>

Thank you. The result of the command as follows:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

How do I upgrade this to 2008 version? The version info for my
installation as follows:
Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).
080709-1414 )
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.
080413-0852)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 8.0.6001.18702
Microsoft .NET Framework 2.0.50727.3603
Operating System 5.1.2600
From: Erland Sommarskog on 30 Nov 2009 03:37
Mahen (mlux(a)eim.ae) writes:
> Thank you. The result of the command as follows:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
> Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation
> Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
>
> How do I upgrade this to 2008 version? The version info for my

A good start is to install Service Pack 4 of SQL 2000, this is required
for an upgrade. (You have the RTM version of SQL 2000 right now). Next
you get your hands of installation media for SQL 2008 and run the upgrade.
Or simply install a new instance. (But you should apply SP4 on your
SQL 2000 instance anyway.)


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
First  |  Prev  | 
Pages: 1 2
Prev: using CLR that returns table
Next: Insert query using date as where condition