How to transfer data from one sql server to another sql server 7.0

Dear All
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.comHi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:

> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a bran
ch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via acces
s
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using[vbcol=seagreen]
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
>
branch[vbcol=seagreen]
data[vbcol=seagreen]
built[vbcol=seagreen]
have[vbcol=seagreen]
access[vbcol=seagreen]|||See inline
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.

> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
Servics.[vbcol=seagreen]
You[vbcol=seagreen]
> using
> branch
> data
> built
> have
> access
>

How to transfer data from one sql server to another sql server 7.0

Dear All
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.com
Hi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:

> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>
|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>
|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using[vbcol=seagreen]
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
branch[vbcol=seagreen]
data[vbcol=seagreen]
built[vbcol=seagreen]
have[vbcol=seagreen]
access[vbcol=seagreen]
|||See inline
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.

> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data[vbcol=seagreen]
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
Servics.[vbcol=seagreen]
You
> using
> branch
> data
> built
> have
> access
>

How to transfer data from one sql server to another sql server 7.0

Dear All
i have small data to transfer, let me explain it,
I have to transfer some small data from head office (sql server) to a branch
office (sql server)
the main objective is that the task should be automated via front end
developed in VB 6.0
The user at head office just choose option from front end to transfer data
and the user at branch office just select option to receive data, the
remainin task should be performed at the back end.
I just want to know the best technique to transfer the data, i have built
same type of solution using foxpro by sending data in text file. as i have
some ideas in my mind that data can be transfered via text file, via access
mdb file etc. etc., but what is the best technique.
please help if u can
Regards
Abdul Hameed
hsbilal@.gmail.comHi Abdul,
I feel the best option for you will be using Data Transformation Servics.
DTS not only helps to transfer data, it also helps to transform data. You
will be able to invoke the DTS package from your Visual Basic Program using
the COM interface provided by DTS.
Thanks & Regards
Shri.DBA
"Abdul Hameed" wrote:
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Hi
How often users can click to transfer?
What is db's size?
Also , look at backup/restore option
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:u1LXijasEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Dear All
> i have small data to transfer, let me explain it,
> I have to transfer some small data from head office (sql server) to a
branch
> office (sql server)
> the main objective is that the task should be automated via front end
> developed in VB 6.0
> The user at head office just choose option from front end to transfer data
> and the user at branch office just select option to receive data, the
> remainin task should be performed at the back end.
> I just want to know the best technique to transfer the data, i have built
> same type of solution using foxpro by sending data in text file. as i have
> some ideas in my mind that data can be transfered via text file, via
access
> mdb file etc. etc., but what is the best technique.
> please help if u can
> Regards
> Abdul Hameed
> hsbilal@.gmail.com
>
>|||Dear
Thankx for reply
I can use the DTS but how i will pass certain paramaters to dts package, as
i have to get the data based on certain paramaters.
Anyway i found another solution, please let me know will it be appropriate.
To Export data:
I will make a stored procedures which will accept certain paramaters, this
proce will create a linked server (access mdb)
then it will get data from sql server and update the mdb file, and at the
end the linked server will be destory, i will call this procedure form my vb
app with paramaters.
To Import data:
i will make a same stored procedure with reverse technique i.e. reading data
from mdb file and update sql server data
Kindly give ur comments.
Regards
"Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> Hi Abdul,
> I feel the best option for you will be using Data Transformation Servics.
> DTS not only helps to transfer data, it also helps to transform data. You
> will be able to invoke the DTS package from your Visual Basic Program
using
> the COM interface provided by DTS.
> Thanks & Regards
> Shri.DBA
> "Abdul Hameed" wrote:
> > Dear All
> > i have small data to transfer, let me explain it,
> > I have to transfer some small data from head office (sql server) to a
branch
> > office (sql server)
> > the main objective is that the task should be automated via front end
> > developed in VB 6.0
> > The user at head office just choose option from front end to transfer
data
> > and the user at branch office just select option to receive data, the
> > remainin task should be performed at the back end.
> >
> > I just want to know the best technique to transfer the data, i have
built
> > same type of solution using foxpro by sending data in text file. as i
have
> > some ideas in my mind that data can be transfered via text file, via
access
> > mdb file etc. etc., but what is the best technique.
> > please help if u can
> > Regards
> > Abdul Hameed
> > hsbilal@.gmail.com
> >
> >
> >
> >|||See inline
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Abdul Hameed" <hsbilal@.gmail.com> wrote in message
news:O5uAQbdsEHA.2560@.tk2msftngp13.phx.gbl...
> Dear
> Thankx for reply
> I can use the DTS but how i will pass certain paramaters to dts package,
as
> i have to get the data based on certain paramaters.
> Anyway i found another solution, please let me know will it be
appropriate.
You can create a DTS package, and even save it as a BAS file and include it
in your project, or simply call it using the object model... You can set
global variables and pass in your parameters that way.
> To Export data:
> I will make a stored procedures which will accept certain paramaters, this
> proce will create a linked server (access mdb)
> then it will get data from sql server and update the mdb file, and at the
> end the linked server will be destory, i will call this procedure form my
vb
> app with paramaters.
I wonder if creating the access database isn't overkill... you could simply
use DTS to bcp out the files. or better simply leave the data in the source
database and when the user wishes to import, move the data directly from the
source database to the destination database.
> To Import data:
> i will make a same stored procedure with reverse technique i.e. reading
data
> from mdb file and update sql server data
> Kindly give ur comments.
> Regards
> "Shri.DBA" <ShriDBA@.discussions.microsoft.com> wrote in message
> news:D4AD3EAE-BFC5-4DC9-BFD3-8050CD48826D@.microsoft.com...
> > Hi Abdul,
> >
> > I feel the best option for you will be using Data Transformation
Servics.
> > DTS not only helps to transfer data, it also helps to transform data.
You
> > will be able to invoke the DTS package from your Visual Basic Program
> using
> > the COM interface provided by DTS.
> >
> > Thanks & Regards
> > Shri.DBA
> >
> > "Abdul Hameed" wrote:
> >
> > > Dear All
> > > i have small data to transfer, let me explain it,
> > > I have to transfer some small data from head office (sql server) to a
> branch
> > > office (sql server)
> > > the main objective is that the task should be automated via front end
> > > developed in VB 6.0
> > > The user at head office just choose option from front end to transfer
> data
> > > and the user at branch office just select option to receive data, the
> > > remainin task should be performed at the back end.
> > >
> > > I just want to know the best technique to transfer the data, i have
> built
> > > same type of solution using foxpro by sending data in text file. as i
> have
> > > some ideas in my mind that data can be transfered via text file, via
> access
> > > mdb file etc. etc., but what is the best technique.
> > > please help if u can
> > > Regards
> > > Abdul Hameed
> > > hsbilal@.gmail.com
> > >
> > >
> > >
> > >
>

how to trace the file activity???

Dear all,
It urgent, can anyone please tell me how to race
the activity which the user have done to the file. e.g.
When the user delete a record from the file, when the
user edit a record from the file and when the user add a
new record to a file from the EM.Please, help.. Thanks.
Regards
Sharon
.There are several ways. One is to add a trigger to every table you wish to
audit that keeps track of all this activity. Of coarse this doesn't help
for any activity that already happened. Another much easier way is to use a
3rd party product such as Log Explorer from www.lumigent.com to look at the
log files and see the history. Of coarse if you have already truncated the
logs you may not have the information.
Andrew J. Kelly
SQL Server MVP
"sharon" <anonymous@.discussions.microsoft.com> wrote in message
news:130a901c44390$4ac6a320$a601280a@.phx
.gbl...
> Dear all,
> It urgent, can anyone please tell me how to race
> the activity which the user have done to the file. e.g.
> When the user delete a record from the file, when the
> user edit a record from the file and when the user add a
> new record to a file from the EM.Please, help.. Thanks.
> Regards
> Sharon
>
> .
>sql

How to trace the database activity

Dear all,
It urgent, can anyone please tell me how to race
the activity which the user have done to the file. e.g.
When the user delete a record from the file, when the
user edit a record from the file and when the user add a
new record to a file from the EM.Please, help.. Thanks.
Regards
Sharon
Please don't post independently in multiple newsgroups. You can add the
other newsgroups in the "Newsgroups" section in the header and it will show
up in all those simultaneously as will the answers. See my reply in the
other newsgroup.

Andrew J. Kelly
SQL Server MVP
"sharon" <anonymous@.discussions.microsoft.com> wrote in message
news:1329601c44387$f1f0c2b0$a501280a@.phx.gbl...
> Dear all,
> It urgent, can anyone please tell me how to race
> the activity which the user have done to the file. e.g.
> When the user delete a record from the file, when the
> user edit a record from the file and when the user add a
> new record to a file from the EM.Please, help.. Thanks.
> Regards
> Sharon
>

How to trace sp_addlogin

Dear all,
I have been trying to use SQL Profiler to trace login
creation. Can someone tell me how do I get the login names
that were created? Trace did not display the detail info
of sp_addlogin.
Thanks,
Joe
You can't get it from Profiler. If it sees password in the text it won't
display it.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Joe" <anonymous@.discussions.microsoft.com> wrote in message
news:c61d01c47a41$709fcbc0$a501280a@.phx.gbl...
> Dear all,
> I have been trying to use SQL Profiler to trace login
> creation. Can someone tell me how do I get the login names
> that were created? Trace did not display the detail info
> of sp_addlogin.
> Thanks,
> Joe
|||Other than SQL profiler, is there any work around? I only
want to prove the new login creation.
Thanks in advance
>--Original Message--
>You can't get it from Profiler. If it sees password in
the text it won't
>display it.
>--
>HTH
>Jasper Smith (SQL Server MVP)
>http://www.sqldbatips.com
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"Joe" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:c61d01c47a41$709fcbc0$a501280a@.phx.gbl...
names
>
>.
>
|||Execute sp_helplogins or query the master..syslogins table.
-Sue
On Thu, 5 Aug 2004 06:24:29 -0700, "Joe"
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Other than SQL profiler, is there any work around? I only
>want to prove the new login creation.
>Thanks in advance
>the text it won't
>message
>names
|||Not poossible with the current set of tools.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Joe" <anonymous@.discussions.microsoft.com> wrote in message
news:c61d01c47a41$709fcbc0$a501280a@.phx.gbl...
> Dear all,
> I have been trying to use SQL Profiler to trace login
> creation. Can someone tell me how do I get the login names
> that were created? Trace did not display the detail info
> of sp_addlogin.
> Thanks,
> Joe
|||Try using sp_trace_setevent and use event number 104 Audit Add/Drop Login
"Occurs when a SQL Server Login is added or removed; for sp_addlogin and
sp_droplogin. Also check out Microsoft article "SQL Server 2000 Auditing".
It details how to use Profiler to audit SQL Server.
Thanks,
Val
"Joe" <anonymous@.discussions.microsoft.com> wrote in message
news:c61d01c47a41$709fcbc0$a501280a@.phx.gbl...
> Dear all,
> I have been trying to use SQL Profiler to trace login
> creation. Can someone tell me how do I get the login names
> that were created? Trace did not display the detail info
> of sp_addlogin.
> Thanks,
> Joe

how to sum records by month and year

Dear all,
i had a table named saletable i had fields like
itemgroupid,itemgroupname,saleqty,saleamount and saledate.
i want to sum the saleqty and saleamount by every month and year.but i dont
want to eneter the date every time means no user criteria.
for eaxmple
itemgroupid itemgroupname saleqty saleamount date
23101102 HERO LINER 10.00 50467.29 2004-01-07
23101102 HERO LINER 20.00 10924.58 2005-01-07
23101102 HERO LINER 10.00 50467.29 2004-02-07
23101102 HERO LINER 20.00 10924.58 2005-02-07
23101102 HERO LINER 10.00 50467.29 2004-01-07
23101102 HERO LINER 20.00 10924.58 2005-01-07
23204101 Trading Mudgard 10.00 6000.00 2005-04-21
23204101 Trading Mudgard 10.00 50467.29 2004-01-07
23204101 Trading Mudgard 20.00 10924.58 2005-01-07
23204101 Trading Mudgard 20.00 10924.58 2005-02-07
23204101 Trading Mudgard 10.00 50467.29 2004-01-07
23204101 Trading Mudgard 20.00 10924.58 2005-01-07
I WANT like this
for every month and year
23204101 Trading Mudgard 20.00 100934.58 2004-01
23204101 Trading Mudgard 60.00 2326000.00 2005-01
23204101 Trading Mudgard 10.00 6000.00 2005-07
thanx
waiting for solution
from
Sufian
See GroupBY and DatePart in BOL. Also you may have better luck with this if
you posted in the Programming section.
"Mohd Sufian" <sufian@.aeroflex.co.th> wrote in message
news:1635C8A0-3859-4D65-8CEE-3F27B0350719@.microsoft.com...
> Dear all,
> i had a table named saletable i had fields like
> itemgroupid,itemgroupname,saleqty,saleamount and saledate.
> i want to sum the saleqty and saleamount by every month and year.but i
dont
> want to eneter the date every time means no user criteria.
> for eaxmple
> itemgroupid itemgroupname saleqty saleamount date
> ----
--
> 23101102 HERO LINER 10.00 50467.29
2004-01-07
> 23101102 HERO LINER 20.00 10924.58
2005-01-07
> 23101102 HERO LINER 10.00 50467.29
2004-02-07
> 23101102 HERO LINER 20.00 10924.58
2005-02-07
> 23101102 HERO LINER 10.00 50467.29
2004-01-07
> 23101102 HERO LINER 20.00 10924.58
2005-01-07
> 23204101 Trading Mudgard 10.00 6000.00 2005-04-21
> 23204101 Trading Mudgard 10.00 50467.29 2004-01-07
> 23204101 Trading Mudgard 20.00 10924.58 2005-01-07
> 23204101 Trading Mudgard 20.00 10924.58 2005-02-07
> 23204101 Trading Mudgard 10.00 50467.29 2004-01-07
> 23204101 Trading Mudgard 20.00 10924.58 2005-01-07
> I WANT like this
> for every month and year
> 23204101 Trading Mudgard 20.00 100934.58 2004-01
> 23204101 Trading Mudgard 60.00 2326000.00 2005-01
> 23204101 Trading Mudgard 10.00 6000.00 2005-07
> thanx
>
> --
> waiting for solution
> from
> Sufian

How to store very large document data?

Dear all,

I am facing a problem while storing Very large document data to a single image field in SQL Server 2000. It takes very much time for documents in size upto 10 MB. And its not possible to store data more than 10 MB. If I try it gives "Connection Write (Wrapper Write())" message with state 01000 and native 4.

I have used SQLPutData and SQLParamData for this purpose.

Is there any efficient way to do this? My concern is for less time.

Thanks in advance,
AvneeshI need urgent help regarding above problem. Would somebody please send some suggestions ASAP.

Thanks in advnace,
Avneesh