RE: OT: Local MS SQL Server
This brings up another question: Is there a way to install my copy of MS SQL Server onto my XP machine to be used for dev? When I try, it only allows me to install the client stuff (Enterprise Manager and Query Analyzer). Rodger -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 12:05 PM To: CF-Talk Subject: RE: OT: Local MS SQL Server Thanks, that's what I was hoping. David -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:44 PM To: CF-Talk Subject: Re: OT: Local MS SQL Server No, there is no difference. They work exactly the same, as you are literally getting the same product, just with a different license key. What they may be talking about is the OS they installed it on. Non server OSs will have a limit on the number of simultaneous network connections, which will affect resources that use the network, such as web servers and sql server. ~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182575 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Local MS SQL Server
From: Rodger [mailto:[EMAIL PROTECTED] This brings up another question: Is there a way to install my copy of MS SQL Server onto my XP machine to be used for dev? When I try, it only allows me to install the client stuff (Enterprise Manager and Query Analyzer). You need to get a copy of the desktop edition of sql server... That is the only one that will run on XP... Or any non server OS for that matter. It is included in the MSDN library if you have that.. If not, I think someone previosuly mentioned it is pretty cheap to buy... $49 or something.. Mike ~| Get the mailserver that powers this list at http://www.houseoffusion.com/banners/view.cfm?bannerid=17 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182588 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Local MS SQL Server
You can also just download MSDE, which is SQL Server 2000 minus the analysis services and Natural Language search facilities. You can connect to it using EM and/or Query Analyzer as well. http://www.microsoft.com/downloads/details.aspx?familyid=413744d1-a0bc-479f- bafa-e4b278eb9147displaylang=en Jeff Garza -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 5:34 AM To: CF-Talk Subject: RE: OT: Local MS SQL Server From: Rodger [mailto:[EMAIL PROTECTED] This brings up another question: Is there a way to install my copy of MS SQL Server onto my XP machine to be used for dev? When I try, it only allows me to install the client stuff (Enterprise Manager and Query Analyzer). You need to get a copy of the desktop edition of sql server... That is the only one that will run on XP... Or any non server OS for that matter. It is included in the MSDN library if you have that.. If not, I think someone previosuly mentioned it is pretty cheap to buy... $49 or something.. Mike ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182592 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Local MS SQL Server
I have an XP Pro machine. I don't currently have SQL 2000 installed due to a reformat. I have in the past though with no problems. David -Original Message- From: Rodger [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 2:36 AM To: CF-Talk Subject: RE: OT: Local MS SQL Server This brings up another question: Is there a way to install my copy of MS SQL Server onto my XP machine to be used for dev? When I try, it only allows me to install the client stuff (Enterprise Manager and Query Analyzer). Rodger -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 12:05 PM To: CF-Talk Subject: RE: OT: Local MS SQL Server Thanks, that's what I was hoping. David -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:44 PM To: CF-Talk Subject: Re: OT: Local MS SQL Server No, there is no difference. They work exactly the same, as you are literally getting the same product, just with a different license key. What they may be talking about is the OS they installed it on. Non server OSs will have a limit on the number of simultaneous network connections, which will affect resources that use the network, such as web servers and sql server. ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182600 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Local MS SQL Server
You need to get a copy of the desktop edition of sql server... That is the only one that will run on XP... Or any non server OS for that matter. It is included in the MSDN library if you have that.. If not, I think someone previosuly mentioned it is pretty cheap to buy... $49 or something.. The Developers Edition works fine on Windows XP. I don't think that's the same as the Desktop Edition. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182608 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Local MS SQL Server
You can get the Developer Edition of SQL Server 2000 for $49. Fully featured SQL Server, only stipulation is that you can use it only for non-production purposes. I use a local web and cfm server on my dev machine, but I use the MS SQL Server on my hosted account on the internet. Is there a way to install some flavor of MS SQL server onto a Win XP machine for dev purposes? I know that I could install it onto another W2K pc, real or virtual, but I would rather keep it on the same dev machine. Rodger ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182492 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Local MS SQL Server
I have a question about this... Are there ANY differences between the DEV and the PROD versions or SQL Server 2000? I have heard many people say different things but I cant find anything on Microsoft's site. I have heard that there is a concurrent user limitation. I have heard 5,10 and 15 users; everyone says something different. The reason I ask is to determine if a load test on a dev box would provide accurate results. Thanks, David -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 10:45 AM To: CF-Talk Subject: Re: OT: Local MS SQL Server You can get the Developer Edition of SQL Server 2000 for $49. Fully featured SQL Server, only stipulation is that you can use it only for non-production purposes. I use a local web and cfm server on my dev machine, but I use the MS SQL Server on my hosted account on the internet. Is there a way to install some flavor of MS SQL server onto a Win XP machine for dev purposes? I know that I could install it onto another W2K pc, real or virtual, but I would rather keep it on the same dev machine. Rodger ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182493 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Local MS SQL Server
No, there is no difference. They work exactly the same, as you are literally getting the same product, just with a different license key. What they may be talking about is the OS they installed it on. Non server OSs will have a limit on the number of simultaneous network connections, which will affect resources that use the network, such as web servers and sql server. I have a question about this... Are there ANY differences between the DEV and the PROD versions or SQL Server 2000? I have heard many people say different things but I cant find anything on Microsoft's site. I have heard that there is a concurrent user limitation. I have heard 5,10 and 15 users; everyone says something different. The reason I ask is to determine if a load test on a dev box would provide accurate results. Thanks, David -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 10:45 AM To: CF-Talk Subject: Re: OT: Local MS SQL Server You can get the Developer Edition of SQL Server 2000 for $49. Fully featured SQL Server, only stipulation is that you can use it only for non-production purposes. I use a local web and cfm server on my dev machine, but I use the MS SQL Server on my hosted account on the internet. Is there a way to install some flavor of MS SQL server onto a Win XP machine for dev purposes? I know that I could install it onto another W2K pc, real or virtual, but I would rather keep it on the same dev machine. Rodger ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182517 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: OT: Local MS SQL Server
Thanks, that's what I was hoping. David -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 2:44 PM To: CF-Talk Subject: Re: OT: Local MS SQL Server No, there is no difference. They work exactly the same, as you are literally getting the same product, just with a different license key. What they may be talking about is the OS they installed it on. Non server OSs will have a limit on the number of simultaneous network connections, which will affect resources that use the network, such as web servers and sql server. I have a question about this... Are there ANY differences between the DEV and the PROD versions or SQL Server 2000? I have heard many people say different things but I cant find anything on Microsoft's site. I have heard that there is a concurrent user limitation. I have heard 5,10 and 15 users; everyone says something different. The reason I ask is to determine if a load test on a dev box would provide accurate results. Thanks, David -Original Message- From: Kwang Suh [mailto:[EMAIL PROTECTED] Sent: Monday, October 25, 2004 10:45 AM To: CF-Talk Subject: Re: OT: Local MS SQL Server You can get the Developer Edition of SQL Server 2000 for $49. Fully featured SQL Server, only stipulation is that you can use it only for non-production purposes. I use a local web and cfm server on my dev machine, but I use the MS SQL Server on my hosted account on the internet. Is there a way to install some flavor of MS SQL server onto a Win XP machine for dev purposes? I know that I could install it onto another W2K pc, real or virtual, but I would rather keep it on the same dev machine. Rodger ~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182526 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
OT: Local MS SQL Server
I use a local web and cfm server on my dev machine, but I use the MS SQL Server on my hosted account on the internet. Is there a way to install some flavor of MS SQL server onto a Win XP machine for dev purposes? I know that I could install it onto another W2K pc, real or virtual, but I would rather keep it on the same dev machine. Rodger ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=37 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182450 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: OT: Local MS SQL Server
MSDE is what you need to look at.http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147displaylang=en jb. On Sun, 24 Oct 2004 12:15:44 -0700, Rodger [EMAIL PROTECTED] wrote: I use a local web and cfm server on my dev machine, but I use the MS SQL Server on my hosted account on the internet. Is there a way to install some flavor of MS SQL server onto a Win XP machine for dev purposes? I know that I could install it onto another W2K pc, real or virtual, but I would rather keep it on the same dev machine. Rodger ~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182452 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54