How do I make a view read-only

I want to create a view that can not be used for record inserts, updates or
deletes - by anyone, including administrators. Is there an option that can
be used in creating the view so I don't have to go through all the users
setting up deny permissions?
http://developer.mimer.com/documentation/html_92/Mimer_SQL_Engine_DocSet/Data_manipulation6.html
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:40734E47-0774-4810-959C-5212C74089A7@.microsoft.com...
>I want to create a view that can not be used for record inserts, updates or
> deletes - by anyone, including administrators. Is there an option that
> can
> be used in creating the view so I don't have to go through all the users
> setting up deny permissions?
|||There is nothing you can do to deny administrators rights to your view.
Your best bet is to create an INSTEAD OF TRIGGER that just generates an
error message whenever someone tries to modify the view.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:40734E47-0774-4810-959C-5212C74089A7@.microsoft.com...
>I want to create a view that can not be used for record inserts, updates or
> deletes - by anyone, including administrators. Is there an option that
> can
> be used in creating the view so I don't have to go through all the users
> setting up deny permissions?
|||Thank you for all your suggestions. I came up with this solution: I added
DISTINCT to the syntax. Since the select list included the unique
identifier, I get the same view results, but now the view is not editable.
"Bev Kaufman" wrote:

> I want to create a view that can not be used for record inserts, updates or
> deletes - by anyone, including administrators. Is there an option that can
> be used in creating the view so I don't have to go through all the users
> setting up deny permissions?
|||Keep in mind that this solution might not always possible. The INSTEAD OF
trigger solution is much more general purpose. Also in many cases, adding a
DISTINCT can have a negative impact on query performance if there is no
guaranteed uniqueness. Does your uniqueifier have a unique index? That is
the only way that SQL Server knows the values are already unique and doesn't
add extra processing for the DISTINCT.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:89E10E73-53AD-466B-93F1-7C8B9E6C3E0F@.microsoft.com...[vbcol=seagreen]
> Thank you for all your suggestions. I came up with this solution: I added
> DISTINCT to the syntax. Since the select list included the unique
> identifier, I get the same view results, but now the view is not editable.
> "Bev Kaufman" wrote:

How do I make a view read-only

I want to create a view that can not be used for record inserts, updates or
deletes - by anyone, including administrators. Is there an option that can
be used in creating the view so I don't have to go through all the users
setting up deny permissions?http://developer.mimer.com/documentation/html_92/Mimer_SQL_Engine_DocSet/Data_manipulation6.html
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:40734E47-0774-4810-959C-5212C74089A7@.microsoft.com...
>I want to create a view that can not be used for record inserts, updates or
> deletes - by anyone, including administrators. Is there an option that
> can
> be used in creating the view so I don't have to go through all the users
> setting up deny permissions?|||If you don't want to change the view definition you can add an INSTEAD_OF
trigger for INSERT, DELETE and UPDATE that do nothing.
--
Rubén Garrigós
Solid Quality Mentors
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:40734E47-0774-4810-959C-5212C74089A7@.microsoft.com...
>I want to create a view that can not be used for record inserts, updates or
> deletes - by anyone, including administrators. Is there an option that
> can
> be used in creating the view so I don't have to go through all the users
> setting up deny permissions?|||Hi Bev
I really think this should be covered by the permissions you grant to the
view, trying to stop administrators updating the view would just mean only
mean they would need to hit the base tables instead.
John
"Bev Kaufman" wrote:
> I want to create a view that can not be used for record inserts, updates or
> deletes - by anyone, including administrators. Is there an option that can
> be used in creating the view so I don't have to go through all the users
> setting up deny permissions?|||There is nothing you can do to deny administrators rights to your view.
Your best bet is to create an INSTEAD OF TRIGGER that just generates an
error message whenever someone tries to modify the view.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:40734E47-0774-4810-959C-5212C74089A7@.microsoft.com...
>I want to create a view that can not be used for record inserts, updates or
> deletes - by anyone, including administrators. Is there an option that
> can
> be used in creating the view so I don't have to go through all the users
> setting up deny permissions?|||Thank you for all your suggestions. I came up with this solution: I added
DISTINCT to the syntax. Since the select list included the unique
identifier, I get the same view results, but now the view is not editable.
"Bev Kaufman" wrote:
> I want to create a view that can not be used for record inserts, updates or
> deletes - by anyone, including administrators. Is there an option that can
> be used in creating the view so I don't have to go through all the users
> setting up deny permissions?|||Keep in mind that this solution might not always possible. The INSTEAD OF
trigger solution is much more general purpose. Also in many cases, adding a
DISTINCT can have a negative impact on query performance if there is no
guaranteed uniqueness. Does your uniqueifier have a unique index? That is
the only way that SQL Server knows the values are already unique and doesn't
add extra processing for the DISTINCT.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://blog.kalendelaney.com
"Bev Kaufman" <BevKaufman@.discussions.microsoft.com> wrote in message
news:89E10E73-53AD-466B-93F1-7C8B9E6C3E0F@.microsoft.com...
> Thank you for all your suggestions. I came up with this solution: I added
> DISTINCT to the syntax. Since the select list included the unique
> identifier, I get the same view results, but now the view is not editable.
> "Bev Kaufman" wrote:
>> I want to create a view that can not be used for record inserts, updates
>> or
>> deletes - by anyone, including administrators. Is there an option that
>> can
>> be used in creating the view so I don't have to go through all the users
>> setting up deny permissions?sql

How do i get rid of page breaks for HTML view...

Hello, I would like to get my reports to be on one page when viewing in HTML
in the report viewer. People generally dont want to have to flip through
pages when looking at reports online... they would much rather see the entire
report and just keep scrolling... however when printing you would want the
page-breaks to still happen (naturall).
Currently in Crystal using their report viewer control I simply removing the
paging controls to get this effect iirc... i tried hiding the paging control
in the RS report viewer control and i simply got a paged report with no way
of advancing through the pages...
Can someone please help me do this.Here is the solution. This works only for RS 2005. RS 2005 introduced
interactivesize which consists of interactivewidth and interactiveheight. To
have no page breaks set the interactiveheight to 0. This only works for
height, not width. You need to get to the report properties. You know how
when you click on the body or a textbox you see the property page for that
element on the right. If you click to the left of the ruler, that gets the
report properties to show (the menu, report properties does allow setting
this). Look for interactivesize, expand and then set interactiveheight to 0.
Not very discoverable but pretty cool.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"thejez" <thejez@.discussions.microsoft.com> wrote in message
news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> Hello, I would like to get my reports to be on one page when viewing in
> HTML
> in the report viewer. People generally dont want to have to flip through
> pages when looking at reports online... they would much rather see the
> entire
> report and just keep scrolling... however when printing you would want the
> page-breaks to still happen (naturall).
> Currently in Crystal using their report viewer control I simply removing
> the
> paging controls to get this effect iirc... i tried hiding the paging
> control
> in the RS report viewer control and i simply got a paged report with no
> way
> of advancing through the pages...
> Can someone please help me do this.|||I think im posting this question to wrong place (but in all fairness its very
confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
control - so i dont see the interactive options. I have RS 2005 but I am
unable to use it because of the limitations of how i can poplate the data (I
have to do pre-aggregation on the data before it gets to the dataset to get
around the aggregate of aggregates lmiitation). So my only option was to use
a local report where i could get the data from the DB pre-process it and then
pop the dataset and then render the report... this a big pain i know but what
can i do...
so is there any way in the VS 2005 ReportViewer and a local Report file
(rdlc). I have height set to 100% on everything and i even went to far as to
define the report at 160in high... but alas the control seems to break at the
same place ignoring everything i throw at it!
:(
"Bruce L-C [MVP]" wrote:
> Here is the solution. This works only for RS 2005. RS 2005 introduced
> interactivesize which consists of interactivewidth and interactiveheight. To
> have no page breaks set the interactiveheight to 0. This only works for
> height, not width. You need to get to the report properties. You know how
> when you click on the body or a textbox you see the property page for that
> element on the right. If you click to the left of the ruler, that gets the
> report properties to show (the menu, report properties does allow setting
> this). Look for interactivesize, expand and then set interactiveheight to 0.
> Not very discoverable but pretty cool.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "thejez" <thejez@.discussions.microsoft.com> wrote in message
> news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > Hello, I would like to get my reports to be on one page when viewing in
> > HTML
> > in the report viewer. People generally dont want to have to flip through
> > pages when looking at reports online... they would much rather see the
> > entire
> > report and just keep scrolling... however when printing you would want the
> > page-breaks to still happen (naturall).
> >
> > Currently in Crystal using their report viewer control I simply removing
> > the
> > paging controls to get this effect iirc... i tried hiding the paging
> > control
> > in the RS report viewer control and i simply got a paged report with no
> > way
> > of advancing through the pages...
> >
> > Can someone please help me do this.
>
>|||Bruce, i managed to just put the <InteractiveHeight>0in</InteractiveHeight>
element into my RDLC file and it worked... so even though there isnt any
design-tim support for setting that value (at least that i saw) adding it to
the source file did the trick.
thanks!
"thejez" wrote:
> I think im posting this question to wrong place (but in all fairness its very
> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> control - so i dont see the interactive options. I have RS 2005 but I am
> unable to use it because of the limitations of how i can poplate the data (I
> have to do pre-aggregation on the data before it gets to the dataset to get
> around the aggregate of aggregates lmiitation). So my only option was to use
> a local report where i could get the data from the DB pre-process it and then
> pop the dataset and then render the report... this a big pain i know but what
> can i do...
> so is there any way in the VS 2005 ReportViewer and a local Report file
> (rdlc). I have height set to 100% on everything and i even went to far as to
> define the report at 160in high... but alas the control seems to break at the
> same place ignoring everything i throw at it!
> :(
> "Bruce L-C [MVP]" wrote:
> > Here is the solution. This works only for RS 2005. RS 2005 introduced
> > interactivesize which consists of interactivewidth and interactiveheight. To
> > have no page breaks set the interactiveheight to 0. This only works for
> > height, not width. You need to get to the report properties. You know how
> > when you click on the body or a textbox you see the property page for that
> > element on the right. If you click to the left of the ruler, that gets the
> > report properties to show (the menu, report properties does allow setting
> > this). Look for interactivesize, expand and then set interactiveheight to 0.
> >
> > Not very discoverable but pretty cool.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > > Hello, I would like to get my reports to be on one page when viewing in
> > > HTML
> > > in the report viewer. People generally dont want to have to flip through
> > > pages when looking at reports online... they would much rather see the
> > > entire
> > > report and just keep scrolling... however when printing you would want the
> > > page-breaks to still happen (naturall).
> > >
> > > Currently in Crystal using their report viewer control I simply removing
> > > the
> > > paging controls to get this effect iirc... i tried hiding the paging
> > > control
> > > in the RS report viewer control and i simply got a paged report with no
> > > way
> > > of advancing through the pages...
> > >
> > > Can someone please help me do this.
> >
> >
> >|||You beat me to it, that is what I was going to suggest.
Also, here is a suggestion for development. Develop reports in RS 2005
designer. The designer is better and you can quickly preview. Don't deploy
the report. Then, rename the rdl file to rdlc and bring it into your
project. This is how I do it. Much nicer development environment.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"thejez" <thejez@.discussions.microsoft.com> wrote in message
news:1A2F6C1F-3453-412A-AC0E-363C18C89D08@.microsoft.com...
> Bruce, i managed to just put the
> <InteractiveHeight>0in</InteractiveHeight>
> element into my RDLC file and it worked... so even though there isnt any
> design-tim support for setting that value (at least that i saw) adding it
> to
> the source file did the trick.
> thanks!
> "thejez" wrote:
>> I think im posting this question to wrong place (but in all fairness its
>> very
>> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
>> control - so i dont see the interactive options. I have RS 2005 but I am
>> unable to use it because of the limitations of how i can poplate the data
>> (I
>> have to do pre-aggregation on the data before it gets to the dataset to
>> get
>> around the aggregate of aggregates lmiitation). So my only option was to
>> use
>> a local report where i could get the data from the DB pre-process it and
>> then
>> pop the dataset and then render the report... this a big pain i know but
>> what
>> can i do...
>> so is there any way in the VS 2005 ReportViewer and a local Report file
>> (rdlc). I have height set to 100% on everything and i even went to far
>> as to
>> define the report at 160in high... but alas the control seems to break at
>> the
>> same place ignoring everything i throw at it!
>> :(
>> "Bruce L-C [MVP]" wrote:
>> > Here is the solution. This works only for RS 2005. RS 2005 introduced
>> > interactivesize which consists of interactivewidth and
>> > interactiveheight. To
>> > have no page breaks set the interactiveheight to 0. This only works for
>> > height, not width. You need to get to the report properties. You know
>> > how
>> > when you click on the body or a textbox you see the property page for
>> > that
>> > element on the right. If you click to the left of the ruler, that gets
>> > the
>> > report properties to show (the menu, report properties does allow
>> > setting
>> > this). Look for interactivesize, expand and then set interactiveheight
>> > to 0.
>> >
>> > Not very discoverable but pretty cool.
>> >
>> >
>> > --
>> > Bruce Loehle-Conger
>> > MVP SQL Server Reporting Services
>> >
>> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
>> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
>> > > Hello, I would like to get my reports to be on one page when viewing
>> > > in
>> > > HTML
>> > > in the report viewer. People generally dont want to have to flip
>> > > through
>> > > pages when looking at reports online... they would much rather see
>> > > the
>> > > entire
>> > > report and just keep scrolling... however when printing you would
>> > > want the
>> > > page-breaks to still happen (naturall).
>> > >
>> > > Currently in Crystal using their report viewer control I simply
>> > > removing
>> > > the
>> > > paging controls to get this effect iirc... i tried hiding the paging
>> > > control
>> > > in the RS report viewer control and i simply got a paged report with
>> > > no
>> > > way
>> > > of advancing through the pages...
>> > >
>> > > Can someone please help me do this.
>> >
>> >
>> >|||another update... after re-starting visual studio (since my properties window
was laggin very badly) i went back into the report and now i notice that when
you click on the out-grey area of the report i can see the interactive
property... hrmm so it is there... at least now it is... i dont think it was
there before.. but like i said my properties page was acting VERY funky (like
showing the properties for a DD control on another page while editing the
report...)
"thejez" wrote:
> Bruce, i managed to just put the <InteractiveHeight>0in</InteractiveHeight>
> element into my RDLC file and it worked... so even though there isnt any
> design-tim support for setting that value (at least that i saw) adding it to
> the source file did the trick.
> thanks!
> "thejez" wrote:
> > I think im posting this question to wrong place (but in all fairness its very
> > confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> > control - so i dont see the interactive options. I have RS 2005 but I am
> > unable to use it because of the limitations of how i can poplate the data (I
> > have to do pre-aggregation on the data before it gets to the dataset to get
> > around the aggregate of aggregates lmiitation). So my only option was to use
> > a local report where i could get the data from the DB pre-process it and then
> > pop the dataset and then render the report... this a big pain i know but what
> > can i do...
> >
> > so is there any way in the VS 2005 ReportViewer and a local Report file
> > (rdlc). I have height set to 100% on everything and i even went to far as to
> > define the report at 160in high... but alas the control seems to break at the
> > same place ignoring everything i throw at it!
> >
> > :(
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Here is the solution. This works only for RS 2005. RS 2005 introduced
> > > interactivesize which consists of interactivewidth and interactiveheight. To
> > > have no page breaks set the interactiveheight to 0. This only works for
> > > height, not width. You need to get to the report properties. You know how
> > > when you click on the body or a textbox you see the property page for that
> > > element on the right. If you click to the left of the ruler, that gets the
> > > report properties to show (the menu, report properties does allow setting
> > > this). Look for interactivesize, expand and then set interactiveheight to 0.
> > >
> > > Not very discoverable but pretty cool.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> > > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> > > > Hello, I would like to get my reports to be on one page when viewing in
> > > > HTML
> > > > in the report viewer. People generally dont want to have to flip through
> > > > pages when looking at reports online... they would much rather see the
> > > > entire
> > > > report and just keep scrolling... however when printing you would want the
> > > > page-breaks to still happen (naturall).
> > > >
> > > > Currently in Crystal using their report viewer control I simply removing
> > > > the
> > > > paging controls to get this effect iirc... i tried hiding the paging
> > > > control
> > > > in the RS report viewer control and i simply got a paged report with no
> > > > way
> > > > of advancing through the pages...
> > > >
> > > > Can someone please help me do this.
> > >
> > >
> > >|||Good advice! Ill do that from now on!
thanks
"Bruce L-C [MVP]" wrote:
> You beat me to it, that is what I was going to suggest.
> Also, here is a suggestion for development. Develop reports in RS 2005
> designer. The designer is better and you can quickly preview. Don't deploy
> the report. Then, rename the rdl file to rdlc and bring it into your
> project. This is how I do it. Much nicer development environment.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "thejez" <thejez@.discussions.microsoft.com> wrote in message
> news:1A2F6C1F-3453-412A-AC0E-363C18C89D08@.microsoft.com...
> > Bruce, i managed to just put the
> > <InteractiveHeight>0in</InteractiveHeight>
> > element into my RDLC file and it worked... so even though there isnt any
> > design-tim support for setting that value (at least that i saw) adding it
> > to
> > the source file did the trick.
> >
> > thanks!
> >
> > "thejez" wrote:
> >
> >> I think im posting this question to wrong place (but in all fairness its
> >> very
> >> confusing from MS) - I am using a LOCAL report in VS 2005 ReportViewer
> >> control - so i dont see the interactive options. I have RS 2005 but I am
> >> unable to use it because of the limitations of how i can poplate the data
> >> (I
> >> have to do pre-aggregation on the data before it gets to the dataset to
> >> get
> >> around the aggregate of aggregates lmiitation). So my only option was to
> >> use
> >> a local report where i could get the data from the DB pre-process it and
> >> then
> >> pop the dataset and then render the report... this a big pain i know but
> >> what
> >> can i do...
> >>
> >> so is there any way in the VS 2005 ReportViewer and a local Report file
> >> (rdlc). I have height set to 100% on everything and i even went to far
> >> as to
> >> define the report at 160in high... but alas the control seems to break at
> >> the
> >> same place ignoring everything i throw at it!
> >>
> >> :(
> >>
> >> "Bruce L-C [MVP]" wrote:
> >>
> >> > Here is the solution. This works only for RS 2005. RS 2005 introduced
> >> > interactivesize which consists of interactivewidth and
> >> > interactiveheight. To
> >> > have no page breaks set the interactiveheight to 0. This only works for
> >> > height, not width. You need to get to the report properties. You know
> >> > how
> >> > when you click on the body or a textbox you see the property page for
> >> > that
> >> > element on the right. If you click to the left of the ruler, that gets
> >> > the
> >> > report properties to show (the menu, report properties does allow
> >> > setting
> >> > this). Look for interactivesize, expand and then set interactiveheight
> >> > to 0.
> >> >
> >> > Not very discoverable but pretty cool.
> >> >
> >> >
> >> > --
> >> > Bruce Loehle-Conger
> >> > MVP SQL Server Reporting Services
> >> >
> >> > "thejez" <thejez@.discussions.microsoft.com> wrote in message
> >> > news:E4ABC9C1-43F0-4564-B248-7EE7D818CC0B@.microsoft.com...
> >> > > Hello, I would like to get my reports to be on one page when viewing
> >> > > in
> >> > > HTML
> >> > > in the report viewer. People generally dont want to have to flip
> >> > > through
> >> > > pages when looking at reports online... they would much rather see
> >> > > the
> >> > > entire
> >> > > report and just keep scrolling... however when printing you would
> >> > > want the
> >> > > page-breaks to still happen (naturall).
> >> > >
> >> > > Currently in Crystal using their report viewer control I simply
> >> > > removing
> >> > > the
> >> > > paging controls to get this effect iirc... i tried hiding the paging
> >> > > control
> >> > > in the RS report viewer control and i simply got a paged report with
> >> > > no
> >> > > way
> >> > > of advancing through the pages...
> >> > >
> >> > > Can someone please help me do this.
> >> >
> >> >
> >> >
>
>

how do i get grid view inside the report

hi there... how do i grid view in report?

Are you asking for a Grid view like in SharePoint, where you can edit data in place? If so, Reporting Services does not offer this capability right now.

You can display data in a table layout. You can also display data in a cross-tab or matrix layout. The only thing you cannot do is edit that data in the web page.

Hope that helps,

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

How do I get DESC order?

Hey guys, I have a view with dates (TheDate) meant to be arranged in descending order. When I 'Execute SQL' while in the view, the DESC order works just fine and shows up with the latest date first going down. However, once I 'OPEN VIEW' the order keeps defaulting to ASCending order.

How do I keep it in DESC order for viewing? Here's the statement:

SELECT TOP (100) PERCENT TheDate
FROM dbo.MyDates
ORDER BY TheDate DESC

By the way, I'm using SQL Server Express, if it makes any difference.

|||

hi,

views, as tables, do not have an order at all.. in fact yoe are executing a SELECT ... FROM view .. ORDER BY ...;

this is the relevant (!) step in your requirement.. the order by clause is a cursor task, not associated with the underlying table/view.. data inside a table (on which the view is defined) is not ordered

please have a look at wikipedia and here as well, where you can read

"..A view is a relational table, and the
relational model states that a table is a set of rows. Since sets are not sorted - per definition - the rows in a view are not ordered either. .."

and even

".. A view is a logical relational table, and the relational model mandates that a table is a set of rows, implying no sort order whatsoever. .."

so, what you are getting, is correct..

if you like, you can "open" the view (in SSMSE) and apply the required "sort" clause adding the ORDER BY specs..

regards

|||

Andrea Montanari wrote:

hi,

views, as tables, do not have an order at all.. in fact yoe are executing a SELECT ... FROM view .. ORDER BY ...;

this is the relevant (!) step in your requirement.. the order by clause is a cursor task, not associated with the underlying table/view.. data inside a table (on which the view is defined) is not ordered

please have a look at wikipedia and here as well, where you can read

"..A view is a relational table, and the
relational model states that a table is a set of rows. Since sets are not sorted - per definition - the rows in a view are not ordered either. .."

and even

".. A view is a logical relational table, and the relational model mandates that a table is a set of rows, implying no sort order whatsoever. .."

so, what you are getting, is correct..

if you like, you can "open" the view (in SSMSE) and apply the required "sort" clause adding the ORDER BY specs..

regards

Thank you for the very informative response as well as the links, Andrea. I was starting to go insane wondering what I was missing! Another day another lesson, I guess!

Once again, thanks for the info.

How do I display/upgrade SQL license Info

In SQL 2000 you went to Control Panel and SQL Licensing to view licensing mode and qty. I have searched everywhere for the equivelant in 2005 including books online, knowledge base but can't find anything.

Anybody know where it is hidden as I need to check this server is set up for per processor and check how many processors?

Thanks

Richard

This does not exist in SQL Server 2005, it works by the honour system