Does MSDE support roles and views?

Hello,
I'm trying to figure out whether we need to go with MSDE or SQL Server. Can someone tell me if views are available in MSDE and if so, are they done the same as in SQL Server? Thanks so much.
Debbie
Yes.
Some of the differences between MSDE 2000 and SQL Server 2000 Standard
Edition are:
MSDE 2000 does not include the GUI tools.
MSDE 2000 has a workload governor that limits performance when more than a
few people connect.
MSDE 2000 databases are limited to 2GB of data per database.
MSDE 2000 does not support features primarily intended to support large
servers, such as failover clustering.
A list of the features supported by each edition of SQL Server 2000 is at:
http://msdn.microsoft.com/library/?u...asp?frame=true
You can find a lot of information about MSDE 2000 at
www.microsoft.com\sql\msde
There is a description of the workload governor starting at this location:
http://msdn.microsoft.com/library/?u...asp?frame=true
Much of the documentation in the SQL Server 2000 Books Online applies to
MSDE 2000. This topic describes which parts apply:
http://msdn.microsoft.com/library/?u...asp?frame=true
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
|||On Tue, 15 Jun 2004 19:35:49 -0700, Alan Brewer [MSFT] wrote:

>MSDE 2000 has a workload governor that limits performance when more than a
>few people connect.
Hi Alan,
That's not entirely accurate. The workload governor will only limit
performance if the number of active operations gets too high (over 8, 3 of
which are for system internal use).
One connection may execute several operations simultaneously. But on the
other hand, in a typical data entry situation, one can have 50 to 100
people connected without ever hitting the workload governor's limitations,
as the connections are inactive while the data entry typist is hammering
his/her keyboard and only active for a short time when data is sent to the
server and stored.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||Thank you both. What I need to get at is that views in SQL Server will help us limit the access to a centralized data by remote location. This means that a location will only see their data. I'm wondering if that capability exists in MSDE 2000. Thanks
,
Debbie
"Hugo Kornelis" wrote:

> On Tue, 15 Jun 2004 19:35:49 -0700, Alan Brewer [MSFT] wrote:
>
> Hi Alan,
> That's not entirely accurate. The workload governor will only limit
> performance if the number of active operations gets too high (over 8, 3 of
> which are for system internal use).
> One connection may execute several operations simultaneously. But on the
> other hand, in a typical data entry situation, one can have 50 to 100
> people connected without ever hitting the workload governor's limitations,
> as the connections are inactive while the data entry typist is hammering
> his/her keyboard and only active for a short time when data is sent to the
> server and stored.
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)
>
|||On Wed, 16 Jun 2004 03:52:01 -0700, Debbie wrote:

>Thank you both. What I need to get at is that views in SQL Server will help us limit the access to a centralized data by remote location. This means that a location will only see their data. I'm wondering if that capability exists in MSDE 2000. Thank
s,
>Debbie
>
Hi Debbie,
Yes, you can do that, if you include a location column in the table
design. Simplified example:
CREATE VIEW ViewForLocationA
SELECT ColumnA, ColmunB, ...
FROM CompleteTable
WHERE Location = 'A'
Make sure that people at location A get rights to this view but no rights
to other views and the underlying table. This will work for both SQL
Server and MSDE.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||Yes, which is why I included the link to the more in-depth description of
the governor so Debbie could get a better idea of exactly how the governor
worked.
Alan Brewer [MSFT]
Lead Programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
|||Thank you again so much, that was a huge help!
Debbie
"Alan Brewer [MSFT]" wrote:

> Yes, which is why I included the link to the more in-depth description of
> the governor so Debbie could get a better idea of exactly how the governor
> worked.
> --
> Alan Brewer [MSFT]
> Lead Programming Writer
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
>
>