Limitations sql server 2000 Personal edition

SQL Server Personal edition
Enterprise Manager
on Win 2000
I have the above installed on my own computer
I have connected to a remote database using it's IP adress
I can see all the tables - eg NorthWind
With the appropriate login (Server Authentification) should I be able to
create a new database, Create new tables, see permissions and alter them ?
[I have ALSO TRIED www.aspenterprisemanager.com (we-based tool) same
situation can see but I cannaot do anything else!]
BUT have been told my login will allow this!!!!!
[I have also tried connecting through Query Analyser - no creates allowed]
Jim Bunton
Ok - sorted thsi no replies required thanks
"Jim Bunton" <jBunton@.BlueYonder.co.uk> wrote in message
news:XK37f.173379$RW.126302@.fe2.news.blueyonder.co .uk...
> SQL Server Personal edition
> Enterprise Manager
> on Win 2000
> I have the above installed on my own computer
> I have connected to a remote database using it's IP adress
> I can see all the tables - eg NorthWind
> With the appropriate login (Server Authentification) should I be able to
> create a new database, Create new tables, see permissions and alter them
?
> [I have ALSO TRIED www.aspenterprisemanager.com (we-based tool) same
> situation can see but I cannaot do anything else!]
> BUT have been told my login will allow this!!!!!
> [I have also tried connecting through Query Analyser - no creates allowed]
> --
>
> Jim Bunton
>

Limitations sql server 2000 Personal edition

SQL Server Personal edition
Enterprise Manager
on Win 2000
I have the above installed on my own computer
I have connected to a remote database using it's IP adress
I can see all the tables - eg NorthWind
With the appropriate login (Server Authentification) should I be able to
create a new database, Create new tables, see permissions and alter them ?
[I have ALSO TRIED www.aspenterprisemanager.com (we-based tool) same
situation can see but I cannaot do anything else!]
BUT have been told my login will allow this!!!!!
[I have also tried connecting through Query Analyser - no creates allowe
d]
--
Jim BuntonOk - sorted thsi no replies required thanks
"Jim Bunton" <jBunton@.BlueYonder.co.uk> wrote in message
news:XK37f.173379$RW.126302@.fe2.news.blueyonder.co.uk...
> SQL Server Personal edition
> Enterprise Manager
> on Win 2000
> I have the above installed on my own computer
> I have connected to a remote database using it's IP adress
> I can see all the tables - eg NorthWind
> With the appropriate login (Server Authentification) should I be able to
> create a new database, Create new tables, see permissions and alter them
?
> [I have ALSO TRIED www.aspenterprisemanager.com (we-based tool) same
> situation can see but I cannaot do anything else!]
> BUT have been told my login will allow this!!!!!
> [I have also tried connecting through Query Analyser - no creates allo
wed]
> --
>
> Jim Bunton
>

Limitations Server 2000 Personal Edition

SQL Server Personal edition
Enterprise Manager
on Win 2000
I have the above installed on my own computer
I have connected to a remote database using it's IP adress
I can see all the tables - eg NorthWind
With the appropriate login (Server Authentification) should I be able to
create a new database, Create new tables, see permissions and alter them ?
[I have ALSO TRIED www.aspenterprisemanager.com (we-based tool) same
situation can see but I cannaot do anything else!]
BUT have been told my login will allow this!!!!!
[I have also tried connecting through Query Analyser - no creates allowed]
Jim Bunton
It looks like you have read permissions only
http://sqlservercode.blogspot.com/
"Jim Bunton" wrote:

> SQL Server Personal edition
> Enterprise Manager
> on Win 2000
> I have the above installed on my own computer
> I have connected to a remote database using it's IP adress
> I can see all the tables - eg NorthWind
> With the appropriate login (Server Authentification) should I be able to
> create a new database, Create new tables, see permissions and alter them ?
> [I have ALSO TRIED www.aspenterprisemanager.com (we-based tool) same
> situation can see but I cannaot do anything else!]
> BUT have been told my login will allow this!!!!!
> [I have also tried connecting through Query Analyser - no creates allowed]
> --
>
> Jim Bunton
>
>