Personal Edition

I am going to be purchasing SQL 2000 Standard Edition, in order to use the personal edition software, because we only have windows 98 and me. What my questions is, that we I have the personal edition running on one of my two machines. Will I be able to
connect to the database from another machine. We use a manufactoring program and it will be running a SQL database, when I connect to my program is it going to give me an error about not being able to connect to the personal edition? Thanks
Rocky,
Is this solely for development purposes? Then go for SQL2000 dev edition.It
comes cheap too!Refer the below url for pricing details:
'Developer Edition Licensing'
http://www.microsoft.com/sql/howtobuy/development.asp
[vbcol=seagreen]
Yes.Please note that personal edition has a documented limitation of
handling concurrent queries.
[vbcol=seagreen]
being able to connect to the personal edition?
Well, since I have not seen the connection code, I cant say for sure.But ,
provided the connection code is correct, there is no reason why it wont
connect to the SQLServer just because its a personal edition.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...
> I am going to be purchasing SQL 2000 Standard Edition, in order to use the
personal edition software, because we only have windows 98 and me. What my
questions is, that we I have the personal edition running on one of my two
machines. Will I be able to connect to the database from another machine.
We use a manufactoring program and it will be running a SQL database, when I
connect to my program is it going to give me an error about not being able
to connect to the personal edition? Thanks
|||All that I will be doing with it is installing the SQL Server on a machine, and connecting to the database through a program that we use.
-- Dinesh T.K wrote: --
Rocky,
Is this solely for development purposes? Then go for SQL2000 dev edition.It
comes cheap too!Refer the below url for pricing details:
'Developer Edition Licensing'
http://www.microsoft.com/sql/howtobuy/development.asp
[vbcol=seagreen]
Yes.Please note that personal edition has a documented limitation of
handling concurrent queries.
[vbcol=seagreen]
being able to connect to the personal edition?
Well, since I have not seen the connection code, I cant say for sure.But ,
provided the connection code is correct, there is no reason why it wont
connect to the SQLServer just because its a personal edition.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...
> I am going to be purchasing SQL 2000 Standard Edition, in order to use the
personal edition software, because we only have windows 98 and me. What my
questions is, that we I have the personal edition running on one of my two
machines. Will I be able to connect to the database from another machine.
We use a manufactoring program and it will be running a SQL database, when I
connect to my program is it going to give me an error about not being able
to connect to the personal edition? Thanks
|||Rocky,
So, as per your plan, your database would be running SQL2000 personal
edition and the application connects to this database.Coming back to the
concurrent query limit, does many users use this application concurrently?
Personal edition as well as MSDE can support only upto 8 concurrent queries
before things get real slow and messy.
I must admit, even at this point, Iam not sure if this application is used
for dev purposes or production.Can you please answer that?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:2A41E566-1039-48F4-8F2C-AF53CD8A6382@.microsoft.com...
> All that I will be doing with it is installing the SQL Server on a
machine, and connecting to the database through a program that we use.
>
> -- Dinesh T.K wrote: --
> Rocky,
> Is this solely for development purposes? Then go for SQL2000 dev
edition.It[vbcol=seagreen]
> comes cheap too!Refer the below url for pricing details:
> 'Developer Edition Licensing'
> http://www.microsoft.com/sql/howtobuy/development.asp
> Yes.Please note that personal edition has a documented limitation of
> handling concurrent queries.
not
> being able to connect to the personal edition?
> Well, since I have not seen the connection code, I cant say for
sure.But ,
> provided the connection code is correct, there is no reason why it
wont[vbcol=seagreen]
> connect to the SQLServer just because its a personal edition.
>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "rocky" <anonymous@.discussions.microsoft.com> wrote in message
> news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...
use the
> personal edition software, because we only have windows 98 and me.
What my
> questions is, that we I have the personal edition running on one of
my two
> machines. Will I be able to connect to the database from another
machine.
> We use a manufactoring program and it will be running a SQL database,
when I
> connect to my program is it going to give me an error about not being
able
> to connect to the personal edition? Thanks
>
>
|||First of all thanks for all your help. There will only be two at most concurrently connected. That is if you count the server as one. As far as your question I guess I am confused and I am sorry for that. Whether or not it is development or not. I th
ink it is just production. Because all we are doing is using a program that connects to the database, and updates the database as necessary, so whether or not that is developement or production I am not sure. From reading off of Microsoft's site it wasn
't clear if I could connect more than one machines to a personal edition server, but from your answer I guess I can. So thanks for you help.

Personal Edition

I am going to be purchasing SQL 2000 Standard Edition, in order to use the p
ersonal edition software, because we only have Windows 98 and me. What my q
uestions is, that we I have the personal edition running on one of my two ma
chines. Will I be able to
connect to the database from another machine. We use a manufactoring progra
m and it will be running a SQL database, when I connect to my program is it
going to give me an error about not being able to connect to the personal ed
ition? ThanksRocky,
Is this solely for development purposes? Then go for SQL2000 dev edition.It
comes cheap too!Refer the below url for pricing details:
'Developer Edition Licensing'
http://www.microsoft.com/sql/howtobuy/development.asp

Yes.Please note that personal edition has a documented limitation of
handling concurrent queries.
[vbcol=seagreen]
being able to connect to the personal edition?
Well, since I have not seen the connection code, I cant say for sure.But ,
provided the connection code is correct, there is no reason why it wont
connect to the SQLServer just because its a personal edition.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...[vbcol=seagreen]
> I am going to be purchasing SQL 2000 Standard Edition, in order to use the
personal edition software, because we only have Windows 98 and me. What my
questions is, that we I have the personal edition running on one of my two
machines. Will I be able to connect to the database from another machine.
We use a manufactoring program and it will be running a SQL database, when I
connect to my program is it going to give me an error about not being able
to connect to the personal edition? Thanks|||All that I will be doing with it is installing the SQL Server on a machine,
and connecting to the database through a program that we use.
-- Dinesh T.K wrote: --
Rocky,
Is this solely for development purposes? Then go for SQL2000 dev edition.It
comes cheap too!Refer the below url for pricing details:
'Developer Edition Licensing'
http://www.microsoft.com/sql/howtobuy/development.asp

Yes.Please note that personal edition has a documented limitation of
handling concurrent queries.
[vbcol=seagreen]
being able to connect to the personal edition?
Well, since I have not seen the connection code, I cant say for sure.But ,
provided the connection code is correct, there is no reason why it wont
connect to the SQLServer just because its a personal edition.
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...[vbcol=seagreen]
> I am going to be purchasing SQL 2000 Standard Edition, in order to use the
personal edition software, because we only have Windows 98 and me. What my
questions is, that we I have the personal edition running on one of my two
machines. Will I be able to connect to the database from another machine.
We use a manufactoring program and it will be running a SQL database, when I
connect to my program is it going to give me an error about not being able
to connect to the personal edition? Thanks|||Rocky,
So, as per your plan, your database would be running SQL2000 personal
edition and the application connects to this database.Coming back to the
concurrent query limit, does many users use this application concurrently?
Personal edition as well as MSDE can support only upto 8 concurrent queries
before things get real slow and messy.
I must admit, even at this point, Iam not sure if this application is used
for dev purposes or production.Can you please answer that?
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Rocky" <anonymous@.discussions.microsoft.com> wrote in message
news:2A41E566-1039-48F4-8F2C-AF53CD8A6382@.microsoft.com...
> All that I will be doing with it is installing the SQL Server on a
machine, and connecting to the database through a program that we use.
>
> -- Dinesh T.K wrote: --
> Rocky,
> Is this solely for development purposes? Then go for SQL2000 dev
edition.It
> comes cheap too!Refer the below url for pricing details:
> 'Developer Edition Licensing'
> http://www.microsoft.com/sql/howtobuy/development.asp
>
> Yes.Please note that personal edition has a documented limitation of
> handling concurrent queries.
>
not[vbcol=seagreen]
> being able to connect to the personal edition?
> Well, since I have not seen the connection code, I cant say for
sure.But ,
> provided the connection code is correct, there is no reason why it
wont
> connect to the SQLServer just because its a personal edition.
>
> --
> Dinesh
> SQL Server MVP
> --
> --
> SQL Server FAQ at
> http://www.tkdinesh.com
> "rocky" <anonymous@.discussions.microsoft.com> wrote in message
> news:B8C34350-D3A5-4BAB-A9DF-22719F142E01@.microsoft.com...
use the[vbcol=seagreen]
> personal edition software, because we only have Windows 98 and me.
What my
> questions is, that we I have the personal edition running on one of
my two
> machines. Will I be able to connect to the database from another
machine.
> We use a manufactoring program and it will be running a SQL database,
when I
> connect to my program is it going to give me an error about not being
able
> to connect to the personal edition? Thanks
>
>|||First of all thanks for all your help. There will only be two at most concu
rrently connected. That is if you count the server as one. As far as your
question I guess I am confused and I am sorry for that. Whether or not it i
s development or not. I th
ink it is just production. Because all we are doing is using a program that
connects to the database, and updates the database as necessary, so whether
or not that is developement or production I am not sure. From reading off
of Microsoft's site it wasn
't clear if I could connect more than one machines to a personal edition ser
ver, but from your answer I guess I can. So thanks for you help.

permissions to deploy to one folder

I have created a staging folder in reporting services. The idea is to allow
developers to deploy to this folder only in order to test their reports and
to then have the dba's move the reports to the users' area.
Is it possible to give the developer group rights to deploy to this staging
folder only?Yes, just click on the properties tab for the desired folder and then the
secrurities tab. From here you can set the permission how you like.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:679A12F5-45D5-465F-9BE9-7F0166A69BD6@.microsoft.com...
>I have created a staging folder in reporting services. The idea is to allow
> developers to deploy to this folder only in order to test their reports
> and
> to then have the dba's move the reports to the users' area.
> Is it possible to give the developer group rights to deploy to this
> staging
> folder only?

Permission required to run the Profiler and the Debugger

Does anyone know what permission to grant (other than SA) in order to enable
the usage of SQL Profiler 2005 and the debugger on a 2005 installation?
thanks
Cordelia
Give the permission ALTER TRACE to execute profiler.
Debugging can be done trhu only the visual studio.
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124550
Thanks
Hari
"Cordelia" <Cordelia@.discussions.microsoft.com> wrote in message
news:57E838C3-F49D-4283-BF8F-D37701E195CA@.microsoft.com...
> Does anyone know what permission to grant (other than SA) in order to
> enable
> the usage of SQL Profiler 2005 and the debugger on a 2005 installation?
> thanks
> Cordelia
|||Thanks Hari for the info. Granting ALTER TRACE seems to have done the trick
for runing the Profiler. According to the BOL, ALTER TRACE enable the
account to replay a trace file. Any idea what else does ALTER TRACE provide
permission for?
As for the debugger, does an account require any permission setup to be able
to debug via Visual Studio?
Cordelia
"Hari Prasad" wrote:

>
> Give the permission ALTER TRACE to execute profiler.
> Debugging can be done trhu only the visual studio.
> http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124550
>
> Thanks
> Hari
> "Cordelia" <Cordelia@.discussions.microsoft.com> wrote in message
> news:57E838C3-F49D-4283-BF8F-D37701E195CA@.microsoft.com...
>
>