difference between SQL standard Edition and Enterprise Edition

Hi, there,

We are running SQL 2000 & SP4 with our ASP.NET application, now we plan to upgrade to Enterprise Edition due to the huge diffirence in price. Can any one of u give an brief introduction of the difference between these two, and what is the advantages of enterprise edition?

Any suggestion will greately appreciated.

Shermaine

There's a good comparison of the various versions of SQL Server here:-

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

|||

shermaine wrote:

now we plan to upgrade to Enterprise Edition due to the huge diffirence in price.

That seems logical.

Difference between sql 6.5 and 7.0

Hi,
I have a sql server 7.0 with some databases with
compatibility level 6.5.
I want to "upgrade" those databases to compatibility level
7.0. What kind of problems should i expect ?
My developers are asking me for some document with the
programming differences between 6.5 and 7.0, something
that works fine in 6.5 but doesn't work in 7.0.
Thanks,
JCI think that there are about 90 pages in SQL Server 7.0 Books Online about compatibility issues
between 6.5 and 7.0. This is the place for your developers.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Julio Carvalho" <jc.carvalho@.terra.com.br> wrote in message
news:0d7501c3664e$cb490b70$a301280a@.phx.gbl...
> Hi,
> I have a sql server 7.0 with some databases with
> compatibility level 6.5.
> I want to "upgrade" those databases to compatibility level
> 7.0. What kind of problems should i expect ?
> My developers are asking me for some document with the
> programming differences between 6.5 and 7.0, something
> that works fine in 6.5 but doesn't work in 7.0.
> Thanks,
> JC|||Of course, the 90 pages covers lots of issues that don't apply in this case
since the database is already in SQL Server 7.0. The issues of importance
are those covered by sp_dbcmptlevel 65, and it's a pretty small list, though
it could be a lot of work to address the issues in some applications. Books
Online is definitely the place to go for this information.
--
Hal Berenson, SQL Server MVP
True Mountain Group LLC
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:%23v4dzMlZDHA.388@.TK2MSFTNGP10.phx.gbl...
> I think that there are about 90 pages in SQL Server 7.0 Books Online about
compatibility issues
> between 6.5 and 7.0. This is the place for your developers.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
> "Julio Carvalho" <jc.carvalho@.terra.com.br> wrote in message
> news:0d7501c3664e$cb490b70$a301280a@.phx.gbl...
> > Hi,
> >
> > I have a sql server 7.0 with some databases with
> > compatibility level 6.5.
> >
> > I want to "upgrade" those databases to compatibility level
> > 7.0. What kind of problems should i expect ?
> >
> > My developers are asking me for some document with the
> > programming differences between 6.5 and 7.0, something
> > that works fine in 6.5 but doesn't work in 7.0.
> >
> > Thanks,
> >
> > JC
>|||Ahh, thanks for catching that, Hal. Somewhere I missed the fact that it was already on 7.0...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Hal Berenson" <haroldb@.truemountainconsulting.com> wrote in message
news:%23kTObZtZDHA.1492@.TK2MSFTNGP12.phx.gbl...
> Of course, the 90 pages covers lots of issues that don't apply in this case
> since the database is already in SQL Server 7.0. The issues of importance
> are those covered by sp_dbcmptlevel 65, and it's a pretty small list, though
> it could be a lot of work to address the issues in some applications. Books
> Online is definitely the place to go for this information.
> --
> Hal Berenson, SQL Server MVP
> True Mountain Group LLC
>
> "Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
> wrote in message news:%23v4dzMlZDHA.388@.TK2MSFTNGP10.phx.gbl...
> > I think that there are about 90 pages in SQL Server 7.0 Books Online about
> compatibility issues
> > between 6.5 and 7.0. This is the place for your developers.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at: http://groups.google.com/groups?oi=djq&as
> ugroup=microsoft.public.sqlserver
> >
> >
> > "Julio Carvalho" <jc.carvalho@.terra.com.br> wrote in message
> > news:0d7501c3664e$cb490b70$a301280a@.phx.gbl...
> > > Hi,
> > >
> > > I have a sql server 7.0 with some databases with
> > > compatibility level 6.5.
> > >
> > > I want to "upgrade" those databases to compatibility level
> > > 7.0. What kind of problems should i expect ?
> > >
> > > My developers are asking me for some document with the
> > > programming differences between 6.5 and 7.0, something
> > > that works fine in 6.5 but doesn't work in 7.0.
> > >
> > > Thanks,
> > >
> > > JC
> >
> >
>sql

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
ShermaineHi
A list of features is at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
The higher spec hardware support is at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
John
"xiaomei" wrote:
> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterprise
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine|||Also know that if you are running Windows XP you cannot install enterprise
edition
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1|||Dear John,
Thanks so much.
Have a nice day!
Shermaine
"John Bell" wrote:
> Hi
> A list of features is at:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_1cdv.asp
> The higher spec hardware support is at:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp
> John
>
> "xiaomei" wrote:
> > Hi, there,
> > I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> > with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> > to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> > any one of u tell me the difference between standard Edition and Enterprise
> > Edition due to there is a huge difference in price.
> >
> > Thanks in advanced
> >
> > Rgds
> > Shermaine|||Hi, thanks a lot.
Yes, we will run on windows 2000 server.
BTW, Does Microsoft still provide evaluation copy download for Windows SQL
2000 Enterprise Edition?
Thanks
Shermaine
"Prospero via SQLMonster.com" wrote:
> Also know that if you are running Windows XP you cannot install enterprise
> edition
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
>|||Hi
An evaluation copy would only be needed if you are going to use the
additional features. I would not load this into a live environment. An
alternative might be to use the developer edition in your test environment,
if this is for stress testing then you should use similar hardware to the
live environment.
John
"xiaomei" wrote:
> Hi, thanks a lot.
> Yes, we will run on windows 2000 server.
> BTW, Does Microsoft still provide evaluation copy download for Windows SQL
> 2000 Enterprise Edition?
> Thanks
> Shermaine
> "Prospero via SQLMonster.com" wrote:
> > Also know that if you are running Windows XP you cannot install enterprise
> > edition
> >
> > --
> > Message posted via SQLMonster.com
> > http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200601/1
> >

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't wan
t
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
ShermaineHi
A list of features is at:
http://msdn.microsoft.com/library/d...br />
1cdv.asp
The higher spec hardware support is at:
http://msdn.microsoft.com/library/d...br />
8dbn.asp
John
"xiaomei" wrote:

> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't w
ant
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterpris
e
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine|||Also know that if you are running Windows XP you cannot install enterprise
edition
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200601/1

difference between sql 2000 standard Edition and Enterprise Editio

Hi, there,
I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
to upgrade to 2005 Eterprise Edition immediately due to other reason), can
any one of u tell me the difference between standard Edition and Enterprise
Edition due to there is a huge difference in price.
Thanks in advanced
Rgds
Shermaine
Hi
A list of features is at:
http://msdn.microsoft.com/library/de...ar_ts_1cdv.asp
The higher spec hardware support is at:
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp
John
"xiaomei" wrote:

> Hi, there,
> I hv a few question on SQL 2000 server: Currently we are runing SQL 2000
> with SP4, now we want upgrade to SQL 2000 Enterprise Edition. ( We Don't want
> to upgrade to 2005 Eterprise Edition immediately due to other reason), can
> any one of u tell me the difference between standard Edition and Enterprise
> Edition due to there is a huge difference in price.
> Thanks in advanced
> Rgds
> Shermaine
|||Also know that if you are running Windows XP you cannot install enterprise
edition
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...erver/200601/1

Difference between Attach / Detach and Backup / Restore

I am new to SQL Server and we are using SQL Server 2005.
We recently upgrade a finance system by consultant. He detaches the
database from the old server (Running SQL Server 2000), copy the mdf file
across and attached in the new SQL Server 2005.
I would like to know is there any benefit for detaching / attaching than
make a backup and restore on the SQL Server 2005 ?
Someone has mentioned that we have to recreate SQL Server Login though the
Database Login exists on the database copied across. Is there any tools /
reference that makes it easy ?
ThanksPeter
It is just faster.
Search on interenet for 'sp_help_revlogin' for SQL Server 2005
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OZmOrl6wHHA.600@.TK2MSFTNGP05.phx.gbl...
>I am new to SQL Server and we are using SQL Server 2005.
> We recently upgrade a finance system by consultant. He detaches the
> database from the old server (Running SQL Server 2000), copy the mdf file
> across and attached in the new SQL Server 2005.
> I would like to know is there any benefit for detaching / attaching than
> make a backup and restore on the SQL Server 2005 ?
> Someone has mentioned that we have to recreate SQL Server Login though the
> Database Login exists on the database copied across. Is there any tools /
> reference that makes it easy ?
> Thanks
>|||I have explained the step to move the logins as well here:
http://sqlguy.it-craft.dk
As well as links to the stored procedures for both 2000 and 2005
Regards
Rasmus Glibstrup
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OZmOrl6wHHA.600@.TK2MSFTNGP05.phx.gbl...
>I am new to SQL Server and we are using SQL Server 2005.
> We recently upgrade a finance system by consultant. He detaches the
> database from the old server (Running SQL Server 2000), copy the mdf file
> across and attached in the new SQL Server 2005.
> I would like to know is there any benefit for detaching / attaching than
> make a backup and restore on the SQL Server 2005 ?
> Someone has mentioned that we have to recreate SQL Server Login though the
> Database Login exists on the database copied across. Is there any tools /
> reference that makes it easy ?
> Thanks
>sql

Difference between Attach / Detach and Backup / Restore

I am new to SQL Server and we are using SQL Server 2005.
We recently upgrade a finance system by consultant. He detaches the
database from the old server (Running SQL Server 2000), copy the mdf file
across and attached in the new SQL Server 2005.
I would like to know is there any benefit for detaching / attaching than
make a backup and restore on the SQL Server 2005 ?
Someone has mentioned that we have to recreate SQL Server Login though the
Database Login exists on the database copied across. Is there any tools /
reference that makes it easy ?
ThanksPeter
It is just faster.
Search on interenet for 'sp_help_revlogin' for SQL Server 2005
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OZmOrl6wHHA.600@.TK2MSFTNGP05.phx.gbl...
>I am new to SQL Server and we are using SQL Server 2005.
> We recently upgrade a finance system by consultant. He detaches the
> database from the old server (Running SQL Server 2000), copy the mdf file
> across and attached in the new SQL Server 2005.
> I would like to know is there any benefit for detaching / attaching than
> make a backup and restore on the SQL Server 2005 ?
> Someone has mentioned that we have to recreate SQL Server Login though the
> Database Login exists on the database copied across. Is there any tools /
> reference that makes it easy ?
> Thanks
>|||I have explained the step to move the logins as well here:
http://sqlguy.it-craft.dk
As well as links to the stored procedures for both 2000 and 2005
Regards
Rasmus Glibstrup
"Peter" <Peter@.discussions.microsoft.com> wrote in message
news:OZmOrl6wHHA.600@.TK2MSFTNGP05.phx.gbl...
>I am new to SQL Server and we are using SQL Server 2005.
> We recently upgrade a finance system by consultant. He detaches the
> database from the old server (Running SQL Server 2000), copy the mdf file
> across and attached in the new SQL Server 2005.
> I would like to know is there any benefit for detaching / attaching than
> make a backup and restore on the SQL Server 2005 ?
> Someone has mentioned that we have to recreate SQL Server Login though the
> Database Login exists on the database copied across. Is there any tools /
> reference that makes it easy ?
> Thanks
>

did something go wrong?

I did an upgrade of a site system, computers and servers from NT4 server and
workstation to Win2K server and XP workstations. I made a backup of the
datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
change DB owner and then preformed another backup from the PDC to move to the
BDC.
The first backup was 2.2gig in size but when I did the backup from the new
SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
wrong.
Thanks,
Ed
Hi
Do a complete index rebuild and an update statistics.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"raider2" wrote:

> I did an upgrade of a site system, computers and servers from NT4 server and
> workstation to Win2K server and XP workstations. I made a backup of the
> datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
> change DB owner and then preformed another backup from the PDC to move to the
> BDC.
> The first backup was 2.2gig in size but when I did the backup from the new
> SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
> wrong.
> Thanks,
> Ed
>

did something go wrong?

I did an upgrade of a site system, computers and servers from NT4 server and
workstation to Win2K server and XP workstations. I made a backup of the
datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
change DB owner and then preformed another backup from the PDC to move to th
e
BDC.
The first backup was 2.2gig in size but when I did the backup from the new
SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
wrong.
Thanks,
EdHi
Do a complete index rebuild and an update statistics.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"raider2" wrote:

> I did an upgrade of a site system, computers and servers from NT4 server a
nd
> workstation to Win2K server and XP workstations. I made a backup of the
> datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
> change DB owner and then preformed another backup from the PDC to move to
the
> BDC.
> The first backup was 2.2gig in size but when I did the backup from the new
> SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
> wrong.
> Thanks,
> Ed
>

did something go wrong?

I did an upgrade of a site system, computers and servers from NT4 server and
workstation to Win2K server and XP workstations. I made a backup of the
datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
change DB owner and then preformed another backup from the PDC to move to the
BDC.
The first backup was 2.2gig in size but when I did the backup from the new
SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
wrong.
Thanks,
EdHi
Do a complete index rebuild and an update statistics.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"raider2" wrote:
> I did an upgrade of a site system, computers and servers from NT4 server and
> workstation to Win2K server and XP workstations. I made a backup of the
> datatbase (SQL7) and did a restore on the new PDC (SQL2K server). Did a
> change DB owner and then preformed another backup from the PDC to move to the
> BDC.
> The first backup was 2.2gig in size but when I did the backup from the new
> SQL2K DB the backup file was 5.5gig. does anyone know what I may have done
> wrong.
> Thanks,
> Ed
>

Device activation error

Hello,
I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before
removing MSDE 1.0, a database apparently was not properly detached after
attempting to attach (using sp_attach_db not attach w/ single file) this very
database to MSDE 2000.
The following error is rec'd:
"Can not create file C:\Program Files...\MyData.LDF because it already
exists.
Could not open new database "MyData". CREATE DATABASE is aborted.
Device activation error. The physical file name "C:\MSSQL7\Data\MyData.LDF
may be incorrect."
Should I attempt to place the log file back to its old location, restore the
database and then detach or should I try to shrink the file and truncate the
log?
Just want to know before I further screw things up.
any help is appreciated.
Hello,
If you have the latest backup then RESTORE the DATABASe using RESTORE
DATABASE WITH MOVE options..Try restoring using a new name and make sure
that
dataBase backup is good.
Thanks
Hari
"jim" <jim@.discussions.microsoft.com> wrote in message
news:F3BE2646-3666-40C7-AF83-763ED47957B2@.microsoft.com...
> Hello,
> I'm attempting to upgrade from MSDE 1.0 to MSDE 2000. However, before
> removing MSDE 1.0, a database apparently was not properly detached after
> attempting to attach (using sp_attach_db not attach w/ single file) this
> very
> database to MSDE 2000.
> The following error is rec'd:
> "Can not create file C:\Program Files...\MyData.LDF because it already
> exists.
> Could not open new database "MyData". CREATE DATABASE is aborted.
> Device activation error. The physical file name "C:\MSSQL7\Data\MyData.LDF
> may be incorrect."
> Should I attempt to place the log file back to its old location, restore
> the
> database and then detach or should I try to shrink the file and truncate
> the
> log?
> Just want to know before I further screw things up.
> any help is appreciated.
>
|||Hi Hari,
Thanks for the response. I just have one more question. With the new
database name, does this mean that the existing database name can no longer
be used on this computer? Or, once the database is restored, I can detach the
database w/ the new database name and then attach the database w/ the old
name in the new location? Hopefully, this question isn't too silly.
your help is appreciated.
"Hari Prasad" wrote:

> Hello,
> If you have the latest backup then RESTORE the DATABASe using RESTORE
> DATABASE WITH MOVE options..Try restoring using a new name and make sure
> that
> dataBase backup is good.
> Thanks
> Hari
> "jim" <jim@.discussions.microsoft.com> wrote in message
> news:F3BE2646-3666-40C7-AF83-763ED47957B2@.microsoft.com...
>
>

Developer edition 2005 upgrade to standard 2005?

We are trying to transisiton our network to sql server 2005... however
havent received our media kit yet for sql server 2005 and probably wont for
a while going by their transit times... we already have the license for sql
server 2005 standard edition but need to get this server up and running
soon! is there any way to install our developer edition copy or install the
trial edition then later "upgrade" to the standard edition license? thanks!Unless it has changed (which I doubt) it is not possible to upgrade from
developer to a licensed edition. You will need to uninstall and reinstall.
Andrew J. Kelly SQL MVP
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||The following article will help when the time comes to move the databases to
the new server instance.
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/kb/224071
"Brian Henry" <nospam@.nospam.com> wrote in message
news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
> We are trying to transisiton our network to sql server 2005... however
> havent received our media kit yet for sql server 2005 and probably wont
> for a while going by their transit times... we already have the license
> for sql server 2005 standard edition but need to get this server up and
> running soon! is there any way to install our developer edition copy or
> install the trial edition then later "upgrade" to the standard edition
> license? thanks!
>|||SQL2005 BOL at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860c-
a95a802898a1.htm
indicates that SQL Server 2005 Developer edition to SQL2005 Standard edition
is one of the supported paths.
But I have not tried to do an in-place upgrade from Dev to Standard.
Linchi
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
> Unless it has changed (which I doubt) it is not possible to upgrade from
> developer to a licensed edition. You will need to uninstall and reinstall.
> --
> Andrew J. Kelly SQL MVP
>
> "Brian Henry" <nospam@.nospam.com> wrote in message
> news:OLz%23rGCLGHA.720@.TK2MSFTNGP14.phx.gbl...
>|||You learn something new every day<g>. Back when 2000 just came out in RTM I
was told by a MS employee that this was not possible and never had a reason
to doubt it. I too would like to actually see it done successfully but it
appears it is possible. Thanks Linchi and sorry Brian.
Andrew J. Kelly SQL MVP
"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
> SQL2005 BOL at
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860
c-a95a802898a1.htm
> indicates that SQL Server 2005 Developer edition to SQL2005 Standard
> edition is one of the supported paths.
> But I have not tried to do an in-place upgrade from Dev to Standard.
> Linchi
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eGDoZ$CLGHA.360@.TK2MSFTNGP12.phx.gbl...
>|||thanks everyone
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OCWCcvXLGHA.3732@.TK2MSFTNGP10.phx.gbl...
> You learn something new every day<g>. Back when 2000 just came out in RTM
> I was told by a MS employee that this was not possible and never had a
> reason to doubt it. I too would like to actually see it done successfully
> but it appears it is possible. Thanks Linchi and sorry Brian.
> --
> Andrew J. Kelly SQL MVP
>
> "Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
> news:eY$dIUSLGHA.1124@.TK2MSFTNGP10.phx.gbl...
>