Re: SQL server

From: BP Margolin (bpmargo@attglobal.net)
Date: 04/08/03

  • Next message: Warren: "cross database chaining"
    From: "BP Margolin" <bpmargo@attglobal.net>
    Date: Tue, 8 Apr 2003 16:21:37 -0400
    
    

    Jeff,

    In the future, please post exactly how you are trying to add data. From previous posts, I can guess that you are using Enterprise Manager. This is a known, although perhaps undocumented, limitation in Enterprise Manager.

    Use Query Analyzer and INSERT command to enter the data instead.

    -------------------------------------------
    BP Margolin
    Please reply only to the newsgroups.
    When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
    can be cut and pasted into Query Analyzer is appreciated.

    "jeff" <jeffbowen13@hotmail.com> wrote in message news:026301c2fdff$ed8c5500$a101280a@phx.gbl...
    > anyone know why I can not add more than 1023 characters
    > (including whitespace) into a table cell that is set at
    > VARCHAR 8000. this is regular .txt content and not
    > formatted at all. I would really appreciate it if someone
    > could email me directly to answer this.


  • Next message: Warren: "cross database chaining"

    Relevant Pages

    • Re: DMO SQLServer->Connect failed for user name with special characters
      ... in Enterprise Manager or Query Analyzer I get the same error. ... > Also try to put quotes around the user name (try both single quotes and ... >>> Eclipsys Corporation ...
      (microsoft.public.sqlserver.connect)
    • Re: Cannot connect to Query Analyzer
      ... And what happens if while you are in Enterprise Manager, ... go to the menu to Tools and then select Query Analyzer? ... noticed that I could not open Query Analyzer from within Enterprise Manager. ... to be able to change the password on my local sql server? ...
      (microsoft.public.sqlserver.connect)
    • Re: **different place for creating a new table**
      ... Both the Enterprise Manager and Query Analyzer tools allow you to specify ... specifies the owner explicitly in its internally generated script but QA ... If you want to create the tables using QA the same way EM does, specify the ...
      (microsoft.public.sqlserver.programming)
    • Re: Alignment result
      ... Copy the result from Enterprise Manager in a word editor (like Microsoft ... Word) and set the font to Courier New and Size 10. ... The default font for results in Query Analyzer is ... > It gave the result on view pannel like that... ...
      (microsoft.public.sqlserver.clients)
    • Re: What does Cut do?
      ... Regard to your question, by mistake, I used Cut instead of Copy in a ... production server and I thought that I had deleted the table. ... How often do you open Enterprise Manager to look at tables, ... > less mystical tool that combines the features of EM and Query Analyzer). ...
      (microsoft.public.sqlserver.server)

    Loading