Datatransfer speed

Hi,
I have two datatransfer speed problems with inserts,delets and updates of a
replicated database. The replicated database is a mergepublisher with two
subscribers.
When I import data with dts, I have a transfer speed of 5 rows/sec.
How can I increase this speed ?
When the import is ready the merge-agents have a transfer speed of 5
rows/sec, too.
How can I increase this speed, too ?
Best regards
Axel Lanser
Hi,
it isn't a network problem, because the network traffic is 3%.
Best regards
Axel Lanser
|||Probably not - while with merge you can in some situations get your merge
agent to work within a few seconds, you will likely see it take about a
minute or more to complete its tasks. However this is a highly variable
number dependent on the nature of your database activity, number of
subscribers and hardware.
"ALN" <ALN@.discussions.microsoft.com> wrote in message
news:7B0D19A9-E4F3-4854-8280-692553454FB5@.microsoft.com...
> Hi,
> I have two datatransfer speed problems with inserts,delets and updates of
> a
> replicated database. The replicated database is a mergepublisher with two
> subscribers.
> When I import data with dts, I have a transfer speed of 5 rows/sec.
> How can I increase this speed ?
> When the import is ready the merge-agents have a transfer speed of 5
> rows/sec, too.
> How can I increase this speed, too ?
> Best regards
> Axel Lanser
sql

datareader doing updates

We created a Role (Alpha) and made it a member of the datareader Role. Our
hope was that members of this role would only be able to preform data reads.
On a test we granted Alpha exec rights to an update Stored Procedure. The
members of Alpha are now able to run the Stored Procedure and do updates eve
n
thought they are NOT members of datawriter. Further testing showed the same
for insert and delete stored procedures.
Does this sound right?
Thanks, Randy"Randy" <Randy@.discussions.microsoft.com> wrote in message
news:0EA38A7F-70DF-44D3-91C0-6555FB42A4FA@.microsoft.com...
> We created a Role (Alpha) and made it a member of the datareader Role.
> Our
> hope was that members of this role would only be able to preform data
> reads.
> On a test we granted Alpha exec rights to an update Stored Procedure. The
> members of Alpha are now able to run the Stored Procedure and do updates
> even
> thought they are NOT members of datawriter. Further testing showed the
> same
> for insert and delete stored procedures.
> Does this sound right?
>
Yes. Look up "ownership chains" in BOL. If the user can run the
procedure, then permission checks on all objects owned by the owner of the
stored procedure are supressed.
David

database updates not reflected in report

Iam using visual web developer express with sql server 2005 with advanced services. Iam designing my database reports with sql server reporting services(SQL server business interlligence development studio) and they are running correctly. Problem is, when i add records to my database and then go back and run my reports, the new records effects are not reflected in my new report runs.May be i should say my reports do not update. they only retrieve the data that was already in the database table during the time of report design. I dont know a way of forcing updates to be reflected in the reports.

Help Appreciated.

The updates aren't instant. Try closing the report and reopening after you make an update.

Database Trigger on Update Table

Dear All,
I want to create a trigger on a table (A) which can copy the records
into new table(B) whenever it updates or any new record inserted into
the table (A).
Kindly create this trigger for me.
TIACREATE TRIGGER A_IU
ON A
FOR INSERT, UPDATE
AS
INSERT B
SELECT *
FROM Inserted
GO
On 28 Jun 2006 04:54:08 -0700, "Atif Iqbal" <aatif.iqbal@.gmail.com>
wrote:

>Dear All,
>I want to create a trigger on a table (A) which can copy the records
>into new table(B) whenever it updates or any new record inserted into
>the table (A).
>Kindly create this trigger for me.
>TIA|||Hi
Marco
create trigger tr_MyTable on MyTable after update
as
if @.@.ROWCOUNT = 0 return
insert MyAuditTable
select i.ID, d.MyColumn, i.MyColumn from inserted i join deleted d on
d.ID = o.Id
"Atif Iqbal" <aatif.iqbal@.gmail.com> wrote in message
news:1151495648.866045.307900@.75g2000cwc.googlegroups.com...
> Dear All,
> I want to create a trigger on a table (A) which can copy the records
> into new table(B) whenever it updates or any new record inserted into
> the table (A).
> Kindly create this trigger for me.
> TIA
>