SQL Server 7 problem
Hi,
I'm running into a funny problem. We're running MS SQL Server 7, and whenever we set something to either varchar, nvarchar, text, or ntext, it won't allow any input beyond 1023 characters... I know this is wrong. How can I fix it, and has anybody ran across this before???? Thanks in advance!!!!!!!!!!
Stumped in Seattle (or Indianapolis)
you rang???
Peter J. Boettcher posted this at 21:17 — 10th April 2001.
They have: 812 posts
Joined: Feb 2000
That is a wierd problem. Is the SQL Server exhibiting any other strange behaviour, maybe it's time for a re-install
Is this an existing table or are you experiencing this problem when creating new tables?
Have you installed the latest service pack (3), maybe it might fix this.
PJ | Are we there yet?
pjboettcher.com
lurch posted this at 21:28 — 10th April 2001.
They have: 7 posts
Joined: Feb 2001
Thanks for the interest!
To answer your questions:
- I'm not sure what service pack is installed... I'll check on that.
- It's an existing table, in fact, apparently it was happening on a project that was worked on (and finished) before I started working here, so it almost makes me wonder if it is in the setup, because the same person set both of them up...
- It doesn't even work when I put the nvarchar field at the end (like you're supposed to for TEXT apparently)
If you think of anything, please let me know!! We're stumped!!!!!
Thanks!
you rang???
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.