Difference between SQL 2000 st. and SQL 2000 Enterprise

Hi there
I feel a bit silly here. If spent the last 45 mins searching the web trying
to find a definite list of the differences between SQL 2000 Standard and SQL
2000 Enterprise. All the links at microsoft.com seem to redirect to the 2005
version. If anyone can link me to a feature comparison or know the numbers
off the top of their head I would be grateful. The most pressing question is
this:
What if I buy a standard edition and install it on a server with 4Gb RAM,
would I:
Violate my license since standard only supports up to 2 Gb?
or would the SQL server simply just use only 2Gb RAM and work just fine and
no license would be violated?
Thanks in advance
IbIb,
In your SQL Server 2000 Books Online is a topic "Features Supported by the
Editions of SQL Server 2000" that will give general guidance on features.
Installing standard edition on a server with more RAM will not violate a
license. SQL Server will only use as much memory as it can.
RLF
"Ib Schrader" <ibschrader@.gmail.com> wrote in message
news:e1LaFcw6HHA.2632@.TK2MSFTNGP06.phx.gbl...
> Hi there
> I feel a bit silly here. If spent the last 45 mins searching the web
> trying to find a definite list of the differences between SQL 2000
> Standard and SQL 2000 Enterprise. All the links at microsoft.com seem to
> redirect to the 2005 version. If anyone can link me to a feature
> comparison or know the numbers off the top of their head I would be
> grateful. The most pressing question is this:
> What if I buy a standard edition and install it on a server with 4Gb RAM,
> would I:
> Violate my license since standard only supports up to 2 Gb?
> or would the SQL server simply just use only 2Gb RAM and work just fine
> and no license would be violated?
> Thanks in advance
> Ib
>|||The information is in Books on Line, the documentation. You could
download and install that from the Microsoft site, or read it on the
web.
http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx
That should put you int he neighborhood.
Roy Harvey
Beacon Falls, CT
On Thu, 30 Aug 2007 15:09:36 +0200, "Ib Schrader"
<ibschrader@.gmail.com> wrote:
>Hi there
>I feel a bit silly here. If spent the last 45 mins searching the web trying
>to find a definite list of the differences between SQL 2000 Standard and SQL
>2000 Enterprise. All the links at microsoft.com seem to redirect to the 2005
>version. If anyone can link me to a feature comparison or know the numbers
>off the top of their head I would be grateful. The most pressing question is
>this:
>What if I buy a standard edition and install it on a server with 4Gb RAM,
>would I:
>Violate my license since standard only supports up to 2 Gb?
>or would the SQL server simply just use only 2Gb RAM and work just fine and
>no license would be violated?
>Thanks in advance
>Ib
>|||Books online..never knew something like that existed.
Thanks to both of you
"Roy Harvey" <roy_harvey@.snet.net> wrote in message
news:nmidd351bfo31q14ee6hufgq5jf75r2e89@.4ax.com...
> The information is in Books on Line, the documentation. You could
> download and install that from the Microsoft site, or read it on the
> web.
> http://msdn2.microsoft.com/en-us/library/aa175266(SQL.80).aspx
> That should put you int he neighborhood.
> Roy Harvey
> Beacon Falls, CT
> On Thu, 30 Aug 2007 15:09:36 +0200, "Ib Schrader"
> <ibschrader@.gmail.com> wrote:
>>Hi there
>>I feel a bit silly here. If spent the last 45 mins searching the web
>>trying
>>to find a definite list of the differences between SQL 2000 Standard and
>>SQL
>>2000 Enterprise. All the links at microsoft.com seem to redirect to the
>>2005
>>version. If anyone can link me to a feature comparison or know the numbers
>>off the top of their head I would be grateful. The most pressing question
>>is
>>this:
>>What if I buy a standard edition and install it on a server with 4Gb RAM,
>>would I:
>>Violate my license since standard only supports up to 2 Gb?
>>or would the SQL server simply just use only 2Gb RAM and work just fine
>>and
>>no license would be violated?
>>Thanks in advance
>>Ib

Did the Crystal reports Support Web

Hi this is murali,
can i know did the crystal Reports Supports Web Database.
I want to connect a web database to display as reports.Refer here
www.businessobjects.com

Development tool for first time developer?

I am about to start developing a web app using MS SQL Server and was wondering whether there is any tool that I can use to test queries towards a remote server?

Something like a command line or an easy way I can write queries and run them straight away through the server and check results? It is my first time developing in SQL so I need something that allows me to play around with queries in the server and check results to quickly get a hang os MS SQL Server syntax, stored procedures and such.

Best Regards

Alethenorio

From the nature of your question, I assume that you are using SQL Server Express.

Yes, you can download the SQL Server Management Studio Express client tools for working with SQL Server Express.

SSMSE and other resources are available from these links:

SQL Server 2005 Express Edition (Advanced/SSMS/BI Toolkit)
http://tinyurl.com/yelwr9 (SSMSE)

SQL Server 2005 SSMS Express Tutorial
http://tinyurl.com/nqsca

SQL Server 2005 Express Books Online Express Edition
http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F

SQL Server 2005 Express Video Learning
http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx#1

|||

Thanks Arnie.

To be honest I am doing a project for a company and I have not yet got access to the web hotel but if express is the lower version of microsoft's SQl server I believe it is not the version they run here. They probably run the full capable version (Whatever that is).

Would you suggest the same tool for such or is there another tool better fit to handle higher versions of SQl server?

Regards

Alex

|||

You may wish to consider getting SQL Server Express for your own computer, and the client tools, for your learning process.

The version of SQL Server Management Studio (SSMSE) that works with SQL Express is very similar to the version provided with the 'paid' Editions.

Good luck as you get up to speed. I think you will enjoy learning about SQL Server.

Development tool choice for SQL Server

Is VB.net the most logical choice of a RAD tool to use with MS SQL Server? Is VB.net strictly for web apps or can you use it to create projects that run as executables off the server?
JustStartinOutwe use java and websphere|||VB.NET can be used for web applications or for building executables or DLLs (actually you are creating DLLs when building .NET web apps anyway). The .NET development tools, which include VB.NET, C#, and others, are not RAD tools but will allow you to develop using RAD methodology. Depending on your programming background, you may find C# easier to use than VB.NET. It is syntaxically similar to C, c++ and Java.

HTH
Tim|||I find C# infinitely easier to read and code than VB.

also there are certain useful keywords in C# that have no equivalent (i think) in VB (like using and yield).|||I think Access is about the quickest for simple apps. It has very good support for SQL Server. We have a comprehensive app in Access that uses VB 6 in the code-behind.

The developer wrote an entire purchasing and inventory system in 4 months, from inception to implementation. It has about 20 menu items and uses Stored Procedures for all SQL Server access. It's fairly stable and very fast, however requires installation at each workstation. He could have done it in half that time except for a very complex (Dynamic SQL) interface into our existing Sales Order system.

VB.Net, as with all the .NET languages, compiles into a Common Language. As mentioned, the C# language has more complete support of the .NET platform and enjoys wider support and programmer base, but the end result of VB.NET and C#.NET are identical.

In my opinion, the only reason for VB.NET is to provide an easy learning curve for all the VB 6 developers. It's C# with a VB6 like syntax, what's the point, just use C#. (note: C#, although modeled after C++, is far less complex to use, and in truth was modeled after Java)

With .NET, you can create console applications, web applications, desktop applications (the traditional forms based program that gets installed on each desktop), and others. Usage of any require the .NET Platform to be installed. However; using a web page that's implemented by ASP.NET does not require anything special, just a browser. The programmer may have to work out differences with particular browsers (example: Netscape is notorious from straying from the standards, nearly as bad as IE) but they DO NOT require the .NET platform to function.

ASP.NET is the programmer's platform for Microsoft's next generation of IIS (web server) and is implemented using .NET. It's a pretty amazing platform. I'm only starting to use it but after 4 years of using ASP, there's simply no comparison. In ASP.NET, you write your forms, database access, etc similarly to a desktop appliation then ASP.NET actually converts stuff to HTML and manages the web sessions. According to the forword in my ASP.NET book (by APress) MySpace.com (who gets over a billion hits a day) recently converted from ColdFusion to ASP.NET and that's saying a lot.

(Regarding Access) As with most simple platforms, there's a point of diminishing returns where it's actually more difficult due to the complexity of what you're trying to achieve. So if you don't have a well seasoned Access developer, and your task is very complex, I'd not suggest Access. For a fairly simple series of screens (like master file maintenance, creating test data, etc), it's nice.

For reporting, I use Crystal Reports (and it serves up nicely on our web server, with license-free report distribution) and (combined with SQL Server's backend RAD SQL development tools) it is the most productive environment I've ever experienced. I can satisfy nearly any permanent reporting request in under 1 day, and often in 1 or 2 hours. Maintenance is also a dream. Factory workorders, invoices, sales analysis, Purchasing history, etc etc.|||Actually this system is currently written in Access and I was looking to do a rewrite using something more sophisticated and robust and that is why I was looking at choosing some newer technology. Our Access applications around here all have the same unprofessional look.|||Well access like VB is a FAT client.

We chose java because it's thin and uses servlets

No, I don't know Java...front-end development....ewwwwwww|||Actually this system is currently written in Access and I was looking to do a rewrite using something more sophisticated and robust and that is why I was looking at choosing some newer technology. Our Access applications around here all have the same unprofessional look.
They're all pretty equally capable of offering an unprofessional look and feel.

Don't confuse the front-end look-n-feel with back-end capability. They all use the same SQL Server.

Java and .NET are pretty similar, however .NET is more suited to the Windows platform. .NET allows for a "thin client" (ASP.NET combined with language of choice, VB.NET, C#.NET, etc) and "fat client" (Windows Forms app combined with .NET language of choice).

Going to either is a total rewrite, and even re-design. The database table layout and screens can likely stay (mostly) the same, but it's a non-trivial task. If you just want prettier screens, you could get a better Access programmer to just move things around and add some navagation capability.

Suggest re-posting your question in the language support forums. I don't think the database guys care too much about how the front-end is implemented.|||No, I don't know Java...front-end development....ewwwwwww

java isn't strictly a front-end language - plenty of server apps have been implemented in java. you can build a RDBMS with it even :)

http://sourceforge.net/projects/daffodildb|||Thanks Vich, but I don't want to give my job away to a 'better access programmer'. (ha, ha) I would like to learn something new to get my skills back sharp and to help me stay marketable should I ever want to leave here. At this job I have plenty of flexibility (and spare time) and I essentially work by myself (as far as development goes). Now is a good time for self-development.|||Thanks Vich, but I don't want to give my job away to a 'better access programmer'. (ha, ha) I would like to learn something new to get my skills back sharp and to help me stay marketable should I ever want to leave here. At this job I have plenty of flexibility (and spare time) and I essentially work by myself (as far as development goes). Now is a good time for self-development.

Fine, then ascend to mount olympus and become a dba|||since you are working on Access, VB.Net seems a logical tool of choice.
I come from VB background but i've managed(at last!) to work equally comfortable on Vb.Net & C#.

As far as the app is a desktop one it should fairly easy to wsitch between the 2. But i think to create a Web App you will need to put few extra hours in learning and implemntation.|||I use Access as a front end MDB with an SQL 2005 back end. I have also played with the ADP form of Access front end. I am moving to VB.Net due to getting a timeout error on a key part of the application which is just impossible to solve. But I am finding the move very difficult as it is a rather steep learning curve.

If you are going to use the Express Edition note that it is only configured to use the wizards with the express version of SQL 2005.

Development Environment Needs?

Trying to figure out what development enviroment we need in order to
do the following:

- develop a non-native SQL server stored procedure;
- call a web service or java program from the stored procedure;
- return static values;
- call the stored procedure from a view.

How do I get a hold of the right tools and what do I need to put the
pieces together?

Obviously, I've not used SQL server and I'm looking for the basic
starting point.

Thanks!CG (chelseagraylin@.hotmail.com) writes:
> Trying to figure out what development enviroment we need in order to
> do the following:
> - develop a non-native SQL server stored procedure;
> - call a web service or java program from the stored procedure;
> - return static values;
> - call the stored procedure from a view.

You cannot call stored procedures from views. You can call extended
stored procedures from used-defined functions though, and these you
call from views. (Or use table-valued functions which are basically
parameterized views, and which can be multi-statement.)

Typically you develop extended stored procedures in C++. If you want to
talk .Net you would need a COM interop.

Since you appear to be forward-looking, you might find interest in
the upcoming version of SQL Server, where you can program CLR directly
in SQL Server. In SQL 2005 you can develop the function directly in
CLR. To call a web service there would still be a few things to go
through, but it would certainly be easier.

Beta 2 of SQL Server is expected soon, and this will be a public beta.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||So if I want to do this with the current version (yes, looks like this
will be much easier in the future!), I need a SQL Server environment
set up (hopefully just the desktop version) and then I need an
environment to be able to write a C++ program that is accessible by
SQL Server?

Sounds so easy...|||CG (chelseagraylin@.hotmail.com) writes:
> So if I want to do this with the current version (yes, looks like this
> will be much easier in the future!), I need a SQL Server environment
> set up (hopefully just the desktop version) and then I need an
> environment to be able to write a C++ program that is accessible by
> SQL Server?

For SQL Server I would recommend using Developer Edition, which is at
49 USD only. Developer Edition comes with graphic tools, and having
Query Analyzer to submit queries is invaluable.

However, once you go in production, you are better of with MSDE, since
Developer Edition is not licensed for production. (And for some strange
reason, the graphic tools can be used against MSDE according to the
license.)

You will also need a couple of include files and link libraries. They
come with Devloper Edition.

For the C++ environment I am not really the guy to ask, but Visual
Studio is of course a safe bet. If you go for GNU C++ to use freeware,
you will probably need the Platform SDK, which I have no idea how it
is available outside VS.

> Sounds so easy...

Getting the environment is indeed the easy part. The actual development
is likely to be tougher. Writing extended stored procedures is not for
the faint of heart. Keep in mind that they execute in-process, so an
access violation in your XP can crash the entire SQL Server.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Erland Sommarskog (esquel@.sommarskog.se) writes:
> (And for some strange reason, the graphic tools can be used against MSDE
> according to the license.)

An important word disappeared here, so I take it again:

> (And for some strange reason, the graphic tools can *not* be used against
> MSDE according to the license.)

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Hi

To add to Erland's post...

Don't forget source code control, such as Visual Source Safe or PVCS... If
you go the whole Microsoft suite then a MSDN subscription would be an
excellent investment.

John

"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns951B2905B452Yazorman@.127.0.0.1...
> CG (chelseagraylin@.hotmail.com) writes:
> > So if I want to do this with the current version (yes, looks like this
> > will be much easier in the future!), I need a SQL Server environment
> > set up (hopefully just the desktop version) and then I need an
> > environment to be able to write a C++ program that is accessible by
> > SQL Server?
> For SQL Server I would recommend using Developer Edition, which is at
> 49 USD only. Developer Edition comes with graphic tools, and having
> Query Analyzer to submit queries is invaluable.
> However, once you go in production, you are better of with MSDE, since
> Developer Edition is not licensed for production. (And for some strange
> reason, the graphic tools can be used against MSDE according to the
> license.)
> You will also need a couple of include files and link libraries. They
> come with Devloper Edition.
> For the C++ environment I am not really the guy to ask, but Visual
> Studio is of course a safe bet. If you go for GNU C++ to use freeware,
> you will probably need the Platform SDK, which I have no idea how it
> is available outside VS.
> > Sounds so easy...
> Getting the environment is indeed the easy part. The actual development
> is likely to be tougher. Writing extended stored procedures is not for
> the faint of heart. Keep in mind that they execute in-process, so an
> access violation in your XP can crash the entire SQL Server.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

Development database, what to use?

The web hotel I am using have MS SQL server installed. I do not have it on my local development PC.

How do I develop and test a website, locally, using MS SQL DB, without having MS SQL sever. Is there any light MS SQL sever I can use with a good user interface, and then just upload the DB to MS SQL server?

Please advise, NewBe2Get SQL Server developer edition. And you are set.

SQL Server IS light, compared to the serious competition.

Developing WAP using ASP.NET and Web Services

Hi all,

I would like to develop WAP using ASP.NET which can connect to the Database( MS SQL Server ). Is it possible to do it? I try to find the tutorial but I cannot find it.

Another thing I want to ask is can I connect the WAP to the web services that I create using ASP.NET, anyone can tell me how to do it.

Thanks, Regards.

REDWAP is something that is sent to and displayed on the client. ASP.NET and Web Services are server side technologies. You can certainly have your ASP.NET application call out to a Web service, and then send the results to your WAP device.

Developing a SQL server DB (noob question)

I'm beginning development on a medium/ sized in-house web based system. Well moving from asp/mysql to asp.net/sql server. Re-doing DB design as well.

My question is does it make sense for me to develop the SQL DB in Visual Studio 2005 pro, and then later move it to a real SQL server? Or basically what is the best and/or most practical way to do this development. Any other IDE's out there?

Thanks

I'd just use SQL Server from the outset. I find Entreprise Manager cumbersome to use, so I just use it to create the database, then create an Access adp file as my main interface to create tables, views and stored procedures. adp files give you the speed and functionality of Access when manipulating SQL Server DB's. I do go back to Entreprise Manager to do things like create table relationships.

|||

So you're basically suggesting developing the DB using the Access IDE, correct? I fail to see how that would be beneficial, Access has different data types than SQL server. When using an ADP file would Access then know the correct column types? Also, how would that ease the development of my web application?

Does anyone else agree with the above comment? The lack of responses makes me feel like everyone else thinks that is the best answer.

|||

With an adp file, you are essentially using the interface of Access to manage your SQL Database. It is still a full SQL Server database; it is not an mdb with native Access types. This means that the datatypes available and field options are all from SQL Server, (e.g. you have VARCHAR instead of Text, etc). You can also do things that create Stored Procedures. It has most of the functionality of Entreprise Manager for creating and maintaining your database.

Reasons I like adp files over Entreprise Manager:

1. adp files allow you to build forms for basic data entry / editing

2. Entreprise Manager Stored Procedure windows are modal. If you are writing a procedure and need to look up a field name in a table, you have to close the window (which you can't do with partially written syntax) first. with an adp the Procedure window can be minimized or tiled.

3. adp files allow you to sort and filter tables in datasheet view. Entreprise Manager doesn't.

4. Speed. adp files are faster for looking up data.

adp files do lack some features, such as the ability to build relationships or triggers. For this use Entreprise Manager.

Developer Express & Database issues

I Am developing a simple app with a database. All has been going fine until now, the following is occuring:

In Visual Web Developer 2005 Express if I connect to the database and view some table data I can do that fine but then as soon as I try to view a page in the browser I get the error:
Login failed for user 'MachineName\ASPNET'
If in web developer I go to the database explorer and close the connection to the database then refresh the page it all works fine.

Anyone have anyideas on how to correct this?

Thanks
Scott

This is a frequently asked issue The login 'MachineName\ASPNET' is used by IIS when your website trying to connect to SQL with Window Authentication (Integrated Security=SSPI). So in this case just add the account to SQL Server Logins with proper database permissions, which can be easily done in Management Studio: go to Security->Logins->right clich and choose add login->add the Windows account 'MachineName\ASPNET' and give it permissions (or simply add it to sysadmin server role). You can download Management Studio Express from here:

http://msdn.microsoft.com/vstudio/express/sql/download/

developed in 2005, need to go back to 2000

I've developed a web application and to be honest I've been a bit dumb and not checked with my hosts. I assumed they used SQL Server 2005. But no, they only use 2000.

I'm sure I'll come across more problems but the first I'm having is I've used the ROW_NUMBER() function in a few stored procedures, but in 2000 I'm getting this error message

'ROW_NUMBER' is not a recognized function name.

Here is the stored procedure for reference

SELECT RowNumFROM (SELECT id, category, ROW_NUMBER() OVER(ORDER BY id) as RowNum FROM custrecords ) as CustRecord

anyone know the SQL Server 2000 equivalent?

Regrettably ROW_NUMBER is a new feature with SQL2005.

What precisely are you trying to achive with your SELECT statement?

|||

there isn't a equivalent of row_number() in SQL Server 2000. Depending on your requirement, you can use a subquery something like

select count(*) from tbl where <condition>

to do it.

Maybe you can explain what are you trying to do here. Or alternatively do the row numbering in your ASP.NET

|||

khtan:

there isn't a equivalent of row_number() in SQL Server 2000. Depending on your requirement, you can use a subquery something like

select count(*) from tbl where <condition>?

to do it.

Maybe you can explain what are you trying to do here. Or alternatively do the row numbering in your ASP.NET
?

thanks khtan, I'll try using the Count keyword method instead|||

Provided you read the dataset first, you can also have output parameters on the stored procedure that gets your batch size. Have a look at http://www.4guysfromrolla.com/webtech/041206-1.shtml (Efficiently Paging Through Large Result Sets in SQL Server 2000)

|||

TATWORTH:

Provided you read the dataset first, you can also have output parameters on the stored procedure that gets your batch size. Have a look at http://www.4guysfromrolla.com/webtech/041206-1.shtml ( Efficiently Paging Through Large Result Sets in SQL Server 2000)

wow, thanks tatworth. I started on the tutorial link you supplied above and eventually found myself doing the tutorial (A more efficent method for paging through large result sets : link below)

http://www.4guysfromrolla.com/webtech/042606-1.shtml

But I've hit a problem. Like I say I've done the tut above and it works great...if you only want the results to be in order of id.

I'm trying to change the order by other fields (name, date of birth) but I'm not getting anywhere.

Any one any tips?

|||

Please always remember when using output parameters and a dataset, to read the dataset before the output parameters - there is a "bug"/"feature" that only populates the output parameters after the dataset has been read.

As to your sort problem, the solution pobably lies along using "date of birth and id" instead of just "date of birth" - please post an example of the revised TSQL together with a script to create the table. I will look at it and attempt a fix the problem; however it may not be until next weekend that I can look at it.

|||

TATWORTH:

Please always remember when using output parameters and a dataset, to read the dataset before the output parameters - there is a "bug"/"feature" that only populates the output parameters after the dataset has been read.

As to your sort problem, the solution pobably lies along using "date of birth and id" instead of just "date of birth" - please post an example of the revised TSQL together with a script to create the table. I will look at it and attempt a fix the problem; however it may not be until next weekend that I can look at it.

wow, thanks tatworth

This is the stored procedure I created from the tutorial above, like I say it works if the order by is id, anything else and it doesn't work

ALTER PROCEDURE uk_members
(
@.username VarChar(20),
@.startRowIndex int,
@.maximumRows int
)
AS
DECLARE @.first_id int

SET ROWCOUNT @.startRowIndex

SELECT @.first_id = id FROM uk_orders
WHERE (username=@.username) AND (itemstat <> 'DELETE') ORDER BY id

SET ROWCOUNT @.maximumRows

SELECT id, username, suppliername, product, quantity
FROM uk_orders WHERE
(id >= @.first_id) AND (username=@.username) AND (suppliername <> 'SMITHS') ORDER BY id

SET ROWCOUNT 0

I've been messing around with the code but not got anywhere.

I really appreciate your help and of course anyone else offering any help is also really appreciated.