Long Character Strings

Greetings,

I have a problem that I'm not sure how to handle. In the application I am working on I will be importing fixed length strings from a CD into the database. Each specific character in the string represents some value.

I can't decide if I should just create a single field of 895 characters or create 895 single character fields. When I need data from the database I won't need all 895 characters of information, I'll only need one or a small subset of values.

Does it really matter which approach I take?

Thanks in advance for any advice/tips you can provide.

ZackIt depends on what you plan to do with the data. If you are doing a bit of manipulation of each field for each record, at random intervals, and you want to be able to quickly look up (visually) an indexed value by using enterprise manager or a spreadsheet tool.. you're probably better off making 895 fields (you might want to find a script to do this.. that would take forever in design view).

If you are doing lots of data manipulation in chunks, then just make the single field and buffer it while you adjust the values, then update. In that situation you're gonna have better performance. You will not be able to easily look up an indexed value visually by doing it this way, so you might have to make a special tool if this is important too.

Like I say, it all depends on how you plan to use the data.

Brentsql

Login Problem

HI,
I handle three Production database (England,Grmany and Australia).
In one of the location i had created a user rep_process and given the
permission on the production database.
Now from thailand i am tranferring a object using DTS tasks(copy sql
server objects) from the production server in which i had created a
user rep_process.I connects successfully to that server from the task .
but when i execute the dts it gave me an error that rep_user does not
exists.
Does that means that i rep_user does not exists on the local database.
Or some other problem.
pls help
hope u understand.
from
Doller
doller
I did some testing and it worked just fine
What login/pass have you specified on source and desitnation server. Have
you connect successfully ?
Whe did you get the error? on what stage?
"doller" <sufianarif@.gmail.com> wrote in message
news:1125988323.938071.61480@.g44g2000cwa.googlegro ups.com...
> HI,
> I handle three Production database (England,Grmany and Australia).
> In one of the location i had created a user rep_process and given the
> permission on the production database.
> Now from thailand i am tranferring a object using DTS tasks(copy sql
> server objects) from the production server in which i had created a
> user rep_process.I connects successfully to that server from the task .
> but when i execute the dts it gave me an error that rep_user does not
> exists.
> Does that means that i rep_user does not exists on the local database.
> Or some other problem.
> pls help
> hope u understand.
> from
> Doller
>
|||Hi Uri,
If u read my question carefully then u will come to know that i had
created a user for replication perpose(rep_user) and given full rights
to that user on the production database.
now when i transfer the object(only object mean structure of table)
from the server where i created the replication user it give me error
user does not exists.
2 stage it gave error means when tranferring the object.
it successfully droped the table in the local database.
hope u will understand
from
doller
|||Hi
May because:
"In one of the location i had created a user rep_process and given the
permission on the production database"
rep_user does not exist!!
John
"doller" wrote:

> Hi Uri,
> If u read my question carefully then u will come to know that i had
> created a user for replication perpose(rep_user) and given full rights
> to that user on the production database.
> now when i transfer the object(only object mean structure of table)
> from the server where i created the replication user it give me error
> user does not exists.
> 2 stage it gave error means when tranferring the object.
> it successfully droped the table in the local database.
> hope u will understand
> from
> doller
>
|||Hi Jhon bell,
i am connected from sa then why rep_user is creating problem.
secondly i had 7 logins on production server why they are not
intrepting .
hope u understand
from
doller
|||Hi
When you created the DTS task, it sounds like rep_user was entered for the
connection user.
You may want to check out http://support.microsoft.com/kb/246133/
and http://support.microsoft.com/kb/240872/EN-US/
You may want to check whether the production server has a case sensitive
collation.
John
"doller" wrote:

> Hi Jhon bell,
> i am connected from sa then why rep_user is creating problem.
> secondly i had 7 logins on production server why they are not
> intrepting .
> hope u understand
> from
> doller
>
|||Hi John,
It is not the problem of collation.Actually the table was created the
that user and some permission was set that is the why the error
occured.
hope this help u
thanx for help and support
from
doller

Login Problem

HI,
I handle three Production database (England,Grmany and Australia).
In one of the location i had created a user rep_process and given the
permission on the production database.
Now from thailand i am tranferring a object using DTS tasks(copy sql
server objects) from the production server in which i had created a
user rep_process.I connects successfully to that server from the task .
but when i execute the dts it gave me an error that rep_user does not
exists.
Does that means that i rep_user does not exists on the local database.
Or some other problem.
pls help
hope u understand.
from
Dollerdoller
I did some testing and it worked just fine
What login/pass have you specified on source and desitnation server. Have
you connect successfully ?
Whe did you get the error? on what stage?
"doller" <sufianarif@.gmail.com> wrote in message
news:1125988323.938071.61480@.g44g2000cwa.googlegroups.com...
> HI,
> I handle three Production database (England,Grmany and Australia).
> In one of the location i had created a user rep_process and given the
> permission on the production database.
> Now from thailand i am tranferring a object using DTS tasks(copy sql
> server objects) from the production server in which i had created a
> user rep_process.I connects successfully to that server from the task .
> but when i execute the dts it gave me an error that rep_user does not
> exists.
> Does that means that i rep_user does not exists on the local database.
> Or some other problem.
> pls help
> hope u understand.
> from
> Doller
>|||Hi Uri,
If u read my question carefully then u will come to know that i had
created a user for replication perpose(rep_user) and given full rights
to that user on the production database.
now when i transfer the object(only object mean structure of table)
from the server where i created the replication user it give me error
user does not exists.
2 stage it gave error means when tranferring the object.
it successfully droped the table in the local database.
hope u will understand
from
doller|||Hi
May because:
"In one of the location i had created a user rep_process and given the
permission on the production database"
rep_user does not exist!!
John
"doller" wrote:

> Hi Uri,
> If u read my question carefully then u will come to know that i had
> created a user for replication perpose(rep_user) and given full rights
> to that user on the production database.
> now when i transfer the object(only object mean structure of table)
> from the server where i created the replication user it give me error
> user does not exists.
> 2 stage it gave error means when tranferring the object.
> it successfully droped the table in the local database.
> hope u will understand
> from
> doller
>|||Hi Jhon bell,
i am connected from sa then why rep_user is creating problem.
secondly i had 7 logins on production server why they are not
intrepting .
hope u understand
from
doller|||Hi
When you created the DTS task, it sounds like rep_user was entered for the
connection user.
You may want to check out http://support.microsoft.com/kb/246133/
and http://support.microsoft.com/kb/240872/EN-US/
You may want to check whether the production server has a case sensitive
collation.
John
"doller" wrote:

> Hi Jhon bell,
> i am connected from sa then why rep_user is creating problem.
> secondly i had 7 logins on production server why they are not
> intrepting .
> hope u understand
> from
> doller
>|||Hi John,
It is not the problem of collation.Actually the table was created the
that user and some permission was set that is the why the error
occured.
hope this help u
thanx for help and support
from
doller

Login Problem

HI,
I handle three Production database (England,Grmany and Australia).
In one of the location i had created a user rep_process and given the
permission on the production database.
Now from thailand i am tranferring a object using DTS tasks(copy sql
server objects) from the production server in which i had created a
user rep_process.I connects successfully to that server from the task .
but when i execute the dts it gave me an error that rep_user does not
exists.
Does that means that i rep_user does not exists on the local database.
Or some other problem.
pls help
hope u understand.
from
Dollerdoller
I did some testing and it worked just fine
What login/pass have you specified on source and desitnation server. Have
you connect successfully ?
Whe did you get the error? on what stage?
"doller" <sufianarif@.gmail.com> wrote in message
news:1125988323.938071.61480@.g44g2000cwa.googlegroups.com...
> HI,
> I handle three Production database (England,Grmany and Australia).
> In one of the location i had created a user rep_process and given the
> permission on the production database.
> Now from thailand i am tranferring a object using DTS tasks(copy sql
> server objects) from the production server in which i had created a
> user rep_process.I connects successfully to that server from the task .
> but when i execute the dts it gave me an error that rep_user does not
> exists.
> Does that means that i rep_user does not exists on the local database.
> Or some other problem.
> pls help
> hope u understand.
> from
> Doller
>|||Hi Uri,
If u read my question carefully then u will come to know that i had
created a user for replication perpose(rep_user) and given full rights
to that user on the production database.
now when i transfer the object(only object mean structure of table)
from the server where i created the replication user it give me error
user does not exists.
2 stage it gave error means when tranferring the object.
it successfully droped the table in the local database.
hope u will understand
from
doller|||Hi
May because:
"In one of the location i had created a user rep_process and given the
permission on the production database"
rep_user does not exist!!
John
"doller" wrote:
> Hi Uri,
> If u read my question carefully then u will come to know that i had
> created a user for replication perpose(rep_user) and given full rights
> to that user on the production database.
> now when i transfer the object(only object mean structure of table)
> from the server where i created the replication user it give me error
> user does not exists.
> 2 stage it gave error means when tranferring the object.
> it successfully droped the table in the local database.
> hope u will understand
> from
> doller
>|||Hi Jhon bell,
i am connected from sa then why rep_user is creating problem.
secondly i had 7 logins on production server why they are not
intrepting .
hope u understand
from
doller|||Hi
When you created the DTS task, it sounds like rep_user was entered for the
connection user.
You may want to check out http://support.microsoft.com/kb/246133/
and http://support.microsoft.com/kb/240872/EN-US/
You may want to check whether the production server has a case sensitive
collation.
John
"doller" wrote:
> Hi Jhon bell,
> i am connected from sa then why rep_user is creating problem.
> secondly i had 7 logins on production server why they are not
> intrepting .
> hope u understand
> from
> doller
>|||Hi John,
It is not the problem of collation.Actually the table was created the
that user and some permission was set that is the why the error
occured.
hope this help u
thanx for help and support
from
doller