MSDE max field size?

Hi,
I have MSDE installed on my computer and I'm usingWeb Data Administrator to manage my databses. The problem is that whenever I add a column with a length of more than 8000, I get the following error:
Length must be between 0 and 8000
If I create the column programmatically then i get this error:
The following error occured while executing the query:
Server: Msg 131, Level 15, State 2, Line 2
The size (8005) given to the column 'Article' exceeds the maximum allowed for any data type (8000).
I need several columns that can hold around32,000 characters. What's the deal? Is this a limit with MSDE, or am Imissing something?
Thanks

::Is this a limit with MSDE, or am I missing something?

Yoou miss reading the documentation.

ROWS in SQL Server - not just MSDE - are limited to 8000 bytes. This means the whole row, not a single field.

For longer data there are special datatypes (like text or ntext) that do not store the data in the row, but use separate tables. They are limited (no indexing and some other limitations).They work wonderfully with up to 2gb per field.

This is properly documented in the documentation for SQL Server, which I suggest you ahve a look at. It is also available online at Microsoft.

|||

The documentation to which thona is referring (but for which he never provides a link) is calledSQL Server 2000 Books Online. It is a free reference from Microsoft and is one which I personally refer to many times a day. It is a large download but well worth the time.

The same content is available at the MSDN site:Getting Started with SQL Server Books Online.

|||What Sql Server datatype would give me the equivalent of the "Memo" type in Access?
Thanks
|||That would be text (or ntext if you need to support international characters).
|||I'm sorry, but I should have asked this in my previous post...
What length should I specify?
Like... text(16), or text(32)?
Am I correct in assuming that (16) would give me 32768 characters?
Thanx
|||

stevesimon wrote:

I'm sorry, but I should have asked this in my previous post...
What length should I specify?
Like... text(16), or text(32)?
Am I correct in assuming that (16) would give me 32768 characters?
Thanx

I wouldn't specify a length at all -- it is not needed for the text data type.
As suggested, Books Online and MSDN are excellent references and youcould easily find this information yourself. According tontext, text, and image the text data type can store 2,147,483,647 characters.
|||

Just a qwuestion -why are you so reluctant to even LOOK into the online documentation ONCE?

Btw, tehe equivalent of Access "Memo" is NOT text - it is ntext. Access has no notion of non-unicode strings.

|||I did look at the documentation, but could not find the answer to my specific question.
|||Try using OLE(Object Linking and Embedding) in Access to store them asWord and import them into MSDE as image files and most of your problemswill go away. Hope this helps.
Kind regards,
Gift Peddie

MSDE management

When I install msde on a W2K professional and go into My Computer/manage and
click on Services and Applications, it shows a MS Sql Server entry from which
I can manage msde. When I install on W2003 server, it's not there. Is this
by design ?
hi,
Dave Mc wrote:
> When I install msde on a W2K professional and go into My
> Computer/manage and click on Services and Applications, it shows a MS
> Sql Server entry from which I can manage msde. When I install on
> W2003 server, it's not there. Is this by design ?
Start -> Administrative Tools-> Services
Start -> Control Panel-> Administrative Tools-> Services
Start -> All Programs-> Administrative Tools-> Services
Start -> My Computer-> Change a setting-> Administrative Tools-> Services
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I guess I didn't make it clear. The service is there on my W2003 server.
What's different is on my W2k pro, under My Computer/Manage/Services and
Applications, It shows Microsoft SQL Servers/MYLOCALSERVER/ then all the
"normal" Enterprise Manager items -- Databases, Maintenance Plans, etc. As
far as I know, MSDE is the only SQL ever installed on my workstation. When I
do an MSDE install on the server, though, the service is there and running
but I don't get the management tools as above. I was surprised when I saw
them on my workstation because I thought to manage msde, you were either
stuck with command line osql statements or third party "Enterprise Manager
like" management tools. So, I'm a little confused.
Thanks
"Andrea Montanari" wrote:

> hi,
> Dave Mc wrote:
> Start -> Administrative Tools-> Services
> Start -> Control Panel-> Administrative Tools-> Services
> Start -> All Programs-> Administrative Tools-> Services
> Start -> My Computer-> Change a setting-> Administrative Tools-> Services
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Dave,
Dave Mc wrote:
> I guess I didn't make it clear. The service is there on my W2003
> server. What's different is on my W2k pro, under My
> Computer/Manage/Services and Applications, It shows Microsoft SQL
> Servers/MYLOCALSERVER/ then all the "normal" Enterprise Manager
> items -- Databases, Maintenance Plans, etc. As far as I know, MSDE
> is the only SQL ever installed on my workstation. When I do an MSDE
> install on the server, though, the service is there and running but
> I don't get the management tools as above. I was surprised when I
> saw them on my workstation because I thought to manage msde, you were
> either stuck with command line osql statements or third party
> "Enterprise Manager like" management tools. So, I'm a little
> confused.
> Thanks
MSDE comes with no management tool but oSql.exe, the command line tool, full
stop.
if you find them on your pc(s), they have been arbitrarily installed by the
SQL Server CD-Rom and no other way..

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You are right. I did some more checking and found that someone had been
doing development on this pc and installed sql 2000 from their msdn cd. Now,
my question is, am I violating a license agreement if I just install Client
Tools from a SQL cd even though I am only installing msde ?
Thanks
"Andrea Montanari" wrote:

> hi Dave,
> Dave Mc wrote:
> MSDE comes with no management tool but oSql.exe, the command line tool, full
> stop.
> if you find them on your pc(s), they have been arbitrarily installed by the
> SQL Server CD-Rom and no other way..
>
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Dave,
Dave Mc wrote:
> You are right. I did some more checking and found that someone had
> been doing development on this pc and installed sql 2000 from their
> msdn cd. Now, my question is, am I violating a license agreement if
> I just install Client Tools from a SQL cd even though I am only
> installing msde ?
AFAIK, unfortunately YES...
in order to manage MSDE instance, you can only rely on self made tools or
third arty tools, but not on SQL Server Client Tools..
please have a look at this post, http://tinyurl.com/4u2zh , by a Microsoft
representative
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE Licencing confusion

Hi,
If I install MSDE on a live deployed server and manage it using SQL Server
2000 DEVELOPER Edition, which is installed on another machine, would I be
breaking the
licencing rules?
By manage, I mean use Enterprise Manager to perform maintenance tasks etc.
Our situation is that we currently have SQL Server 7 running our business
databases. We want to upgrade to SQL Server 2000 but only have a Developer
Edition which came with our MSDN kit.
We could upgrade to v7 to v2000 but I wanted to first consider the
alternative (cheaper) options.
Ta.
Bugger, posted the question before reading this line on
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
"Note: The tools and services included with SQL Server Developer Edition may
not be used to manage production server environments."
Sorry about that. Any comments further to that or suggestions regarding what
I'm considering doing would still be most welcome.
Thanks again.
|||hi,
Swaffs wrote:
> Hi,
> If I install MSDE on a live deployed server and manage it using SQL
> Server 2000 DEVELOPER Edition, which is installed on another machine,
> would I be breaking the
> licencing rules?
> By manage, I mean use Enterprise Manager to perform maintenance tasks
> etc.
> Our situation is that we currently have SQL Server 7 running our
> business databases. We want to upgrade to SQL Server 2000 but only
> have a Developer Edition which came with our MSDN kit.
> We could upgrade to v7 to v2000 but I wanted to first consider the
> alternative (cheaper) options.
>
you would break the EULA this way.. .but you can perhaps have a look at
http://www.microsoft.com/downloads/d...displaylang=en
... it's the evaluation edition fo SQL Server 2000 with 120 days trial..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Have you tried any other tools (free tolls) to manage your database?
Linda
"Swaffs" <Swaffs@.discussions.microsoft.com> wrote in message
news:BA9533BB-5B31-430E-85CB-E709C420CF20@.microsoft.com...
> Bugger, posted the question before reading this line on
> http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
> "Note: The tools and services included with SQL Server Developer Edition
> may
> not be used to manage production server environments."
> Sorry about that. Any comments further to that or suggestions regarding
> what
> I'm considering doing would still be most welcome.
> Thanks again.