I am working at a company where I am the only .net programmer. I want to be
able to test sql server 2000 t-sql commands using Visual Studio.net 2005
professional version.
I have read articles from Microsoft saying that you should not test on a
production server. I would like to be able to install sql server 2000 on my
workstation so that I can run my tests on a 'test' sql server environment. My
company only has two SQL Server 2000 licenses and they do not think that I
can install sql server 2000 on my workstation since this would require
another license?
Thus based upon my professiaonl version of visual studio.net 2005, can I
install sql server 2000 as a 'development' platform only? If so, can you
point to a url that will show me I can do this?
If not, what would if cost for my company to let me install sql server
2000 on my workstation for development purposes? My company gets a Microsoft
discount.
Thanks!
I could think of 2 options:
- SQL Server express is free and support the same SQL
http://msdn.microsoft.com/vstudio/express/sql/
- You could alway create other database inside your SQL server.
Wendy Elizabeth - 29 Jun 2007 02:54 GMT
What does:"You could alway create other database inside your SQL server mean?"
Thanks!
> I could think of 2 options:
>
> - SQL Server express is free and support the same SQL
> http://msdn.microsoft.com/vstudio/express/sql/
> - You could alway create other database inside your SQL server.
Wendy Elizabeth - 29 Jun 2007 02:56 GMT
Companies are allowed to download sql server express on individual employees
workstations. Is that ok to do?
> I could think of 2 options:
>
> - SQL Server express is free and support the same SQL
> http://msdn.microsoft.com/vstudio/express/sql/
> - You could alway create other database inside your SQL server.
Lloyd Dupont - 29 Jun 2007 08:18 GMT
As much as you want!!

Signature
Regards,
Lloyd Dupont
NovaMind Software
Mind Mapping at its best
www.nova-mind.com
> Companies are allowed to download sql server express on individual
> employees
[quoted text clipped - 5 lines]
>> http://msdn.microsoft.com/vstudio/express/sql/
>> - You could alway create other database inside your SQL server.