Descending keys in MSSQL7

I try the following index in SQL7
create index i1 on tab1 (f1 asc, f2 desc)
and I get an error. If I type the following:
create index i1 on tab1 (f1, f2 desc)
the index is created but the descending index is ignored. Can anyone point me in the right direction ?Features introduced with SQL2K, not supported in version 7,
"Lawrence" <lawrence@.magicsoftware.com> wrote in message
news:BB978427-F24F-4D10-9BA9-EC7D21B89CD9@.microsoft.com...
> I try the following index in SQL7
> create index i1 on tab1 (f1 asc, f2 desc)
> and I get an error. If I type the following:
> create index i1 on tab1 (f1, f2 desc)
> the index is created but the descending index is ignored. Can anyone point
me in the right direction ?

Deprecated features in 2005

Hello folks,
I am currently working on a project plan to move from SQL7/NT4 to
SQL2005/Win2003 and I am putting together a documentation for our developers
regarding new features and deprecated features in 2005.
Can you point me to a detailed ducumentation on the programming side?
Thanks a lot.http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
and
http://msdn2.microsoft.com/en-us/library/ms144262.aspx
Tony Rogerson
SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson - technical commentary from a SQL
Server Consultant
http://sqlserverfaq.com - free video tutorials
"Ata John" <AtaJohn@.discussions.microsoft.com> wrote in message
news:67622D5C-D5C8-4F16-89FA-2CDFD6730F01@.microsoft.com...
> Hello folks,
> I am currently working on a project plan to move from SQL7/NT4 to
> SQL2005/Win2003 and I am putting together a documentation for our
> developers
> regarding new features and deprecated features in 2005.
> Can you point me to a detailed ducumentation on the programming side?
> Thanks a lot.|||On Tue, 23 May 2006 22:22:23 +0100, "Tony Rogerson"
<tonyrogerson@.sqlserverfaq.com> wrote:

>http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
>and
>http://msdn2.microsoft.com/en-us/library/ms144262.aspx
One level up the tree from those:
http://msdn2.microsoft.com/en-us/library/ms143532.aspx
there are two more important links:
"Database Engine feature changes that might require changes to
applications."
http://msdn2.microsoft.com/en-us/library/ms143179.aspx
"Other changes in behavior to database features in this release."
http://msdn2.microsoft.com/en-us/library/ms143359.aspx
Roy Harvey
Beacon Falls, CTsql

Deny access to tables

Hi,
I was hoping someone could help me with a problem I have
in SQL 2000, I'm an old SQL7 DBA and I haven't used SQL
Server in a few years, so I'm quite rusty.
How do you allow a user access to a database but restrict
what tables they can see/edit. The problem I'm
experiencing is the Public role, I can't seem to delete
it and I don't want to change it's permissions as all the
other users need access to the tables it allows..
Any help - I'm probably missing something so basic and
will kick myself.
Many thanks in advance for any help received.
MichelleHi;
Have a look into DENY statement in Books online
Sample statement to deny all revilages on emp_master table from user : test
DENY all on emp_master to test
Thanks
Hari
MCDBA
"Michelle T" <anonymous@.discussions.microsoft.com> wrote in message
news:192e801c44c78$5252a170$a001280a@.phx
.gbl...
> Hi,
> I was hoping someone could help me with a problem I have
> in SQL 2000, I'm an old SQL7 DBA and I haven't used SQL
> Server in a few years, so I'm quite rusty.
> How do you allow a user access to a database but restrict
> what tables they can see/edit. The problem I'm
> experiencing is the Public role, I can't seem to delete
> it and I don't want to change it's permissions as all the
> other users need access to the tables it allows..
> Any help - I'm probably missing something so basic and
> will kick myself.
> Many thanks in advance for any help received.
> Michelle
>|||Hari,
Thanks for that, I thought that a script might be what
was required.
Thanks for all your help.
Michelle
>--Original Message--
>Hi;
>Have a look into DENY statement in Books online
>Sample statement to deny all revilages on emp_master
table from user : test
>DENY all on emp_master to test
>Thanks
>Hari
>MCDBA
>"Michelle T" <anonymous@.discussions.microsoft.com> wrote
in message
> news:192e801c44c78$5252a170$a001280a@.phx
.gbl...
have[vbcol=seagreen]
restrict[vbcol=seagreen]
the[vbcol=seagreen]
>
>.
>