Hi
1. I am in process of designing N-Tier Application using ASP.NET. Can
anyone guide me the right material or microsoft guidelines document
which I can used in designing the N-Tier application.
2. I would also like to know whether to use Web Services or .Net
Remoting in designing N-Tier application
3. General 3 Tier architecture has 3 Tier : Presentation Layer ,
Business Layer and Database Layer
How this 3 layers are seperated out in N-Tier architecture.
Help would be very much appreciated.
Thanks
Silent Ocean
This is a little off-topic for this newsgroup.
However, http://msdn.microsoft.com/practices/ is a pretty good starting
poitn for architectural/design guidance for MS technologies.
Cheers,
Graeme
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"Silent Ocean" <silentocean555@.yahoo.com> wrote in message
news:%23e4PMIhnFHA.2852@.TK2MSFTNGP15.phx.gbl...
Hi
1. I am in process of designing N-Tier Application using ASP.NET. Can
anyone guide me the right material or microsoft guidelines document
which I can used in designing the N-Tier application.
2. I would also like to know whether to use Web Services or .Net
Remoting in designing N-Tier application
3. General 3 Tier architecture has 3 Tier : Presentation Layer ,
Business Layer and Database Layer
How this 3 layers are seperated out in N-Tier architecture.
Help would be very much appreciated.
Thanks
Silent Ocean
sql
Showing posts with label application. Show all posts
Showing posts with label application. Show all posts
Monday, March 26, 2012
Help on N - Tier architecture ?
Hi
1. I am in process of designing N-Tier Application using ASP.NET. Can
anyone guide me the right material or microsoft guidelines document
which I can used in designing the N-Tier application.
2. I would also like to know whether to use Web Services or .Net
Remoting in designing N-Tier application
3. General 3 Tier architecture has 3 Tier : Presentation Layer ,
Business Layer and Database Layer
How this 3 layers are seperated out in N-Tier architecture.
Help would be very much appreciated.
Thanks
Silent OceanThis is a little off-topic for this newsgroup.
However, http://msdn.microsoft.com/practices/ is a pretty good starting
poitn for architectural/design guidance for MS technologies.
Cheers,
Graeme
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"Silent Ocean" <silentocean555@.yahoo.com> wrote in message
news:%23e4PMIhnFHA.2852@.TK2MSFTNGP15.phx.gbl...
Hi
1. I am in process of designing N-Tier Application using ASP.NET. Can
anyone guide me the right material or microsoft guidelines document
which I can used in designing the N-Tier application.
2. I would also like to know whether to use Web Services or .Net
Remoting in designing N-Tier application
3. General 3 Tier architecture has 3 Tier : Presentation Layer ,
Business Layer and Database Layer
How this 3 layers are seperated out in N-Tier architecture.
Help would be very much appreciated.
Thanks
Silent Ocean
1. I am in process of designing N-Tier Application using ASP.NET. Can
anyone guide me the right material or microsoft guidelines document
which I can used in designing the N-Tier application.
2. I would also like to know whether to use Web Services or .Net
Remoting in designing N-Tier application
3. General 3 Tier architecture has 3 Tier : Presentation Layer ,
Business Layer and Database Layer
How this 3 layers are seperated out in N-Tier architecture.
Help would be very much appreciated.
Thanks
Silent OceanThis is a little off-topic for this newsgroup.
However, http://msdn.microsoft.com/practices/ is a pretty good starting
poitn for architectural/design guidance for MS technologies.
Cheers,
Graeme
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"Silent Ocean" <silentocean555@.yahoo.com> wrote in message
news:%23e4PMIhnFHA.2852@.TK2MSFTNGP15.phx.gbl...
Hi
1. I am in process of designing N-Tier Application using ASP.NET. Can
anyone guide me the right material or microsoft guidelines document
which I can used in designing the N-Tier application.
2. I would also like to know whether to use Web Services or .Net
Remoting in designing N-Tier application
3. General 3 Tier architecture has 3 Tier : Presentation Layer ,
Business Layer and Database Layer
How this 3 layers are seperated out in N-Tier architecture.
Help would be very much appreciated.
Thanks
Silent Ocean
Friday, March 23, 2012
Help on elapse time to return data ??
Dear all,
I have build an ASP.net application which calls different store procedure.
When my customer request data from store procedure, I would like to display
on the page, the time it takes to return data.
How to do that ?
regards
sergeSomething like that
create proc myproc1
as
--here is your body's code
--usage
declare @.dt datetime
set @.dt=getdate()
exec myproc1
select datediff(s,@.dt,getdate())
drop proc myproc1
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:0A3D7622-0901-420D-A5F1-CCF7127BE43C@.microsoft.com...
> Dear all,
> I have build an ASP.net application which calls different store procedure.
> When my customer request data from store procedure, I would like to
> display
> on the page, the time it takes to return data.
> How to do that ?
> regards
> serge|||To add to Uri's response, you can also calculate the elapsed time in your
application. C# example:
DateTime startTime = DateTime.Now;
//execute query
TimeSpan duration = DateTime.Now.Subtract(startTime);
Response.Write(duration.ToString();
Hope this helps.
Dan Guzman
SQL Server MVP
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:0A3D7622-0901-420D-A5F1-CCF7127BE43C@.microsoft.com...
> Dear all,
> I have build an ASP.net application which calls different store procedure.
> When my customer request data from store procedure, I would like to
> display
> on the page, the time it takes to return data.
> How to do that ?
> regards
> serge|||Thnaks dan, I will do that
regards
serge
"Dan Guzman" wrote:
> To add to Uri's response, you can also calculate the elapsed time in your
> application. C# example:
> DateTime startTime = DateTime.Now;
> //execute query
> TimeSpan duration = DateTime.Now.Subtract(startTime);
> Response.Write(duration.ToString();
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
> message news:0A3D7622-0901-420D-A5F1-CCF7127BE43C@.microsoft.com...
>
>
I have build an ASP.net application which calls different store procedure.
When my customer request data from store procedure, I would like to display
on the page, the time it takes to return data.
How to do that ?
regards
sergeSomething like that
create proc myproc1
as
--here is your body's code
--usage
declare @.dt datetime
set @.dt=getdate()
exec myproc1
select datediff(s,@.dt,getdate())
drop proc myproc1
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:0A3D7622-0901-420D-A5F1-CCF7127BE43C@.microsoft.com...
> Dear all,
> I have build an ASP.net application which calls different store procedure.
> When my customer request data from store procedure, I would like to
> display
> on the page, the time it takes to return data.
> How to do that ?
> regards
> serge|||To add to Uri's response, you can also calculate the elapsed time in your
application. C# example:
DateTime startTime = DateTime.Now;
//execute query
TimeSpan duration = DateTime.Now.Subtract(startTime);
Response.Write(duration.ToString();
Hope this helps.
Dan Guzman
SQL Server MVP
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:0A3D7622-0901-420D-A5F1-CCF7127BE43C@.microsoft.com...
> Dear all,
> I have build an ASP.net application which calls different store procedure.
> When my customer request data from store procedure, I would like to
> display
> on the page, the time it takes to return data.
> How to do that ?
> regards
> serge|||Thnaks dan, I will do that
regards
serge
"Dan Guzman" wrote:
> To add to Uri's response, you can also calculate the elapsed time in your
> application. C# example:
> DateTime startTime = DateTime.Now;
> //execute query
> TimeSpan duration = DateTime.Now.Subtract(startTime);
> Response.Write(duration.ToString();
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
> message news:0A3D7622-0901-420D-A5F1-CCF7127BE43C@.microsoft.com...
>
>
Help on database choice?
Hi there,
I am currently writing an application for NNTP, the application requires
very FAST inserts, updates etc.
I started to write it with mySQL and I got good results, I was wondering if
anyone can confirm speed comparisions (and other comparisons) using MSDE
rather than mySQL.
As far as i know my app which runs on the desktop requires no special
licenses to use MSDE but mySQL does.
The application with only have 1 concurrent user and is being developed with
c# Visual Studio.net
Any help or information anybody can offer would be gratefully appreciated
Thanks in advance
Ian
Oh I forgot to mention, there is only 1 concurrent user but that user has
approximately 10 connections to the database. Maybe this will have an effect
on performance,.
THanks again
Ian
"Ian" <ianinmalaga@.hotmail.com> wrote in message
news:eLL8qdnZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Hi there,
> I am currently writing an application for NNTP, the application requires
> very FAST inserts, updates etc.
> I started to write it with mySQL and I got good results, I was wondering
if
> anyone can confirm speed comparisions (and other comparisons) using MSDE
> rather than mySQL.
> As far as i know my app which runs on the desktop requires no special
> licenses to use MSDE but mySQL does.
> The application with only have 1 concurrent user and is being developed
with
> c# Visual Studio.net
> Any help or information anybody can offer would be gratefully appreciated
> Thanks in advance
> Ian
>
sql
I am currently writing an application for NNTP, the application requires
very FAST inserts, updates etc.
I started to write it with mySQL and I got good results, I was wondering if
anyone can confirm speed comparisions (and other comparisons) using MSDE
rather than mySQL.
As far as i know my app which runs on the desktop requires no special
licenses to use MSDE but mySQL does.
The application with only have 1 concurrent user and is being developed with
c# Visual Studio.net
Any help or information anybody can offer would be gratefully appreciated
Thanks in advance
Ian
Oh I forgot to mention, there is only 1 concurrent user but that user has
approximately 10 connections to the database. Maybe this will have an effect
on performance,.
THanks again
Ian
"Ian" <ianinmalaga@.hotmail.com> wrote in message
news:eLL8qdnZEHA.3228@.TK2MSFTNGP12.phx.gbl...
> Hi there,
> I am currently writing an application for NNTP, the application requires
> very FAST inserts, updates etc.
> I started to write it with mySQL and I got good results, I was wondering
if
> anyone can confirm speed comparisions (and other comparisons) using MSDE
> rather than mySQL.
> As far as i know my app which runs on the desktop requires no special
> licenses to use MSDE but mySQL does.
> The application with only have 1 concurrent user and is being developed
with
> c# Visual Studio.net
> Any help or information anybody can offer would be gratefully appreciated
> Thanks in advance
> Ian
>
sql
Wednesday, March 21, 2012
HELP OLAP Cubes
When I try to modify a OLAp Cube, suddenly appears a Error message
"Unknow Error. Restart the Application"
And this break my cube down
This is not always, just some time, for example when I proof the cube on Microsoft Excel or After I backed up the databes of analysis
What can I do?
I'll thanks your quick answer
NOTE: My cube use MOLAP aggregationsHave you applied analysis services SP3? I've never seen this error but I know that the service pack fixes quite a few bugs.
HTHsql
"Unknow Error. Restart the Application"
And this break my cube down
This is not always, just some time, for example when I proof the cube on Microsoft Excel or After I backed up the databes of analysis
What can I do?
I'll thanks your quick answer
NOTE: My cube use MOLAP aggregationsHave you applied analysis services SP3? I've never seen this error but I know that the service pack fixes quite a few bugs.
HTHsql
Monday, March 19, 2012
Help needed with SSIS and DTS help
Hi Guys,
I'm trying to develop an application and I have been told right here in sql server getting started forum that SSIS or DTS are the best bits.
My old post has these questions:
Code Snippet
I'm making an application. I have 2 different sites running Sql Server 2005 workgroup and sql server express.
I have a 3rd main server and what I would need to do is to get some of the data from both of these sites, merge it and save it on Main server and then generate another file which should be placed in a directory on a network.
I don't have any idea of how I would do that. Its entirely a sql server app.
One person told me its an SSIS and the other one said to investigate replication.
I have checked a bit about both. I want to give it a try.
Where can i find tutorials on both of these. Complete tutorials to develop and design it.
Thanks
Gemma
books on line are a good starting point:
http://msdn2.microsoft.com/en-us/library/bb545450.aspx
|||Hi Rafael,
I was thinking more in terms apart of books online. I'm not that clever like you guys, you know.
Apart can you tell me if i put Sql Server 2000 as the main server Can i access the Sql Server 2005 and get some data as I tried it and it doesn't work using DTS.
Thanks
Gemma
|||
Gemma wrote:
Apart can you tell me if i put Sql Server 2000 as the main server Can i access the Sql Server 2005 and get some data as I tried it and it doesn't work using DTS.
Can somebody plz reply to this thread? plz. plz. plz.
Thanks
Gemma
This is a quick set of tutorials on SSIS (included as part of Books Online): http://msdn2.microsoft.com/en-us/library/ms169917.aspx
I'd really recommend going through that first, before getting other books.
As a more general reply to your question, SSIS should be able to accomplish what you want to do.
Help needed with Instead of Update trigger on a View
I have an application where we are replacing a subsystem including portions
of the database. In order to minimize the code impact on the existing
application, we have decided to create a few "compatibility views" - i.e.
database Views that produce the same result and with the same names as the
old tables. Also in order to allow existing code to continue to function,
we are implementing INSTEAD OF triggers on the views. Even though all our
database accesses are encapsulated in stored procs, we have around 1500 of
them, and one of the tables we needed to reengineer this way is the "main"
table for the entire app. To make sure this isn't trivial, we have a new
"master" entity table with an Identity column that is referenced by the
reengineered "main" table.
At this point, we are only aware of performance impacts - everything appears
to work OK:
1. If a NON-NULL IDENTITY (or other non-required column in an INSERT
statement) is part of an index, we loose the use of the index as a result of
having to use NULLIF() or COALESCE() on those columns in the view. For the
same reason, we can't index those view(s).
2. (This is where the question comes in:) The INSTEAD OF UPDATE trigger
appears to require a large number of separate UPDATE statements against the
base tables, or building a dynamic SQL statement. We are looking for
guidance...
Now to my question:
In the INSTEAD OF UPDATE trigger, I have about 90 member columns from one
table. If I understand correctly, since the triggering update statement may
only update one column, I cannot use an UPDATE statement against the base
table that updates all the columns with the values from the 'updated'
pseudo-table. Instead, I will have to check if each column is updated, and
if so, either update it separately or build a dynamic SQL UPDATE statement
including those columns that have been updated.
What is the recommended approach to this?
TIA,
Tore.On Thu, 11 May 2006 14:30:01 -0400, "Tore" <tbostrup at agfirst> wrote:
(snip)
>1. If a NON-NULL IDENTITY (or other non-required column in an INSERT
>statement) is part of an index, we loose the use of the index as a result o
f
>having to use NULLIF() or COALESCE() on those columns in the view.
Hi Tore,
I don't think I understand what you're saying here. Where are you using
NULLIF() or COALESCE() and why? Coould you post a simplified sample of
your code?
> For the
>same reason, we can't index those view(s).
And neither should you. If you index the views, you'll create a complete
copy of your data. I don't think that yoou should do that in your
scenario.
(snip)
>In the INSTEAD OF UPDATE trigger, I have about 90 member columns from one
>table. If I understand correctly, since the triggering update statement ma
y
>only update one column, I cannot use an UPDATE statement against the base
>table that updates all the columns with the values from the 'updated'
>pseudo-table.
You undersatnd incorrectly. There is no 'updated' pseudo-table. The
'deleted' and 'inserted' pseudo-tables contain the complete before and
after image of the updated rows, including all columns that are not
affected by the update.
If your compatibility view translates to one new table, just perform the
modification in a single UPDATE statement. If your compatibility view
translates to more than one new table, use
IF UPDATE(col1) OR UPDATE(col2) ....
to find out which table(s) need updating, then use a single UPDATE
statement for all rows in each of the tables.
Sure, you'll be setting columns to the same value they already had. The
added cost of that is much less than the cost of finding out which
columns to update and executing up to 90 (!) consecutive UPDATE
statements against the same set of rows.
> Instead, I will have to check if each column is updated, and
>if so, either update it separately or build a dynamic SQL UPDATE statement
>including those columns that have been updated.
Using the dynamic SQL is even a worse option - it forces you to give
every user update permissions to the table. (And it will be slow because
of the extra recompiles).
www.sommarskog.se/dynamic_sql.html
Hugo Kornelis, SQL Server MVP|||Thanks Hugo,
I'll be looking at this tomorrow.
Tore.
"Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
news:p75762lfnlmg789b20fv9jk1jfjrhs2it0@.
4ax.com...
> On Thu, 11 May 2006 14:30:01 -0400, "Tore" <tbostrup at agfirst> wrote:
> (snip)
of
> Hi Tore,
> I don't think I understand what you're saying here. Where are you using
> NULLIF() or COALESCE() and why? Coould you post a simplified sample of
> your code?
>
> And neither should you. If you index the views, you'll create a complete
> copy of your data. I don't think that yoou should do that in your
> scenario.
> (snip)
may
> You undersatnd incorrectly. There is no 'updated' pseudo-table. The
> 'deleted' and 'inserted' pseudo-tables contain the complete before and
> after image of the updated rows, including all columns that are not
> affected by the update.
> If your compatibility view translates to one new table, just perform the
> modification in a single UPDATE statement. If your compatibility view
> translates to more than one new table, use
> IF UPDATE(col1) OR UPDATE(col2) ....
> to find out which table(s) need updating, then use a single UPDATE
> statement for all rows in each of the tables.
> Sure, you'll be setting columns to the same value they already had. The
> added cost of that is much less than the cost of finding out which
> columns to update and executing up to 90 (!) consecutive UPDATE
> statements against the same set of rows.
>
statement
> Using the dynamic SQL is even a worse option - it forces you to give
> every user update permissions to the table. (And it will be slow because
> of the extra recompiles).
> www.sommarskog.se/dynamic_sql.html
> --
> Hugo Kornelis, SQL Server MVP
of the database. In order to minimize the code impact on the existing
application, we have decided to create a few "compatibility views" - i.e.
database Views that produce the same result and with the same names as the
old tables. Also in order to allow existing code to continue to function,
we are implementing INSTEAD OF triggers on the views. Even though all our
database accesses are encapsulated in stored procs, we have around 1500 of
them, and one of the tables we needed to reengineer this way is the "main"
table for the entire app. To make sure this isn't trivial, we have a new
"master" entity table with an Identity column that is referenced by the
reengineered "main" table.
At this point, we are only aware of performance impacts - everything appears
to work OK:
1. If a NON-NULL IDENTITY (or other non-required column in an INSERT
statement) is part of an index, we loose the use of the index as a result of
having to use NULLIF() or COALESCE() on those columns in the view. For the
same reason, we can't index those view(s).
2. (This is where the question comes in:) The INSTEAD OF UPDATE trigger
appears to require a large number of separate UPDATE statements against the
base tables, or building a dynamic SQL statement. We are looking for
guidance...
Now to my question:
In the INSTEAD OF UPDATE trigger, I have about 90 member columns from one
table. If I understand correctly, since the triggering update statement may
only update one column, I cannot use an UPDATE statement against the base
table that updates all the columns with the values from the 'updated'
pseudo-table. Instead, I will have to check if each column is updated, and
if so, either update it separately or build a dynamic SQL UPDATE statement
including those columns that have been updated.
What is the recommended approach to this?
TIA,
Tore.On Thu, 11 May 2006 14:30:01 -0400, "Tore" <tbostrup at agfirst> wrote:
(snip)
>1. If a NON-NULL IDENTITY (or other non-required column in an INSERT
>statement) is part of an index, we loose the use of the index as a result o
f
>having to use NULLIF() or COALESCE() on those columns in the view.
Hi Tore,
I don't think I understand what you're saying here. Where are you using
NULLIF() or COALESCE() and why? Coould you post a simplified sample of
your code?
> For the
>same reason, we can't index those view(s).
And neither should you. If you index the views, you'll create a complete
copy of your data. I don't think that yoou should do that in your
scenario.
(snip)
>In the INSTEAD OF UPDATE trigger, I have about 90 member columns from one
>table. If I understand correctly, since the triggering update statement ma
y
>only update one column, I cannot use an UPDATE statement against the base
>table that updates all the columns with the values from the 'updated'
>pseudo-table.
You undersatnd incorrectly. There is no 'updated' pseudo-table. The
'deleted' and 'inserted' pseudo-tables contain the complete before and
after image of the updated rows, including all columns that are not
affected by the update.
If your compatibility view translates to one new table, just perform the
modification in a single UPDATE statement. If your compatibility view
translates to more than one new table, use
IF UPDATE(col1) OR UPDATE(col2) ....
to find out which table(s) need updating, then use a single UPDATE
statement for all rows in each of the tables.
Sure, you'll be setting columns to the same value they already had. The
added cost of that is much less than the cost of finding out which
columns to update and executing up to 90 (!) consecutive UPDATE
statements against the same set of rows.
> Instead, I will have to check if each column is updated, and
>if so, either update it separately or build a dynamic SQL UPDATE statement
>including those columns that have been updated.
Using the dynamic SQL is even a worse option - it forces you to give
every user update permissions to the table. (And it will be slow because
of the extra recompiles).
www.sommarskog.se/dynamic_sql.html
Hugo Kornelis, SQL Server MVP|||Thanks Hugo,
I'll be looking at this tomorrow.
Tore.
"Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
news:p75762lfnlmg789b20fv9jk1jfjrhs2it0@.
4ax.com...
> On Thu, 11 May 2006 14:30:01 -0400, "Tore" <tbostrup at agfirst> wrote:
> (snip)
of
> Hi Tore,
> I don't think I understand what you're saying here. Where are you using
> NULLIF() or COALESCE() and why? Coould you post a simplified sample of
> your code?
>
> And neither should you. If you index the views, you'll create a complete
> copy of your data. I don't think that yoou should do that in your
> scenario.
> (snip)
may
> You undersatnd incorrectly. There is no 'updated' pseudo-table. The
> 'deleted' and 'inserted' pseudo-tables contain the complete before and
> after image of the updated rows, including all columns that are not
> affected by the update.
> If your compatibility view translates to one new table, just perform the
> modification in a single UPDATE statement. If your compatibility view
> translates to more than one new table, use
> IF UPDATE(col1) OR UPDATE(col2) ....
> to find out which table(s) need updating, then use a single UPDATE
> statement for all rows in each of the tables.
> Sure, you'll be setting columns to the same value they already had. The
> added cost of that is much less than the cost of finding out which
> columns to update and executing up to 90 (!) consecutive UPDATE
> statements against the same set of rows.
>
statement
> Using the dynamic SQL is even a worse option - it forces you to give
> every user update permissions to the table. (And it will be slow because
> of the extra recompiles).
> www.sommarskog.se/dynamic_sql.html
> --
> Hugo Kornelis, SQL Server MVP
Monday, March 12, 2012
Help needed to merge a few database - same tables
Hi all,
I am new to SQL and have to support application that uses MS SQL 2K.
I have to merge a few database , (with the same tables structures -
each
one include identification database Id) to one database file with the
same tables structures.
The merge should run on a daily bases ( all the new data on each table
will be from the last day until current day (one of the field in the
tables).
In addition if during the merge for some reason it "fail" a
rollback procedure is needed to the situation before the merge with
these tables.
I appreciate if anyone can help me with SQL script that will do the
work.
Or direct me how I should do it.
Thanks
RGI think you need transactional replication for this. It will replicate
transactions within a transactional context, with the commit or rollback
feature you require.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ran_gl@.hotmail.com> wrote in message
news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
> Hi all,
> I am new to SQL and have to support application that uses MS SQL 2K.
> I have to merge a few database , (with the same tables structures -
> each
> one include identification database Id) to one database file with the
> same tables structures.
> The merge should run on a daily bases ( all the new data on each table
> will be from the last day until current day (one of the field in the
> tables).
> In addition if during the merge for some reason it "fail" a
> rollback procedure is needed to the situation before the merge with
> these tables.
> I appreciate if anyone can help me with SQL script that will do the
> work.
> Or direct me how I should do it.
> Thanks
> RG
>|||Hi, Hillary
How are your doing?
I was thinking about SNAPSHOT replication instead of transactional ,because
the OP said he needs it on daily bases.
Well, I think it is easy to handle , however I'm not sure about ROLLBACK in
case of the failure.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23NETQF2nGHA.4728@.TK2MSFTNGP03.phx.gbl...
>I think you need transactional replication for this. It will replicate
>transactions within a transactional context, with the commit or rollback
>feature you require.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <ran_gl@.hotmail.com> wrote in message
> news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
>|||Shalom Uri!
Snapshot will work as well. But it will mean you have to transfer all the
data and there is no transactional consistency. So in his case all the data
will move or none of it (if the snapshot fails). With transactional
replication, transactions are read from the tlog, decomposed into
constituent commands, and then these commands are applied within a
transactional context on the subscriber. Should a command fail, the entire
transaction is rolled back.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uIdwdc2nGHA.4124@.TK2MSFTNGP03.phx.gbl...
> Hi, Hillary
> How are your doing?
> I was thinking about SNAPSHOT replication instead of transactional
> ,because the OP said he needs it on daily bases.
> Well, I think it is easy to handle , however I'm not sure about ROLLBACK
> in case of the failure.
>
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23NETQF2nGHA.4728@.TK2MSFTNGP03.phx.gbl...
>
I am new to SQL and have to support application that uses MS SQL 2K.
I have to merge a few database , (with the same tables structures -
each
one include identification database Id) to one database file with the
same tables structures.
The merge should run on a daily bases ( all the new data on each table
will be from the last day until current day (one of the field in the
tables).
In addition if during the merge for some reason it "fail" a
rollback procedure is needed to the situation before the merge with
these tables.
I appreciate if anyone can help me with SQL script that will do the
work.
Or direct me how I should do it.
Thanks
RGI think you need transactional replication for this. It will replicate
transactions within a transactional context, with the commit or rollback
feature you require.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ran_gl@.hotmail.com> wrote in message
news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
> Hi all,
> I am new to SQL and have to support application that uses MS SQL 2K.
> I have to merge a few database , (with the same tables structures -
> each
> one include identification database Id) to one database file with the
> same tables structures.
> The merge should run on a daily bases ( all the new data on each table
> will be from the last day until current day (one of the field in the
> tables).
> In addition if during the merge for some reason it "fail" a
> rollback procedure is needed to the situation before the merge with
> these tables.
> I appreciate if anyone can help me with SQL script that will do the
> work.
> Or direct me how I should do it.
> Thanks
> RG
>|||Hi, Hillary
How are your doing?
I was thinking about SNAPSHOT replication instead of transactional ,because
the OP said he needs it on daily bases.
Well, I think it is easy to handle , however I'm not sure about ROLLBACK in
case of the failure.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23NETQF2nGHA.4728@.TK2MSFTNGP03.phx.gbl...
>I think you need transactional replication for this. It will replicate
>transactions within a transactional context, with the commit or rollback
>feature you require.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <ran_gl@.hotmail.com> wrote in message
> news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
>|||Shalom Uri!
Snapshot will work as well. But it will mean you have to transfer all the
data and there is no transactional consistency. So in his case all the data
will move or none of it (if the snapshot fails). With transactional
replication, transactions are read from the tlog, decomposed into
constituent commands, and then these commands are applied within a
transactional context on the subscriber. Should a command fail, the entire
transaction is rolled back.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uIdwdc2nGHA.4124@.TK2MSFTNGP03.phx.gbl...
> Hi, Hillary
> How are your doing?
> I was thinking about SNAPSHOT replication instead of transactional
> ,because the OP said he needs it on daily bases.
> Well, I think it is easy to handle , however I'm not sure about ROLLBACK
> in case of the failure.
>
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23NETQF2nGHA.4728@.TK2MSFTNGP03.phx.gbl...
>
Help needed to merge a few database - same tables
Hi all,
I am new to SQL and have to support application that uses MS SQL 2K.
I have to merge a few database , (with the same tables structures -
each
one include identification database Id) to one database file with the
same tables structures.
The merge should run on a daily bases ( all the new data on each table
will be from the last day until current day (one of the field in the
tables).
In addition if during the merge for some reason it "fail" a
rollback procedure is needed to the situation before the merge with
these tables.
I appreciate if anyone can help me with SQL script that will do the
work.
Or direct me how I should do it.
Thanks
RGI think you need transactional replication for this. It will replicate
transactions within a transactional context, with the commit or rollback
feature you require.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ran_gl@.hotmail.com> wrote in message
news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
> Hi all,
> I am new to SQL and have to support application that uses MS SQL 2K.
> I have to merge a few database , (with the same tables structures -
> each
> one include identification database Id) to one database file with the
> same tables structures.
> The merge should run on a daily bases ( all the new data on each table
> will be from the last day until current day (one of the field in the
> tables).
> In addition if during the merge for some reason it "fail" a
> rollback procedure is needed to the situation before the merge with
> these tables.
> I appreciate if anyone can help me with SQL script that will do the
> work.
> Or direct me how I should do it.
> Thanks
> RG
>|||Hi, Hillary
How are your doing?
I was thinking about SNAPSHOT replication instead of transactional ,because
the OP said he needs it on daily bases.
Well, I think it is easy to handle , however I'm not sure about ROLLBACK in
case of the failure.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23NETQF2nGHA.4728@.TK2MSFTNGP03.phx.gbl...
>I think you need transactional replication for this. It will replicate
>transactions within a transactional context, with the commit or rollback
>feature you require.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <ran_gl@.hotmail.com> wrote in message
> news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
>> Hi all,
>> I am new to SQL and have to support application that uses MS SQL 2K.
>> I have to merge a few database , (with the same tables structures -
>> each
>> one include identification database Id) to one database file with the
>> same tables structures.
>> The merge should run on a daily bases ( all the new data on each table
>> will be from the last day until current day (one of the field in the
>> tables).
>> In addition if during the merge for some reason it "fail" a
>> rollback procedure is needed to the situation before the merge with
>> these tables.
>> I appreciate if anyone can help me with SQL script that will do the
>> work.
>> Or direct me how I should do it.
>> Thanks
>> RG
>|||Shalom Uri!
Snapshot will work as well. But it will mean you have to transfer all the
data and there is no transactional consistency. So in his case all the data
will move or none of it (if the snapshot fails). With transactional
replication, transactions are read from the tlog, decomposed into
constituent commands, and then these commands are applied within a
transactional context on the subscriber. Should a command fail, the entire
transaction is rolled back.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uIdwdc2nGHA.4124@.TK2MSFTNGP03.phx.gbl...
> Hi, Hillary
> How are your doing?
> I was thinking about SNAPSHOT replication instead of transactional
> ,because the OP said he needs it on daily bases.
> Well, I think it is easy to handle , however I'm not sure about ROLLBACK
> in case of the failure.
>
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23NETQF2nGHA.4728@.TK2MSFTNGP03.phx.gbl...
>>I think you need transactional replication for this. It will replicate
>>transactions within a transactional context, with the commit or rollback
>>feature you require.
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> <ran_gl@.hotmail.com> wrote in message
>> news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
>> Hi all,
>> I am new to SQL and have to support application that uses MS SQL 2K.
>> I have to merge a few database , (with the same tables structures -
>> each
>> one include identification database Id) to one database file with the
>> same tables structures.
>> The merge should run on a daily bases ( all the new data on each table
>> will be from the last day until current day (one of the field in the
>> tables).
>> In addition if during the merge for some reason it "fail" a
>> rollback procedure is needed to the situation before the merge with
>> these tables.
>> I appreciate if anyone can help me with SQL script that will do the
>> work.
>> Or direct me how I should do it.
>> Thanks
>> RG
>>
>
I am new to SQL and have to support application that uses MS SQL 2K.
I have to merge a few database , (with the same tables structures -
each
one include identification database Id) to one database file with the
same tables structures.
The merge should run on a daily bases ( all the new data on each table
will be from the last day until current day (one of the field in the
tables).
In addition if during the merge for some reason it "fail" a
rollback procedure is needed to the situation before the merge with
these tables.
I appreciate if anyone can help me with SQL script that will do the
work.
Or direct me how I should do it.
Thanks
RGI think you need transactional replication for this. It will replicate
transactions within a transactional context, with the commit or rollback
feature you require.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
<ran_gl@.hotmail.com> wrote in message
news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
> Hi all,
> I am new to SQL and have to support application that uses MS SQL 2K.
> I have to merge a few database , (with the same tables structures -
> each
> one include identification database Id) to one database file with the
> same tables structures.
> The merge should run on a daily bases ( all the new data on each table
> will be from the last day until current day (one of the field in the
> tables).
> In addition if during the merge for some reason it "fail" a
> rollback procedure is needed to the situation before the merge with
> these tables.
> I appreciate if anyone can help me with SQL script that will do the
> work.
> Or direct me how I should do it.
> Thanks
> RG
>|||Hi, Hillary
How are your doing?
I was thinking about SNAPSHOT replication instead of transactional ,because
the OP said he needs it on daily bases.
Well, I think it is easy to handle , however I'm not sure about ROLLBACK in
case of the failure.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23NETQF2nGHA.4728@.TK2MSFTNGP03.phx.gbl...
>I think you need transactional replication for this. It will replicate
>transactions within a transactional context, with the commit or rollback
>feature you require.
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> <ran_gl@.hotmail.com> wrote in message
> news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
>> Hi all,
>> I am new to SQL and have to support application that uses MS SQL 2K.
>> I have to merge a few database , (with the same tables structures -
>> each
>> one include identification database Id) to one database file with the
>> same tables structures.
>> The merge should run on a daily bases ( all the new data on each table
>> will be from the last day until current day (one of the field in the
>> tables).
>> In addition if during the merge for some reason it "fail" a
>> rollback procedure is needed to the situation before the merge with
>> these tables.
>> I appreciate if anyone can help me with SQL script that will do the
>> work.
>> Or direct me how I should do it.
>> Thanks
>> RG
>|||Shalom Uri!
Snapshot will work as well. But it will mean you have to transfer all the
data and there is no transactional consistency. So in his case all the data
will move or none of it (if the snapshot fails). With transactional
replication, transactions are read from the tlog, decomposed into
constituent commands, and then these commands are applied within a
transactional context on the subscriber. Should a command fail, the entire
transaction is rolled back.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uIdwdc2nGHA.4124@.TK2MSFTNGP03.phx.gbl...
> Hi, Hillary
> How are your doing?
> I was thinking about SNAPSHOT replication instead of transactional
> ,because the OP said he needs it on daily bases.
> Well, I think it is easy to handle , however I'm not sure about ROLLBACK
> in case of the failure.
>
>
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23NETQF2nGHA.4728@.TK2MSFTNGP03.phx.gbl...
>>I think you need transactional replication for this. It will replicate
>>transactions within a transactional context, with the commit or rollback
>>feature you require.
>> --
>> Hilary Cotter
>> Director of Text Mining and Database Strategy
>> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
>> This posting is my own and doesn't necessarily represent RelevantNoise's
>> positions, strategies or opinions.
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>>
>> <ran_gl@.hotmail.com> wrote in message
>> news:1152013871.628536.225820@.p79g2000cwp.googlegroups.com...
>> Hi all,
>> I am new to SQL and have to support application that uses MS SQL 2K.
>> I have to merge a few database , (with the same tables structures -
>> each
>> one include identification database Id) to one database file with the
>> same tables structures.
>> The merge should run on a daily bases ( all the new data on each table
>> will be from the last day until current day (one of the field in the
>> tables).
>> In addition if during the merge for some reason it "fail" a
>> rollback procedure is needed to the situation before the merge with
>> these tables.
>> I appreciate if anyone can help me with SQL script that will do the
>> work.
>> Or direct me how I should do it.
>> Thanks
>> RG
>>
>
Friday, March 9, 2012
Help needed for SSRS 2005(Regarding html code)
Hi Experts,
I am working on SSRS 2005, and I am facing a problem in this.
We are using an ASP.net application in which user fills a form. Some
fields contain text fields and we are entering all the fields in our
database through application.
But when we are entering values from application then our database
contains some html code in some fields with data.
Now I want to show those fields in my report, Values coming from
database in my report but they are in html format. So it is not
readable in report.
Now you people tell me how to solve this issue in my reports. I want
that data in my report as user entered in the application form.
Any help will be appreciated.
Regards
DineshDinesh,
The only thing I can think of is writing a function which strips out the
HTML tags and then call that function for each field in your report. You
could make this function a Report Code Block or even better, put it in an
assembly referenced by the Report.
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Dinesh" <dinesht15@.gmail.com> wrote in message
news:1176467678.190725.177080@.y80g2000hsf.googlegroups.com...
> Hi Experts,
> I am working on SSRS 2005, and I am facing a problem in this.
> We are using an ASP.net application in which user fills a form. Some
> fields contain text fields and we are entering all the fields in our
> database through application.
> But when we are entering values from application then our database
> contains some html code in some fields with data.
> Now I want to show those fields in my report, Values coming from
> database in my report but they are in html format. So it is not
> readable in report.
> Now you people tell me how to solve this issue in my reports. I want
> that data in my report as user entered in the application form.
> Any help will be appreciated.
> Regards
> Dinesh
>
I am working on SSRS 2005, and I am facing a problem in this.
We are using an ASP.net application in which user fills a form. Some
fields contain text fields and we are entering all the fields in our
database through application.
But when we are entering values from application then our database
contains some html code in some fields with data.
Now I want to show those fields in my report, Values coming from
database in my report but they are in html format. So it is not
readable in report.
Now you people tell me how to solve this issue in my reports. I want
that data in my report as user entered in the application form.
Any help will be appreciated.
Regards
DineshDinesh,
The only thing I can think of is writing a function which strips out the
HTML tags and then call that function for each field in your report. You
could make this function a Report Code Block or even better, put it in an
assembly referenced by the Report.
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Dinesh" <dinesht15@.gmail.com> wrote in message
news:1176467678.190725.177080@.y80g2000hsf.googlegroups.com...
> Hi Experts,
> I am working on SSRS 2005, and I am facing a problem in this.
> We are using an ASP.net application in which user fills a form. Some
> fields contain text fields and we are entering all the fields in our
> database through application.
> But when we are entering values from application then our database
> contains some html code in some fields with data.
> Now I want to show those fields in my report, Values coming from
> database in my report but they are in html format. So it is not
> readable in report.
> Now you people tell me how to solve this issue in my reports. I want
> that data in my report as user entered in the application form.
> Any help will be appreciated.
> Regards
> Dinesh
>
Help needed for accessing Report server from an ASP.Net application
Hi experts,
I have an ASP.Net application by which we are calling our remote
report server.
Till then it is fine but when i am clicking on any report then a pop
up window comes and it is
asking for username and password to logon on report server.
I want to remove this popup login screen,
I have tried to pass the credentials both default and network but it
is still asking for
username and password.
I think one method which is in Web service 2005 is BeginLogon() or
Logon() will work if i will pass them
from my application
But i dont know how to implement them in my application.
Can any body send me some code for implementing them
or suggest anything which can help me to solve this issue.
Regards
DineshOn Mar 27, 2:46 am, "Dinesh" <dinesh...@.gmail.com> wrote:
> Hi experts,
> I have an ASP.Net application by which we are calling our remote
> report server.
> Till then it is fine but when i am clicking on any report then a pop
> up window comes and it is
> asking for username and password to logon on report server.
> I want to remove this popup login screen,
> I have tried to pass the credentials both default and network but it
> is still asking for
> username and password.
> I think one method which is in Web service 2005 is BeginLogon() or
> Logon() will work if i will pass them
> from my application
> But i dont know how to implement them in my application.
> Can any body send me some code for implementing them
> or suggest anything which can help me to solve this issue.
> Regards
> Dinesh
Just a couple of thoughts. I usually experience the authentication
window whenever I'm using a browser other than IE as my default
(namely, Firefox/Mozilla). Is this the case? Also, have you tried
setting the 'Windows integrated security' or 'Credentials stored
securely in the report server' and 'Use as Windows credentials when
connecting to the datasource' options in the Properties tab of the
particular report(s) in Report Manager?
Regards,
Enrique Martinez
Sr. Software Consultant|||Is the logon screen for your report server or your web server hosting
your application?|||On Apr 6, 11:38 pm, "Lynn" <linqian...@.gmail.com> wrote:
> Is the logon screen for your report server or your web server hosting
> your application?
Log on screen for my report server.
We are giving report viewer url in application. when it is calling the
report server then it is showing the log in scree and i want to remove
that so that after clicking on any report name it will directly
redirect to report server withous asking any user name and password.
Regards
Dinesh
I have an ASP.Net application by which we are calling our remote
report server.
Till then it is fine but when i am clicking on any report then a pop
up window comes and it is
asking for username and password to logon on report server.
I want to remove this popup login screen,
I have tried to pass the credentials both default and network but it
is still asking for
username and password.
I think one method which is in Web service 2005 is BeginLogon() or
Logon() will work if i will pass them
from my application
But i dont know how to implement them in my application.
Can any body send me some code for implementing them
or suggest anything which can help me to solve this issue.
Regards
DineshOn Mar 27, 2:46 am, "Dinesh" <dinesh...@.gmail.com> wrote:
> Hi experts,
> I have an ASP.Net application by which we are calling our remote
> report server.
> Till then it is fine but when i am clicking on any report then a pop
> up window comes and it is
> asking for username and password to logon on report server.
> I want to remove this popup login screen,
> I have tried to pass the credentials both default and network but it
> is still asking for
> username and password.
> I think one method which is in Web service 2005 is BeginLogon() or
> Logon() will work if i will pass them
> from my application
> But i dont know how to implement them in my application.
> Can any body send me some code for implementing them
> or suggest anything which can help me to solve this issue.
> Regards
> Dinesh
Just a couple of thoughts. I usually experience the authentication
window whenever I'm using a browser other than IE as my default
(namely, Firefox/Mozilla). Is this the case? Also, have you tried
setting the 'Windows integrated security' or 'Credentials stored
securely in the report server' and 'Use as Windows credentials when
connecting to the datasource' options in the Properties tab of the
particular report(s) in Report Manager?
Regards,
Enrique Martinez
Sr. Software Consultant|||Is the logon screen for your report server or your web server hosting
your application?|||On Apr 6, 11:38 pm, "Lynn" <linqian...@.gmail.com> wrote:
> Is the logon screen for your report server or your web server hosting
> your application?
Log on screen for my report server.
We are giving report viewer url in application. when it is calling the
report server then it is showing the log in scree and i want to remove
that so that after clicking on any report name it will directly
redirect to report server withous asking any user name and password.
Regards
Dinesh
Wednesday, March 7, 2012
help nedded for MS reporting service 2000
Hi,
I am working on microsoft SQl server 2000 reporting services. I am
developing an application in c#.net in VS2003 which
will call reports in windowds forms and ask for user to select the
parameters for them.
Till now i had finished . Now I want to select multiple values for
parameters. and wants that for each combination a seprate report will
be drawn and it the end all the reports are merged in to one.
i.e.
suppose there are two parameters in a report and there are 10 available
values for first one and 20 for second parameter.
now i have selected 2 values for first parameter and 4 for second
parameter.
how this i can do in my program.
Please help me. because i am not finding any way to do it.
Thanks And Regards
DineshYou are not finding it because you cannot do this in RS 2000. RS 2000 does
not support multi-select parameters. RS 2005 does.
If it is possible to go to RS 2005 I would. For one thing, VS 2005 comes
will new controls that make integrating with RS much much easier. Plus RS
2005 has many good improvements: multi-select parameters, end user sorting,
performance improvements, etcs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dinesh" <dinesht15@.gmail.com> wrote in message
news:1164259279.407811.135710@.l12g2000cwl.googlegroups.com...
> Hi,
> I am working on microsoft SQl server 2000 reporting services. I am
> developing an application in c#.net in VS2003 which
> will call reports in windowds forms and ask for user to select the
> parameters for them.
> Till now i had finished . Now I want to select multiple values for
> parameters. and wants that for each combination a seprate report will
> be drawn and it the end all the reports are merged in to one.
> i.e.
> suppose there are two parameters in a report and there are 10 available
> values for first one and 20 for second parameter.
> now i have selected 2 values for first parameter and 4 for second
> parameter.
> how this i can do in my program.
> Please help me. because i am not finding any way to do it.
> Thanks And Regards
> Dinesh
>|||hi.......
i think u could not understand my problem properly.....
i know it is possible........
I had done the rendering and pring part of this for RS2000.
I had developed an application which will show all the reports on
report Server in a combobox.
here user will select a report if it contains parameters then it will
draw that many checklist boxes on the form if it does not have any
parameter then it will ask from user to select a format in which he
wantthe report.
now user will select a value for each parameter from checklistbox by
checking a single value in each check list box.
now those valuse will be passed in the rendor method to draw the
report.
after that report is drawn and printed.
till now i had finished.
now i wan to selct multiple values in checklistboxes.
suppose there are 2 parameters and user has selected 3 values in first
one and 2 values in second one
then i will get 6 parameters to pass in render method.
then after passing one set i will get one report i will store it in a
string varible and append others after it. ie. i will got total 6
reports which will be merged one after others.
if it is always fixed then no problem i can do it in for loop.
but since number of parameters are not fixed so i want to know how can
get the parameters set dynamically. for any combimation of parameters.
i.e.
i want each combination of parameter and want to pass it to render
method whioch i wrote in a seprate function.
Hope i have explained my problem completely.
if any body have any idea please tell me.
Regards
Dinesh
Bruce L-C [MVP] wrote:
> You are not finding it because you cannot do this in RS 2000. RS 2000 does
> not support multi-select parameters. RS 2005 does.
> If it is possible to go to RS 2005 I would. For one thing, VS 2005 comes
> will new controls that make integrating with RS much much easier. Plus RS
> 2005 has many good improvements: multi-select parameters, end user sorting,
> performance improvements, etcs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dinesh" <dinesht15@.gmail.com> wrote in message
> news:1164259279.407811.135710@.l12g2000cwl.googlegroups.com...
> > Hi,
> >
> > I am working on microsoft SQl server 2000 reporting services. I am
> > developing an application in c#.net in VS2003 which
> > will call reports in windowds forms and ask for user to select the
> > parameters for them.
> > Till now i had finished . Now I want to select multiple values for
> > parameters. and wants that for each combination a seprate report will
> > be drawn and it the end all the reports are merged in to one.
> >
> > i.e.
> > suppose there are two parameters in a report and there are 10 available
> > values for first one and 20 for second parameter.
> > now i have selected 2 values for first parameter and 4 for second
> > parameter.
> > how this i can do in my program.
> > Please help me. because i am not finding any way to do it.
> >
> > Thanks And Regards
> >
> > Dinesh
> >|||Hello,
I am trying to have both comma delimited and tab delimited output
option from sql 2000 reporting services. I have updated the config file
to have 2 output option in the render section of the config file. But I
always get 2 options listed on the dropdown as CSV - Comma Delimited, I
didn't get the tab-delimited option. Why my code in the config file
didn't get affected? Anything else I have to do, or is it all possible
in RS 2000.
Any help would be really appreciated.
Thanks,
Ravi
I am working on microsoft SQl server 2000 reporting services. I am
developing an application in c#.net in VS2003 which
will call reports in windowds forms and ask for user to select the
parameters for them.
Till now i had finished . Now I want to select multiple values for
parameters. and wants that for each combination a seprate report will
be drawn and it the end all the reports are merged in to one.
i.e.
suppose there are two parameters in a report and there are 10 available
values for first one and 20 for second parameter.
now i have selected 2 values for first parameter and 4 for second
parameter.
how this i can do in my program.
Please help me. because i am not finding any way to do it.
Thanks And Regards
DineshYou are not finding it because you cannot do this in RS 2000. RS 2000 does
not support multi-select parameters. RS 2005 does.
If it is possible to go to RS 2005 I would. For one thing, VS 2005 comes
will new controls that make integrating with RS much much easier. Plus RS
2005 has many good improvements: multi-select parameters, end user sorting,
performance improvements, etcs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dinesh" <dinesht15@.gmail.com> wrote in message
news:1164259279.407811.135710@.l12g2000cwl.googlegroups.com...
> Hi,
> I am working on microsoft SQl server 2000 reporting services. I am
> developing an application in c#.net in VS2003 which
> will call reports in windowds forms and ask for user to select the
> parameters for them.
> Till now i had finished . Now I want to select multiple values for
> parameters. and wants that for each combination a seprate report will
> be drawn and it the end all the reports are merged in to one.
> i.e.
> suppose there are two parameters in a report and there are 10 available
> values for first one and 20 for second parameter.
> now i have selected 2 values for first parameter and 4 for second
> parameter.
> how this i can do in my program.
> Please help me. because i am not finding any way to do it.
> Thanks And Regards
> Dinesh
>|||hi.......
i think u could not understand my problem properly.....
i know it is possible........
I had done the rendering and pring part of this for RS2000.
I had developed an application which will show all the reports on
report Server in a combobox.
here user will select a report if it contains parameters then it will
draw that many checklist boxes on the form if it does not have any
parameter then it will ask from user to select a format in which he
wantthe report.
now user will select a value for each parameter from checklistbox by
checking a single value in each check list box.
now those valuse will be passed in the rendor method to draw the
report.
after that report is drawn and printed.
till now i had finished.
now i wan to selct multiple values in checklistboxes.
suppose there are 2 parameters and user has selected 3 values in first
one and 2 values in second one
then i will get 6 parameters to pass in render method.
then after passing one set i will get one report i will store it in a
string varible and append others after it. ie. i will got total 6
reports which will be merged one after others.
if it is always fixed then no problem i can do it in for loop.
but since number of parameters are not fixed so i want to know how can
get the parameters set dynamically. for any combimation of parameters.
i.e.
i want each combination of parameter and want to pass it to render
method whioch i wrote in a seprate function.
Hope i have explained my problem completely.
if any body have any idea please tell me.
Regards
Dinesh
Bruce L-C [MVP] wrote:
> You are not finding it because you cannot do this in RS 2000. RS 2000 does
> not support multi-select parameters. RS 2005 does.
> If it is possible to go to RS 2005 I would. For one thing, VS 2005 comes
> will new controls that make integrating with RS much much easier. Plus RS
> 2005 has many good improvements: multi-select parameters, end user sorting,
> performance improvements, etcs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dinesh" <dinesht15@.gmail.com> wrote in message
> news:1164259279.407811.135710@.l12g2000cwl.googlegroups.com...
> > Hi,
> >
> > I am working on microsoft SQl server 2000 reporting services. I am
> > developing an application in c#.net in VS2003 which
> > will call reports in windowds forms and ask for user to select the
> > parameters for them.
> > Till now i had finished . Now I want to select multiple values for
> > parameters. and wants that for each combination a seprate report will
> > be drawn and it the end all the reports are merged in to one.
> >
> > i.e.
> > suppose there are two parameters in a report and there are 10 available
> > values for first one and 20 for second parameter.
> > now i have selected 2 values for first parameter and 4 for second
> > parameter.
> > how this i can do in my program.
> > Please help me. because i am not finding any way to do it.
> >
> > Thanks And Regards
> >
> > Dinesh
> >|||Hello,
I am trying to have both comma delimited and tab delimited output
option from sql 2000 reporting services. I have updated the config file
to have 2 output option in the render section of the config file. But I
always get 2 options listed on the dropdown as CSV - Comma Delimited, I
didn't get the tab-delimited option. Why my code in the config file
didn't get affected? Anything else I have to do, or is it all possible
in RS 2000.
Any help would be really appreciated.
Thanks,
Ravi
Help moving from SQL Server Express to SQL Server Developer
I built a web application using my VS2005 installation, which includes SQL Server Express.
All works nicely. However, when I tried to move this application to a system with SQL Server Developer, I cannot get it to work at all - data access receives several errors, with the most common being this one:
Cannot open database "xyz.mdf" requested by the login. The login failed. Login failed for user 'MACHINE\ASPNET'.
Here is my connection string (with specific names changed, obviously):
Data source=MACHINE;Initial Catalog=xyz.mdf;Integrated Security=SSPI;User=Me;Password=MyPassword
I have given users MACHINE\ASPNET and MACHINE\Me all possible permissions (that I know) within SQL Server.
I have spent days on this, with no solution - help would be most appreciated.
use the following syntax for the connection string
<connectionStrings> <add name="DatabaseConnection" connectionString="Data Source=(local);Initial Catalog=Northwind;IntegratedSecurity=SSPI;" /></connectionStrings>|||
Thank you!
I must admit, I do not exactly understand the difference between my example and yours - but yours worked!
Much appreciated.
|||Hi,
This is because unlike SQL Express, connecting to the SQL Server Developer edition requires you to use the instance name instead of the database file name.
Also, you need to remove the username and password to make sure that you're connecting with the windows integrated authentication.
Help Merge Replication
Hi to all,
I'm writing an application with Comact Framework 2.0 and I'd like to use merge replication to synchronize data among the sever and 25 Pocket PC.
The DataBase contains static tables (for configuration) and dynamic tables that I want to publish.
Configuration tables are small so no problem to publish them. The problem is with dynamic table and that's my first question:
One of these dynamic tables contains 150,000 records and data inside it (I can't use filter because all data must be "seen" to all POcket PC) should be published on each Pocket PC so: Is it possible to use merge replication with such big table?
Or is there another method to treat this kind of problem?
Should I use merge replication only for configuration tables?
If it's possible to use merge replication, what's the best hardware configuration for my server?
For example:
1) One PC for IIS and one for SQL Server with 2 CPU
2) or two PC in NLB so that request from Pocket PC's to IIS are balanced?
I'musing SQL Server 2005 SP1 and Windows CE 5.0
TIA.
Flavio
there's no table size limit for a table to be published by merge replication, 150k rows should not be a problem. Regarding your hardware configuration, it's up to you as it will depend if you're getting bottlenecks or not. Test with one configuration to see if there are any bottlenecks that can be relieved by the other configuration.Monday, February 27, 2012
help me!
now i got this error. please help me. i think it is the error of IIS.
Server Error in '/' Application.
String or binary data would be truncated.The statement has been terminated.
Description:Anunhandled exception occurred during the execution of the current webrequest. Please review the stack trace for more information about theerror and where it originated in the code.Exception Details:System.Data.SqlClient.SqlException: String or binary data would be truncated.The statement has been terminated.
Source Error:
The source code that generated this unhandled exception can only beshown when compiled in debug mode. To enable this, please follow one ofthe below steps, then request the URL:
1. Add a "Debug=true" directive at the top of the file that generated the error. Example:
<%@. Page Language="C#" Debug="true" %>
or:
2) Add the following section to the configuration file of your application:
<configuration>
<system.web>
<compilation debug="true"/>
</system.web>
</configuration>
Note that this second technique will cause all files within a givenapplication to be compiled in debug mode. The first technique willcause only that particular file to be compiled in debug mode.
Important:Running applications in debug mode does incur a memory/performanceoverhead. You should make sure that an application has debuggingdisabled before deploying into production scenario.Apparently your application is trying to store a value into the database that is larger than the target field, as indicated by the detail:
Exception Details:System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated.
Try adding the debug statement to your page to help with tracking down exactly where this is taking place.
regards,
Friday, February 24, 2012
Help me Urgently
I 've develop web application using crystal reports I want to change sql server name in crystal report at runtime. Can somebody help me.Which version of CR are you using?
Make use of LogOnServer property of CR object if you use CR9|||i AM USING CR 10|||Do you use front end application?|||Asp.net 2.0|||visit www.asp.net and see if you find example there
Make use of LogOnServer property of CR object if you use CR9|||i AM USING CR 10|||Do you use front end application?|||Asp.net 2.0|||visit www.asp.net and see if you find example there
Help me to fix this error
hi allServer Error in '/test' Application.
Exception Details:System.Data.SqlClient.SqlException: Cannot open database requested in login 'mehr'. Login fails. Login failed for user 'COMPUTER2\ASPNET'.
Source Error:
Source File:c:\inetpub\wwwroot\test\WebForm1.aspx.vb Line:69
Stack Trace:
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
thanks for your replyMeans user computer2/aspnet isnt a valid user in your database mehr. You either need to add the user, or add a different user to your connection string.
Nick
Server Error in '/test' Application.
Cannot open database requested in login 'mehr'. Login fails. Login failed for user 'COMPUTER2\ASPNET'.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.Exception Details:System.Data.SqlClient.SqlException: Cannot open database requested in login 'mehr'. Login fails. Login failed for user 'COMPUTER2\ASPNET'.
Source Error:
|
Source File:c:\inetpub\wwwroot\test\WebForm1.aspx.vb Line:69
Stack Trace:
|
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
thanks for your replyMeans user computer2/aspnet isnt a valid user in your database mehr. You either need to add the user, or add a different user to your connection string.
Nick
Help me pls - with database and Insert statement
I Have an error:
Server Error in '/quanlythietbi' Application.
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_yeucau_nhanvien'. The conflict occurred in database 'equipment', table 'nhanvien', column 'manv'. The statement has been terminated.
Source Error:
Line 129:mycommand.Parameters.Add(new SqlParameter("@.noidung_yc1",System.Data.SqlDbType.Text));Line 130:mycommand.Parameters["@.noidung_yc1"].Value = TextBox1.Text;Line 131:int i = mycommand.ExecuteNonQuery();Line 132:if (i>0)Line 133:{and this is my code:
string sqlstring = "Select * from yeucau where ngayGiaiQuyetxong='"+ Label8.Text +"' and date_yc='" + Label7.Text + "' and manv_yc='"+ TextBox2.Text + "' and noidung_yc='"+ TextBox1.Text+ "'";
myconnection =new SqlConnection(stringconn);
mycommand =new SqlCommand(sqlstring,myconnection);
myconnection.Close();
myconnection.Open();
mycommand =new SqlCommand(insertquery,myconnection);
mycommand.Parameters.Add(new SqlParameter("@.ngayGiaiQuyetxong1",System.Data.SqlDbType.Char,10));
mycommand.Parameters["@.ngayGiaiQuyetxong1"].Value = Label8.Text;
mycommand.Parameters.Add(new SqlParameter("@.date_yc1",System.Data.SqlDbType.SmallDateTime));
mycommand.Parameters["@.date_yc1"].Value = Label7.Text;
mycommand.Parameters.Add("@.manv_yc1",System.Data.SqlDbType.Char,10);
mycommand.Parameters["@.manv_yc1"].Value = TextBox2.Text;
mycommand.Parameters.Add(new SqlParameter("@.noidung_yc1",System.Data.SqlDbType.Text));
mycommand.Parameters["@.noidung_yc1"].Value = TextBox1.Text;
int i = mycommand.ExecuteNonQuery();
if (i>0)
{
lbcheck.Text = "?ã C?p Nh?t Yêu C?u.";
}
---------------------------------------
I don't know what I must do to repair it :(
How does insertquery look like? The error comes from an INSERT command, so you should check the INSERT command to see whether it tries to insert a row which conficts with the FK constraint. Such error will be raised if you try to insert a row with a field value that does not exist in the PRIMARY KEY (in another table) referenced by the FOREIGN KEY. To learn more about FOREIGN KEY constraint, you can refer to:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_04_8ypg.asp
|||thank a lot :) I will try to fix it now
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
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..!
>
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..!
>
Subscribe to:
Posts (Atom)