help me with MSDE 2000A sp3

Hi,
i tried to install MSDE 2000A sp3, but the installation wasn't seccessful.
Can somebody help me and write me what I have to do to install MSDE 2000A sp3 with SQL authentification (and how can I add some user, database and table)?
I'm using Win XP sp2, .NET Framework 1.1 and VS .NET 2003 (but I haven't got SQL Enterprise manager)
Thank'sTry the solution in this post. Hope this helps.

http://forums.asp.net/941156/ShowPost.aspx
|||

Hi,
I tried to install MSDE via the solution in the previous post, but when I run OSQL, there is an error (SQL Server doesn't exist, or acces denied).
So, I haven't solved my problem yet.

|||The second option was to download the eval edition which will allow you to install the MSDE as a second instance and I forgot to tell you OSQL is not a very user friendly tool. If you cannot download most SQL Server books from Osborne press have the eval edition I am assuming you can get them from library check outs. Hope this helps.|||Ok,
can you send me some hyperlink to that files?
Thank's
|||

Here is the link and SQL Server developer edition is $40 less on the web. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx

|||Thank's for help.

help me set up msde

I just installed MSDE off of disk that came with teach yourself asp.net in 24 hours. To get the program started you must go to run and type cmd and wait for the C prompt. I get this far, but I can't get a C prompt. It always comes up C:\sql2ksp3> How do I get a C prompt from here. I know it must be something easy that I am just overlooking or forgot.
Thanks
Del Dobbscd \

not that is matters a lot.

Help me please with length of text filed

i have to make one application with msde sql server
in my app i want to save in one field a big data(more than 2 milions caracters)
from documentations of sql 2000 server i understanded that a field text can store aboute 2^31-1 caracters. but when i build the insert query with this long data the msde tells me that i try to insert too long data value(permiesed length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
--
Message posted via http://www.sqlmonster.comHow are you trying to do the insert right now? Can you post the code you're
using?
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQLMonster.com...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.sqlmonster.com|||insert into table(Column) VALUES('more than 128 caracters')
--
Message posted via http://www.sqlmonster.com|||"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQLMonster.com...
> insert into table(Column) VALUES('more than 128 caracters')
:)
Can you post the exact error you're getting?
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length is 128.
To QueryBuilder:
i didn't find what do you say.
--
Message posted via http://www.sqlmonster.com|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQLMonster.com...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.sqlmonster.com|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegroups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>|||i use double-quotes but i obtain same error.
i thinck there is another problems
--
Message posted via http://www.sqlmonster.com|||QueryBuilder wrote:
</b>Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!</b>
I use Microsoft SQL Web Data Administrator and i didn't find options.
please explain how i can modify this limit
thx
--
Message posted via http://www.sqlmonster.com|||You need to use SINGLE-quotes.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:9e29790cfd5b43f88e872e073c5bdf59@.SQLMonster.com...
> i use double-quotes but i obtain same error.
> i thinck there is another problems
> --
> Message posted via http://www.sqlmonster.com

Help me please with length of text filed

i have to make one application with msde sql server
in my app i want to save in one field a big data(more than 2 milions caracte
rs)
from documentations of sql 2000 server i understanded that a field text can
store aboute 2^31-1 caracters. but when i build the insert query with this l
ong data the msde tells me that i try to insert too long data value(permiese
d length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
Message posted via http://www.droptable.comHow are you trying to do the insert right now? Can you post the code you're
using?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQ
droptable.com...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.droptable.com|||insert into table(Column) VALUES('more than 128 caracters')
Message posted via http://www.droptable.com|||"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQ
droptable.com...
> insert into table(Column) VALUES('more than 128 caracters')

Can you post the exact error you're getting?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!|||You can _insert_ more than 8192 characters in QA. You just can't select
more than that (the results will be truncated, though -- no error message).
Try:
create table #a (bigcol text)
insert #a
values
('00000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
000000000000000000000000000000000000
0000000000000000000000000000000000000000
0000000000')
select datalength(bigcol) from #a
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106159402.371899.277330@.z14g2000cwz.googlegroups.com...
> By default Query Analyzer only permits you to deal with 128 charactors.
> You can change it by going into Tools, Options and results tab up to a
> value of 8192. Thats all QA can handle.
> If you need to import a huge string of data, you might as well use DTS
> to import that text thru a text file. I am not sure as I have never
> tried... Just an idea...!!
>|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length
is 128.
To QueryBuilder:
i didn't find what do you say.
Message posted via http://www.droptable.com|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Simirad Iulian via droptable.com" <forum@.droptable.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQ
droptable.com...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.droptable.com|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegroups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>

Help me please with length of text filed

i have to make one application with msde sql server
in my app i want to save in one field a big data(more than 2 milions caracters)
from documentations of sql 2000 server i understanded that a field text can store aboute 2^31-1 caracters. but when i build the insert query with this long data the msde tells me that i try to insert too long data value(permiesed length is 128 caracters).
please tell me where i'm wrong
i have to make some settings to can insert more than 128 caracters?
thanks
Message posted via http://www.sqlmonster.com
How are you trying to do the insert right now? Can you post the code you're
using?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:e742f5ec453347e8866881cf5f73cd79@.SQLMonster.c om...
> i have to make one application with msde sql server
> in my app i want to save in one field a big data(more than 2 milions
caracters)
> from documentations of sql 2000 server i understanded that a field text
can store aboute 2^31-1 caracters. but when i build the insert query with
this long data the msde tells me that i try to insert too long data
value(permiesed length is 128 caracters).
> please tell me where i'm wrong
> i have to make some settings to can insert more than 128 caracters?
> thanks
> --
> Message posted via http://www.sqlmonster.com
|||insert into table(Column) VALUES('more than 128 caracters')
Message posted via http://www.sqlmonster.com
|||"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:8b0f081259e6493f911ac88839f2c2f5@.SQLMonster.c om...
> insert into table(Column) VALUES('more than 128 caracters')

Can you post the exact error you're getting?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
|||By default Query Analyzer only permits you to deal with 128 charactors.
You can change it by going into Tools, Options and results tab up to a
value of 8192. Thats all QA can handle.
If you need to import a huge string of data, you might as well use DTS
to import that text thru a text file. I am not sure as I have never
tried... Just an idea...!!
|||You can _insert_ more than 8192 characters in QA. You just can't select
more than that (the results will be truncated, though -- no error message).
Try:
create table #a (bigcol text)
insert #a
values
('000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 00000000000000000000000000
00000000000000000000000000000000000000000000000000 ')
select datalength(bigcol) from #a
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106159402.371899.277330@.z14g2000cwz.googlegr oups.com...
> By default Query Analyzer only permits you to deal with 128 charactors.
> You can change it by going into Tools, Options and results tab up to a
> value of 8192. Thats all QA can handle.
> If you need to import a huge string of data, you might as well use DTS
> to import that text thru a text file. I am not sure as I have never
> tried... Just an idea...!!
>
|||To Adam Machanic:
The error is:
The identifier that starts with 'my caracters' is too long. Maximum length is 128.
To QueryBuilder:
i didn't find what do you say.
Message posted via http://www.sqlmonster.com
|||I did some research on that error, and the only guess I have is that you may
be using double-quotes instead of single-quotes around your value -- switch
to single quotes if that's the case, and the problem should go away...
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Simirad Iulian via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:f079327cced04fb9a3d3a8ff06af97a8@.SQLMonster.c om...
> To Adam Machanic:
> The error is:
> The identifier that starts with 'my caracters' is too long. Maximum
length is 128.
> To QueryBuilder:
> i didn't find what do you say.
> --
> Message posted via http://www.sqlmonster.com
|||To Simirad:
Query Analyzer only supports 128 chars by default.. You can increase by
going into options and make it use upto 8192 charactors..!
If you insist on wanting to add more charactors in one shot.. the easy
way is to store the text in one text file.. Open DTS package and create
connection to your DB and another connection to your text file. Then do
a data transfermation to your table column...! If you have a primary
key in the table, put that key value in the text file as a column and
pump the data into the table..! You can also do this thru ActiveX in
DTS..! I tested it and it worked..!
Hope this helped..!
|||Did you bother to read my reply or run the example I posted? The limit in
QA has nothing to do with INSERTs.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"QueryBuilder" <pg.242w@.gmail.com> wrote in message
news:1106253826.201162.129390@.f14g2000cwb.googlegr oups.com...
> To Simirad:
> Query Analyzer only supports 128 chars by default.. You can increase by
> going into options and make it use upto 8192 charactors..!
> If you insist on wanting to add more charactors in one shot.. the easy
> way is to store the text in one text file.. Open DTS package and create
> connection to your DB and another connection to your text file. Then do
> a data transfermation to your table column...! If you have a primary
> key in the table, put that key value in the text file as a column and
> pump the data into the table..! You can also do this thru ActiveX in
> DTS..! I tested it and it worked..!
> Hope this helped..!
>

Help me get MSDE SP3a installed on Win Server 2003

I've tried every which way I can from the docs and but I can't seem to get MSDE to install correctly. Found out that Win2003 only runs SP3a, downloaded and tried it.
tried these different commands from the prompt:
setup SAPWD="xxxxx" INSTANCENAME="xxxxx" TARGETDIR="xxxx" (from MSDE2000 only)
setup /upgradesp sqlrun INSTANCENAME="xxxxx" DISABLENETWORKPROTOCOLS=1 (after installing MSDE2000 first)
setup INSTANCENAME="xxxxx" SAPWD="xxxxx" (straight from MSDE2000 SP3a)
Services shows that the SQL agent and the MSSQL$xxxx running. MSSQLServerADHelper is not running. The Service Manager isn't showing any services in the tray nor does it have the little green arrow. I can't connect to anything with Enterprise Manager eithe
r.
What do I need to do? Please note, I'm a totally complete noob with SQL admin and set up...
Thanks...
PS: and note that I'm in the correct directory with the installer and the xxxx are the correct instances and pw's
addition: This is Win 2003 Server Standard Edition...