How to rung SQL 2005 db on SQL 2000 server - no unique SQL 2005 st

I converted a database from Sql 2000 to Sql 2005 - no problems. Added
function to the database. I did not use any new functions unique to Sql
2005, as far as I know. I need to allw this database to run on both SQL 2000
and SQL 2005. When I attempted to load the database on SQL 2000 local
server, I received the following message:
Error 602 - Could not find Row in SysIndex for ID 7, Object ID 1, Index ID 1.
Run DBCC checktable on SysIndex.
I have never run this and I do not know if this is an on going problem. Any
information would be appreciated.
Thank You.
Jack
LitePipe ManagementYou cannot restore or attach a 2005 database to 2000, 2005 added stuff to the database file formats
that wasn't known when MS wrote 2000 (obviously). To downgrade, you have to go the script,
export/import route (using BCP, DTS, SSIS etc).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"LitePipe" <LitePipe@.discussions.microsoft.com> wrote in message
news:5BB70FC5-0BD5-4306-AC5D-0ED417835C6B@.microsoft.com...
>I converted a database from Sql 2000 to Sql 2005 - no problems. Added
> function to the database. I did not use any new functions unique to Sql
> 2005, as far as I know. I need to allw this database to run on both SQL 2000
> and SQL 2005. When I attempted to load the database on SQL 2000 local
> server, I received the following message:
> Error 602 - Could not find Row in SysIndex for ID 7, Object ID 1, Index ID 1.
> Run DBCC checktable on SysIndex.
> I have never run this and I do not know if this is an on going problem. Any
> information would be appreciated.
> Thank You.
> Jack
> LitePipe Management|||Thank you, I appreciate you taking the time to answer my question.
Jack Leach
"Tibor Karaszi" wrote:
> You cannot restore or attach a 2005 database to 2000, 2005 added stuff to the database file formats
> that wasn't known when MS wrote 2000 (obviously). To downgrade, you have to go the script,
> export/import route (using BCP, DTS, SSIS etc).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "LitePipe" <LitePipe@.discussions.microsoft.com> wrote in message
> news:5BB70FC5-0BD5-4306-AC5D-0ED417835C6B@.microsoft.com...
> >I converted a database from Sql 2000 to Sql 2005 - no problems. Added
> > function to the database. I did not use any new functions unique to Sql
> > 2005, as far as I know. I need to allw this database to run on both SQL 2000
> > and SQL 2005. When I attempted to load the database on SQL 2000 local
> > server, I received the following message:
> > Error 602 - Could not find Row in SysIndex for ID 7, Object ID 1, Index ID 1.
> > Run DBCC checktable on SysIndex.
> >
> > I have never run this and I do not know if this is an on going problem. Any
> > information would be appreciated.
> >
> > Thank You.
> >
> > Jack
> > LitePipe Management
>|||Hi,
If you select the option of scripting the SQL 2005 database tobe
compatible with SQL 2000.
There is a bug in SQL 2005 were it won't create the correct script
which can be used with SQL 2000.
May be you will have to wait for next SP or need to modify the script
so it can run on SQL 2k.
Thanks
Ajay Rengunthwar
MCTS
LitePipe wrote:
> Thank you, I appreciate you taking the time to answer my question.
> Jack Leach
> "Tibor Karaszi" wrote:
> > You cannot restore or attach a 2005 database to 2000, 2005 added stuff to the database file formats
> > that wasn't known when MS wrote 2000 (obviously). To downgrade, you have to go the script,
> > export/import route (using BCP, DTS, SSIS etc).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "LitePipe" <LitePipe@.discussions.microsoft.com> wrote in message
> > news:5BB70FC5-0BD5-4306-AC5D-0ED417835C6B@.microsoft.com...
> > >I converted a database from Sql 2000 to Sql 2005 - no problems. Added
> > > function to the database. I did not use any new functions unique to Sql
> > > 2005, as far as I know. I need to allw this database to run on both SQL 2000
> > > and SQL 2005. When I attempted to load the database on SQL 2000 local
> > > server, I received the following message:
> > > Error 602 - Could not find Row in SysIndex for ID 7, Object ID 1, Index ID 1.
> > > Run DBCC checktable on SysIndex.
> > >
> > > I have never run this and I do not know if this is an on going problem. Any
> > > information would be appreciated.
> > >
> > > Thank You.
> > >
> > > Jack
> > > LitePipe Management
> >
> >

How to rung SQL 2005 db on SQL 2000 server - no unique SQL 2005 st

I converted a database from Sql 2000 to Sql 2005 - no problems. Added
function to the database. I did not use any new functions unique to Sql
2005, as far as I know. I need to allw this database to run on both SQL 200
0
and SQL 2005. When I attempted to load the database on SQL 2000 local
server, I received the following message:
Error 602 - Could not find Row in SysIndex for ID 7, Object ID 1, Index ID 1
.
Run DBCC checktable on SysIndex.
I have never run this and I do not know if this is an on going problem. Any
information would be appreciated.
Thank You.
Jack
LitePipe ManagementYou cannot restore or attach a 2005 database to 2000, 2005 added stuff to th
e database file formats
that wasn't known when MS wrote 2000 (obviously). To downgrade, you have to
go the script,
export/import route (using BCP, DTS, SSIS etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"LitePipe" <LitePipe@.discussions.microsoft.com> wrote in message
news:5BB70FC5-0BD5-4306-AC5D-0ED417835C6B@.microsoft.com...
>I converted a database from Sql 2000 to Sql 2005 - no problems. Added
> function to the database. I did not use any new functions unique to Sql
> 2005, as far as I know. I need to allw this database to run on both SQL 2
000
> and SQL 2005. When I attempted to load the database on SQL 2000 local
> server, I received the following message:
> Error 602 - Could not find Row in SysIndex for ID 7, Object ID 1, Index ID
1.
> Run DBCC checktable on SysIndex.
> I have never run this and I do not know if this is an on going problem. A
ny
> information would be appreciated.
> Thank You.
> Jack
> LitePipe Management

how to retrieve only the duplicates in a table

There is a table with a single column with 75 rows - 50 unique / 25
duplicates. How would pull back a list of the rows that have/are
duplicates?

This is a question that I got in an interview. I didn't get it,
obviously...

Thanks,

TimSELECT col1, col2, col3, ...
FROM Sometable
GROUP BY col1, col2, col3, ...
HAVING COUNT(*)>1

--
David Portas
----
Please reply only to the newsgroup
--

"TimG" <timgru@.hotmail.com> wrote in message
news:744d8a29.0311072031.75846c64@.posting.google.c om...
> There is a table with a single column with 75 rows - 50 unique / 25
> duplicates. How would pull back a list of the rows that have/are
> duplicates?
> This is a question that I got in an interview. I didn't get it,
> obviously...
> Thanks,
> Tim