sql 7 and sql 2000 
Author Message
 sql 7 and sql 2000
hi,
Enterprise manager in sql 7 had a nice feture to see table allocated space,
how can I do this in sql 2000 enterprise manager/query analayzer?
is there a way to create a sql2000 database back that can be restored to
sql7, I get a error when I try to restore it.

10x



Sat, 28 Feb 2004 20:05:40 GMT
 sql 7 and sql 2000

Click on the database and choose View menu option and TaskPad.

No way of doing the second thing, try using DTS instead.

--
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
http://www.sql-server.co.uk


Quote:
> hi,
> Enterprise manager in sql 7 had a nice feture to see table allocated
space,
> how can I do this in sql 2000 enterprise manager/query analayzer?
> is there a way to create a sql2000 database back that can be restored to
> sql7, I get a error when I try to restore it.

> 10x



Sat, 28 Feb 2004 19:09:37 GMT
 sql 7 and sql 2000
Quote:
> Enterprise manager in sql 7 had a nice feture to see table allocated space,
> how can I do this in sql 2000 enterprise manager/query analayzer?

I rarely use EM for these things, but here's how to do this in QA:
sp_MSForeachtable 'EXEC sp_spaceused ''?'''

Quote:
> is there a way to create a sql2000 database back that can be restored to
> sql7, I get a error when I try to restore it.

No, you cannot restore a 2000 db onto 7.0.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com

Quote:

> hi,
> Enterprise manager in sql 7 had a nice feture to see table allocated space,
> how can I do this in sql 2000 enterprise manager/query analayzer?
> is there a way to create a sql2000 database back that can be restored to
> sql7, I get a error when I try to restore it.

> 10x



Sat, 28 Feb 2004 19:17:32 GMT
 sql 7 and sql 2000
sp_spaceused give the database space used, not for each table.



Quote:
> > Enterprise manager in sql 7 had a nice feture to see table allocated
space,
> > how can I do this in sql 2000 enterprise manager/query analayzer?
> I rarely use EM for these things, but here's how to do this in QA:
> sp_MSForeachtable 'EXEC sp_spaceused ''?'''

> > is there a way to create a sql2000 database back that can be restored to
> > sql7, I get a error when I try to restore it.
> No, you cannot restore a 2000 db onto 7.0.

> --
> Tibor Karaszi, SQL Server MVP
> FAQ from Neil & others at: http://www.sqlserverfaq.com




- Show quoted text -

Quote:
> > hi,
> > Enterprise manager in sql 7 had a nice feture to see table allocated
space,
> > how can I do this in sql 2000 enterprise manager/query analayzer?
> > is there a way to create a sql2000 database back that can be restored to
> > sql7, I get a error when I try to restore it.

> > 10x



Sat, 28 Feb 2004 21:48:29 GMT
 sql 7 and sql 2000
Did you run the code?
It executes sp_spaceused for each table in the database.

--
Tibor Karaszi, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com

Quote:

> sp_spaceused give the database space used, not for each table.



> > > Enterprise manager in sql 7 had a nice feture to see table allocated
> space,
> > > how can I do this in sql 2000 enterprise manager/query analayzer?
> > I rarely use EM for these things, but here's how to do this in QA:
> > sp_MSForeachtable 'EXEC sp_spaceused ''?'''

> > > is there a way to create a sql2000 database back that can be restored to
> > > sql7, I get a error when I try to restore it.
> > No, you cannot restore a 2000 db onto 7.0.

> > --
> > Tibor Karaszi, SQL Server MVP
> > FAQ from Neil & others at: http://www.sqlserverfaq.com



> > > hi,
> > > Enterprise manager in sql 7 had a nice feture to see table allocated
> space,
> > > how can I do this in sql 2000 enterprise manager/query analayzer?
> > > is there a way to create a sql2000 database back that can be restored to
> > > sql7, I get a error when I try to restore it.

> > > 10x



Sat, 28 Feb 2004 21:17:06 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. SQL 2000 V.S. SQL 2000 that comes with Microsoft SBS

2. sql 2000 Enterprise/sql 2000

3. SQL 6.5 vs. SQL 7.0 or SQL 2000

4. SQL-DMO: Inconsistency between SQL 7 and SQL 2000

5. Generate SQL script in SQL 2000 for SQL 6.5

6. Applying SQL 7 SP on server with both SQL 7 AND SQL 2000

7. migrating sql databases from sql 7.0 to sql 2000

8. transferring databases from sql 7 to sql 2000

9. Exporting SQL 7 to SQL 2000

10. SQL logins in SQL 2000 mixed authentication mode

11. upgrading from SQL 7.0 to SQL 2000 crashed ADO code

12. Migration from SQL 7.0 to SQL 2000


 
Powered by phpBB® Forum Software