SQL 7.0 tables

[Toni]

Can someone please explain to me why when I am in
the Enterprise Manager in SQL 7.0, I have my server
expanded, my database expanded. I've expanded the
'tables' and highlighted the table I want to look
at. When I right-click and go down to 'Open Table',
sometimes I am given both options (Return all Rows,
and Return Top)? Other times, the 'Return Top'
option is greyed out. Any ideas why? SA is the
owner of both tables.

Thanks!
Toni

[Andrew Wiegand]

Hi,
One possibility is that your database compatability level has changed. I noticed when I set my compatability level to 6.5 then the Top feature was disabled. This is because the Top feature is new to SQL Server 7.0. You can determine your compatability level by either executing the following in Query Analyzer:
sp_dbcmptlevel <database name>

or right-click on the database in Enterprise Manager, select Properties, click on the Options tab and look at the Compatability Level drop-down.

hth,
andrew


------------
Toni at 11/18/99 9:14:56 AM

Can someone please explain to me why when I am in
the Enterprise Manager in SQL 7.0, I have my server
expanded, my database expanded. I&#39;ve expanded the
&#39;tables&#39; and highlighted the table I want to look
at. When I right-click and go down to &#39;Open Table&#39;,
sometimes I am given both options (Return all Rows,
and Return Top)? Other times, the &#39;Return Top&#39;
option is greyed out. Any ideas why? SA is the
owner of both tables.

Thanks!
Toni

[Toni]

You are so right. The compatability level is 6.5.
I don&#39;t have this &#39;Compatability&#39; section on
my &#39;Options&#39; tab. Is there some way that I can
change it with the Query Analyzer, perhaps?

Thank you for your help!
Toni


------------
Andrew Wiegand at 11/18/99 10:49:27 AM

Hi,
One possibility is that your database compatability level has changed. I noticed when I set my compatability level to 6.5 then the Top feature was disabled. This is because the Top feature is new to SQL Server 7.0. You can determine your compatability level by either executing the following in Query Analyzer:
sp_dbcmptlevel <database name>

or right-click on the database in Enterprise Manager, select Properties, click on the Options tab and look at the Compatability Level drop-down.

hth,
andrew


------------
Toni at 11/18/99 9:14:56 AM

Can someone please explain to me why when I am in
the Enterprise Manager in SQL 7.0, I have my server
expanded, my database expanded. I&#39;ve expanded the
&#39;tables&#39; and highlighted the table I want to look
at. When I right-click and go down to &#39;Open Table&#39;,
sometimes I am given both options (Return all Rows,
and Return Top)? Other times, the &#39;Return Top&#39;
option is greyed out. Any ideas why? SA is the
owner of both tables.

Thanks!
Toni

[Andrew Wiegand]

Hi,
I&#39;m glad it worked. You can change it in Query Analyzer using the same sproc: sp_dbcmptlevel <database name>, <version>

where <version> is either 60, 65 or 70. So if you wanted to make the database act like 65 you would say:
sp_dbcmptlevel <database name>, 65

andrew

------------
Toni at 11/18/99 11:18:39 AM

You are so right. The compatability level is 6.5.
I don&#39;t have this &#39;Compatability&#39; section on
my &#39;Options&#39; tab. Is there some way that I can
change it with the Query Analyzer, perhaps?

Thank you for your help!
Toni


------------
Andrew Wiegand at 11/18/99 10:49:27 AM

Hi,
One possibility is that your database compatability level has changed. I noticed when I set my compatability level to 6.5 then the Top feature was disabled. This is because the Top feature is new to SQL Server 7.0. You can determine your compatability level by either executing the following in Query Analyzer:
sp_dbcmptlevel <database name>

or right-click on the database in Enterprise Manager, select Properties, click on the Options tab and look at the Compatability Level drop-down.

hth,
andrew


------------
Toni at 11/18/99 9:14:56 AM

Can someone please explain to me why when I am in
the Enterprise Manager in SQL 7.0, I have my server
expanded, my database expanded. I&#39;ve expanded the
&#39;tables&#39; and highlighted the table I want to look
at. When I right-click and go down to &#39;Open Table&#39;,
sometimes I am given both options (Return all Rows,
and Return Top)? Other times, the &#39;Return Top&#39;
option is greyed out. Any ideas why? SA is the
owner of both tables.

Thanks!
Toni