Field Description Won't Save in MSDE Table

I've been working with numerous tables (creating them, that is) in
MSDE.
Everything's working fine aside from the fact that I can't seem to get
any descriptive information on any field in any table to save.
I add the descriptive text to the field, click to save the table with
the newly-entered description, the hourglass displays and the table is
being saved, and then when the design view of the table refreshes, the
descriptions I've just entered on the various fields are gone.
Anyone else have problems with this?
Thanks!
Sincerely,
Brad H. McCollum
bmccoll1@.midsouth.rr.com
What application are you using to design the table?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Brad H McCollum" <bmccoll1@.midsouth.rr.com> wrote in message
news:52031869.0405070905.9a523cb@.posting.google.co m...
> I've been working with numerous tables (creating them, that is) in
> MSDE.
> Everything's working fine aside from the fact that I can't seem to get
> any descriptive information on any field in any table to save.
> I add the descriptive text to the field, click to save the table with
> the newly-entered description, the hourglass displays and the table is
> being saved, and then when the design view of the table refreshes, the
> descriptions I've just entered on the various fields are gone.
> Anyone else have problems with this?
> Thanks!
> Sincerely,
> Brad H. McCollum
> bmccoll1@.midsouth.rr.com
|||I'm using MSDE Manager by Vale Software and haven't found anything
dealing with this issue on their website.
Thanks for any additional information/assistance/recommendations you
might be able to offer.
Sincerely,
Brad H. McCollum
bmccoll1@.midsouth.rr.com
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message news:<#DZOEnFNEHA.808@.tk2msftngp13.phx.gbl>...[vbcol=seagreen]
> What application are you using to design the table?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Brad H McCollum" <bmccoll1@.midsouth.rr.com> wrote in message
> news:52031869.0405070905.9a523cb@.posting.google.co m...
|||hi Brad,
"Brad H McCollum" <bmccoll1@.midsouth.rr.com> ha scritto nel messaggio
news:52031869.0405100708.c92ddd@.posting.google.com ...
> I'm using MSDE Manager by Vale Software and haven't found anything
> dealing with this issue on their website.
> Thanks for any additional information/assistance/recommendations you
> might be able to offer.
>
coul'd be a "feature" of MSDE Manager, as both Enterprise Manager and my own
management tool, available at the link following my sign., provide the
expectet behaviour...
please contact the application provider...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You should contact the vendor directly. I imagine it's not supported
because column descriptions are kind of superfluous. I tend to shy away
from storing column descriptions in the database, and instead opt for good
documentation on my tables. A user can always look at the documentation but
shouldn't be forced to read a (max 255?) character description by connecting
to the database.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Brad H McCollum" <bmccoll1@.midsouth.rr.com> wrote in message
news:52031869.0405100708.c92ddd@.posting.google.com ...
> I'm using MSDE Manager by Vale Software and haven't found anything
> dealing with this issue on their website.
> Thanks for any additional information/assistance/recommendations you
> might be able to offer.
> Sincerely,
> Brad H. McCollum
> bmccoll1@.midsouth.rr.com

few questions about sql server MSDE

what are pseudo tables
how queries run by MSDE
how stored procedures run in backend by MSDE
how triggers run by MSDE
where triggers and stored proc stored in MSDE and in which form
where logs are being maintained of transactions/DML statement by default

See my response to your identical posting in the Transact-SQL forum.

Often, the quality of the responses received is related to our ability to ‘bounce’ ideas off of each other. In the future, to make it easier for us to offer you assistance, and to prevent folks from wasting time on already answered questions, please don't post to multiple newsgroups. Choose the one that best fits your question and post there. Only post to another newsgroup if you get no answer in a day or two (or if you accidentally posted to the wrong newsgroup –and you indicate that you've already posted elsewhere).

few questions about MSDE...

what are pseudo tables
how queries run by MSDE
how stored procedures run in backend by MSDE
how triggers run by MSDE
where triggers and stored proc stored in MSDE and in which form
where logs are being maintained of transactions/DML statement by default

MSDE has been replaced with SQL Server 2005 Express.

For answers to your questions, as well as a source for tutorials, refer to Books Online.

SQL Server 2005 Express
http://msdn2.microsoft.com/en-us/sql/aa336346.aspx

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx
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

|||pls if u don't know the answer then don't reply any post ... and thanks for googling for me|||

Some times it is not bad approach to provide the link which answers all your qurestions. Arnie posted all the MSDN URLs, you need not google it. If you read these MSDN you will get answer for all your questions.

|||here we come to get answers.. ofcourse after going thru whole book every1 will get answer and if we have to go thru books then there is no point to come on such platforms. i put that question on two forums and this person asked me on other forum that i shouldn't post here .. i feel convinient to put on different so i could have early and better response. i don't think so any1 should mind on that atleast.
i went on these links but .. anyhow here i don't think so other should ask what to do and what not.. and if there is some question of any1 then that person shouldn't be forwarded to books atleast he can tell me chapter anyhow thanks m disappointed|||

Muhammad,

You have to understand that this forum is simply a medium, most often an unnecessary medium, where you'll find many patterns in responses. For example, the higher the posting count the reponder has, the more likely they will reply with links.

I share an equal frustration with you on not receiving a direct response here. I have found only 1 use for these forums and that is to post actual code, when I encounter a problem, simply for a second or third set of eyes. Outside of that, you'll find no real experts here and you'll discover that this forum has developed into an automated link service.

Just my twist on it,

Adamus

|||no man actually i don't agree with you. here i got answers most of the time and correct and to the point information. all fingers are not same. every person has his/her own approach. its very good platform. i m just waiting for answer here, not references or comments or advises .. i hope you got my point

i still say thanks to that person who try to answer my question but in fact i don't like stupid advises or comments.

i didnt mean to hurt any1. sorry if anything of mine hurt any1.

Fatal error

Dear All,
I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
this error in event viewer:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I have updated it to SP4 still the same problem. Does anyone know
anything about this error message please
Thank you very muchHi Andrew
Have you checked the windows event log for any messages that may indicate an
issue, also it is probably worth running CHKDSK to make sure that there is no
corruption on the disc drives.
John
"Huy (Andrew) V Nguyen" wrote:
> Dear All,
> I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
> this error in event viewer:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> I have updated it to SP4 still the same problem. Does anyone know
> anything about this error message please
> Thank you very much
>|||Hi John,
The error message is from Events Viewer. I check everything else at
around the same time nothing special. I had scheduled a CHKDSK to run
yesterday with no issues found. Any other idea please?
Andrew
John Bell wrote:
> Hi Andrew
> Have you checked the windows event log for any messages that may indicate an
> issue, also it is probably worth running CHKDSK to make sure that there is no
> corruption on the disc drives.
> John
> "Huy (Andrew) V Nguyen" wrote:
>> Dear All,
>> I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
>> this error in event viewer:
>> Error: 0, Severity: 19, State: 0
>> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
>> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
>> I have updated it to SP4 still the same problem. Does anyone know
>> anything about this error message please
>> Thank you very much|||Hi Andrew
Without knowing what was actually happening on the server at the time, it is
almost impossible to say what has caused this error. There are many issues
where the message may have been generated http://tinyurl.com/7kglf but I have
not found one that was not cured prior to SP4. You may want to raise a call
with PSS if this persists
http://support.microsoft.com/common/international.aspx?rdpath=1&gprid=2855&c1=508
John
"Huy (Andrew) V Nguyen" wrote:
> Hi John,
> The error message is from Events Viewer. I check everything else at
> around the same time nothing special. I had scheduled a CHKDSK to run
> yesterday with no issues found. Any other idea please?
> Andrew
> John Bell wrote:
> > Hi Andrew
> >
> > Have you checked the windows event log for any messages that may indicate an
> > issue, also it is probably worth running CHKDSK to make sure that there is no
> > corruption on the disc drives.
> >
> > John
> >
> > "Huy (Andrew) V Nguyen" wrote:
> >
> >> Dear All,
> >>
> >> I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
> >> this error in event viewer:
> >>
> >> Error: 0, Severity: 19, State: 0
> >> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> >> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> >>
> >> I have updated it to SP4 still the same problem. Does anyone know
> >> anything about this error message please
> >>
> >> Thank you very much
> >>
>|||I am getting the same error
SqlDumpExceptionHandler: Process 58 generated fatal exception running sQL
2000 sp4 and latest windows 2000 OS updates.
But I am also running in a clustered environment.
One of my servers never crashes (with pretty much the same patches etc.)
while the other server continues to crash.
I starting to think it has something to do with the actual machine hardware
and not the software.

Fatal error

Dear All,
I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
this error in event viewer:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I have updated it to SP4 still the same problem. Does anyone know
anything about this error message please
Thank you very much
Hi Andrew
Have you checked the windows event log for any messages that may indicate an
issue, also it is probably worth running CHKDSK to make sure that there is no
corruption on the disc drives.
John
"Huy (Andrew) V Nguyen" wrote:

> Dear All,
> I got a WIndows 2000 Server running MSDE. Recently it keep crashing with
> this error in event viewer:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> I have updated it to SP4 still the same problem. Does anyone know
> anything about this error message please
> Thank you very much
>
|||Hi John,
The error message is from Events Viewer. I check everything else at
around the same time nothing special. I had scheduled a CHKDSK to run
yesterday with no issues found. Any other idea please?
Andrew
John Bell wrote:[vbcol=seagreen]
> Hi Andrew
> Have you checked the windows event log for any messages that may indicate an
> issue, also it is probably worth running CHKDSK to make sure that there is no
> corruption on the disc drives.
> John
> "Huy (Andrew) V Nguyen" wrote:
|||Hi Andrew
Without knowing what was actually happening on the server at the time, it is
almost impossible to say what has caused this error. There are many issues
where the message may have been generated http://tinyurl.com/7kglf but I have
not found one that was not cured prior to SP4. You may want to raise a call
with PSS if this persists
http://support.microsoft.com/common/...id=2855&c1=508
John
"Huy (Andrew) V Nguyen" wrote:

> Hi John,
> The error message is from Events Viewer. I check everything else at
> around the same time nothing special. I had scheduled a CHKDSK to run
> yesterday with no issues found. Any other idea please?
> Andrew
> John Bell wrote:
>
|||I am getting the same error
SqlDumpExceptionHandler: Process 58 generated fatal exception running sQL
2000 sp4 and latest windows 2000 OS updates.
But I am also running in a clustered environment.
One of my servers never crashes (with pretty much the same patches etc.)
while the other server continues to crash.
I starting to think it has something to do with the actual machine hardware
and not the software.

Fatal error

Dear All,
I got a Windows 2000 Server running MSDE. Recently it keep crashing with
this error in event viewer:
Error: 0, Severity: 19, State: 0
SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
I have updated it to SP4 still the same problem. Does anyone know
anything about this error message please
Thank you very muchHi Andrew
Have you checked the windows event log for any messages that may indicate an
issue, also it is probably worth running CHKDSK to make sure that there is n
o
corruption on the disc drives.
John
"Huy (Andrew) V Nguyen" wrote:

> Dear All,
> I got a Windows 2000 Server running MSDE. Recently it keep crashing with
> this error in event viewer:
> Error: 0, Severity: 19, State: 0
> SqlDumpExceptionHandler: Process 58 generated fatal exception c0000005
> EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
> I have updated it to SP4 still the same problem. Does anyone know
> anything about this error message please
> Thank you very much
>|||Hi John,
The error message is from Events Viewer. I check everything else at
around the same time nothing special. I had scheduled a CHKDSK to run
yesterday with no issues found. Any other idea please?
Andrew
John Bell wrote:[vbcol=seagreen]
> Hi Andrew
> Have you checked the windows event log for any messages that may indicate
an
> issue, also it is probably worth running CHKDSK to make sure that there is
no
> corruption on the disc drives.
> John
> "Huy (Andrew) V Nguyen" wrote:
>|||Hi Andrew
Without knowing what was actually happening on the server at the time, it is
almost impossible to say what has caused this error. There are many issues
where the message may have been generated http://tinyurl.com/7kglf but I hav
e
not found one that was not cured prior to SP4. You may want to raise a call
with PSS if this persists
[url]http://support.microsoft.com/common/international.aspx?rdpath=1&gprid=2855&c1=508[
/url]
John
"Huy (Andrew) V Nguyen" wrote:

> Hi John,
> The error message is from Events Viewer. I check everything else at
> around the same time nothing special. I had scheduled a CHKDSK to run
> yesterday with no issues found. Any other idea please?
> Andrew
> John Bell wrote:
>|||I am getting the same error
SqlDumpExceptionHandler: Process 58 generated fatal exception running sQL
2000 sp4 and latest Windows 2000 OS updates.
But I am also running in a clustered environment.
One of my servers never crashes (with pretty much the same patches etc.)
while the other server continues to crash.
I starting to think it has something to do with the actual machine hardware
and not the software.

Fast question

Hello!
I want to build an application (in visual basic) using the MSDE, and sell it
to thirds. What should i do for make it legally? I have licenses for visual
basic, but as far i know, I can redistribute the MSDE for free. Or I should
sign some agreement, like the Microsoft Agent?
Thank you for your answers and sorry my poor english
Lirn
Liran Marino
__________
Este mensaje se proporciona "TAL COMO ESTA", sin garantias y no otorga
ningun
derecho
__________
(Gua de netiquette del foro)
http://www.uyssoft.com/Netiquette/
__________
Las listas de News son como el Tetris, para la gente que aun recuerda como
leer...
Hi
You need a licence for Visual Basic Development Environment, and MSDE can be
distributed freely with a VB application.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Liran Marino" wrote:

> Hello!
> I want to build an application (in visual basic) using the MSDE, and sell it
> to thirds. What should i do for make it legally? I have licenses for visual
> basic, but as far i know, I can redistribute the MSDE for free. Or I should
> sign some agreement, like the Microsoft Agent?
> Thank you for your answers and sorry my poor english
> Lirán
> --
> Liran Marino
> __________
> Este mensaje se proporciona "TAL COMO ESTA", sin garantias y no otorga
> ningun
> derecho
> __________
> (GuXa de netiquette del foro)
> http://www.uyssoft.com/Netiquette/
> __________
> Las listas de News son como el Tetris, para la gente que aun recuerda como
> leer...
>
>