attach 2005 db on 2000

I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
there any way to do this if I no longer have sql 2005 running? I detached
and saved the db, but I don't have 2005 running anywhere anymore.
Thanks, Andre
"Andre" <no@.spam.com> wrote in
news:#p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl:

> I have a sql 2005 beta 2 db that I need to move back to a sql 2000
> box. Is there any way to do this if I no longer have sql 2005
> running? I detached and saved the db, but I don't have 2005 running
> anywhere anymore.
Unfortunately, I do not think so. It's quite possible to attach a SQL
Server 2000 to SQL Server 2005, but as far as I know not the other way
around.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||Bummer, that's what I was afraid of. Thanks for the reply.
|||1. Create new database in SQL 2000
2. Genarete script from objtects on the SQL 2005
3. Execute this script on the SQL 2000
If you have data, use bcp utilities or DTS/SSIS to export and import.
Regards
Amish
|||"amish" <shahamishm@.gmail.com> wrote in news:1136273968.474136.28240
@.g44g2000cwa.googlegroups.com:

> 1. Create new database in SQL 2000
> 2. Genarete script from objtects on the SQL 2005
> 3. Execute this script on the SQL 2000
> If you have data, use bcp utilities or DTS/SSIS to export and import.
Of course, there are only one problem: There are no SQL Server 2005
instance, so there is nowhere to create the scripts As far as I remember
from the original post, the situation is that he has a database detached
from SQL Server 2005, but no SQL Server 2005 instance.
He can install one though...
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||That they have to manage.
Regards
Amish
|||No. The internal bits are different. You can not attach a 2005 database to
2000.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Andre" <no@.spam.com> wrote in message
news:%23p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl...
>I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
>there any way to do this if I no longer have sql 2005 running? I detached
>and saved the db, but I don't have 2005 running anywhere anymore.
> Thanks, Andre
>
|||Thanks all.
In fact, I did end up installing SQL2005 beta 2 on another box. Then the
fun began because that box didn't have enough disk space to hold my 2005 db
that I was concerned with. But fortunately I found the article that showed
my how to flip a traceflag so that I could connect the db to a network
share. That worked - and then I used Integration Services (dts) to transfer
the data to a new sql 2k db. Where there's a will, there's a way.
Andre

attach 2005 db on 2000

I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
there any way to do this if I no longer have sql 2005 running? I detached
and saved the db, but I don't have 2005 running anywhere anymore.
Thanks, Andre"Andre" <no@.spam.com> wrote in
news:#p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl:
> I have a sql 2005 beta 2 db that I need to move back to a sql 2000
> box. Is there any way to do this if I no longer have sql 2005
> running? I detached and saved the db, but I don't have 2005 running
> anywhere anymore.
Unfortunately, I do not think so. It's quite possible to attach a SQL
Server 2000 to SQL Server 2005, but as far as I know not the other way
around.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||Bummer, that's what I was afraid of. Thanks for the reply.|||1. Create new database in SQL 2000
2. Genarete script from objtects on the SQL 2005
3. Execute this script on the SQL 2000
If you have data, use bcp utilities or DTS/SSIS to export and import.
Regards
Amish|||"amish" <shahamishm@.gmail.com> wrote in news:1136273968.474136.28240
@.g44g2000cwa.googlegroups.com:
> 1. Create new database in SQL 2000
> 2. Genarete script from objtects on the SQL 2005
> 3. Execute this script on the SQL 2000
> If you have data, use bcp utilities or DTS/SSIS to export and import.
Of course, there are only one problem: There are no SQL Server 2005
instance, so there is nowhere to create the scripts :) As far as I remember
from the original post, the situation is that he has a database detached
from SQL Server 2005, but no SQL Server 2005 instance.
He can install one though...
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||That they have to manage.
Regards
Amish|||No. The internal bits are different. You can not attach a 2005 database to
2000.
--
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Andre" <no@.spam.com> wrote in message
news:%23p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl...
>I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
>there any way to do this if I no longer have sql 2005 running? I detached
>and saved the db, but I don't have 2005 running anywhere anymore.
> Thanks, Andre
>|||Thanks all.
In fact, I did end up installing SQL2005 beta 2 on another box. Then the
fun began because that box didn't have enough disk space to hold my 2005 db
that I was concerned with. But fortunately I found the article that showed
my how to flip a traceflag so that I could connect the db to a network
share. That worked - and then I used Integration Services (dts) to transfer
the data to a new sql 2k db. Where there's a will, there's a way. :)
Andre

attach 2005 db on 2000

I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
there any way to do this if I no longer have sql 2005 running? I detached
and saved the db, but I don't have 2005 running anywhere anymore.
Thanks, Andre"Andre" <no@.spam.com> wrote in
news:#p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl:

> I have a sql 2005 beta 2 db that I need to move back to a sql 2000
> box. Is there any way to do this if I no longer have sql 2005
> running? I detached and saved the db, but I don't have 2005 running
> anywhere anymore.
Unfortunately, I do not think so. It's quite possible to attach a SQL
Server 2000 to SQL Server 2005, but as far as I know not the other way
around.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||Bummer, that's what I was afraid of. Thanks for the reply.|||1. Create new database in SQL 2000
2. Genarete script from objtects on the SQL 2005
3. Execute this script on the SQL 2000
If you have data, use bcp utilities or DTS/SSIS to export and import.
Regards
Amish|||"amish" <shahamishm@.gmail.com> wrote in news:1136273968.474136.28240
@.g44g2000cwa.googlegroups.com:

> 1. Create new database in SQL 2000
> 2. Genarete script from objtects on the SQL 2005
> 3. Execute this script on the SQL 2000
> If you have data, use bcp utilities or DTS/SSIS to export and import.
Of course, there are only one problem: There are no SQL Server 2005
instance, so there is nowhere to create the scripts As far as I remember
from the original post, the situation is that he has a database detached
from SQL Server 2005, but no SQL Server 2005 instance.
He can install one though...
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging|||That they have to manage.
Regards
Amish|||No. The internal bits are different. You can not attach a 2005 database to
2000.
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Andre" <no@.spam.com> wrote in message
news:%23p$1Pm8DGHA.344@.TK2MSFTNGP11.phx.gbl...
>I have a sql 2005 beta 2 db that I need to move back to a sql 2000 box. Is
>there any way to do this if I no longer have sql 2005 running? I detached
>and saved the db, but I don't have 2005 running anywhere anymore.
> Thanks, Andre
>|||Thanks all.
In fact, I did end up installing SQL2005 beta 2 on another box. Then the
fun began because that box didn't have enough disk space to hold my 2005 db
that I was concerned with. But fortunately I found the article that showed
my how to flip a traceflag so that I could connect the db to a network
share. That worked - and then I used Integration Services (dts) to transfer
the data to a new sql 2k db. Where there's a will, there's a way.
Andre

Assigning a Dataset to a Rectangle

Hello,
I've created a Rectangle within a SQL Report, and i'd like to tie it
back to a Dataset. Within the Rectangle Properties it lists Data
Region, but none of my Datasets are appearing in the dropdown.
I found the following article on Microsoft's site -
http://technet.microsoft.com/en-us/library/ms159224.aspx - but the
first step is throwing me - "In Layout view, right-click the data
region and then click Properties." Data Region is an option within
the Rectangle Properties and not an object in of itself, so I'm not
sure what "Data Region" it's saying to right-click on.
Can someone point me in the right direction?
Thanks,
AlexOn Feb 14, 9:35=A0am, Alex <sama...@.gmail.com> wrote:
> Hello,
> I've created a Rectangle within a SQL Report, and i'd like to tie it
> back to a Dataset. =A0Within the Rectangle Properties it lists Data
> Region, but none of my Datasets are appearing in the dropdown.
> I found the following article on Microsoft's site -http://technet.microsof=
t.com/en-us/library/ms159224.aspx- but the
> first step is throwing me - "In Layout view, right-click the data
> region and then click Properties." =A0Data Region is an option within
> the Rectangle Properties and not an object in of itself, so I'm not
> sure what "Data Region" it's saying to right-click on.
> Can someone point me in the right direction?
> Thanks,
> Alex
Alex,
First thing to know, a rectangle is not a data region, it is a
graphical "report item" that's more like a container to keep report
items together.
Data regions are table, matrix, chart and list. They can be
associated with a dataset, rectangles cannot.
I'd suggest you try using the list data region as it will give you the
flexibility of freeform layout while still letting you tie back to a
dataset.
Also, take a look at this TechNet article for more info on Data
Regions:
http://technet.microsoft.com/en-us/library/ms157134.aspx
And this one for report items:
http://technet.microsoft.com/en-us/library/ms159268.aspx
HTH
toolman