Showing posts with label inserted. Show all posts
Showing posts with label inserted. Show all posts

Tuesday, March 20, 2012

non-conflict errors

in merge replication using sql server 2005 and sql server compact, what happens when rows or columns cannot be inserted/updated/deleted because of some error other than a conflict? Are they handled differently tan change conflicts?

thanks,

bryan

The rows are retried and are still logged into the conflict table.|||

what happens to the conflict table? does it just stay on the server for logging purposes? does it go back to the client? if so, what does the client do with it? is the client notified that entries are in the conflict table? can it be queried programmically and the conflict fixed and resubmitted?

thanks,

bryan

Saturday, February 25, 2012

No. Of Records inserted into a table/database

How do I findout number of records inserted/sec into a table or database.
What is the version of SQL Server?
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
> How do I findout number of records inserted/sec into a table or database.
|||I want to findout this information both in SQL Server 2000 and SQL Server 2005
"Uri Dimant" wrote:

> What is the version of SQL Server?
> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
> news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
>
>
|||If you want only INSERTED rows, you can create in both versions trigger on
table for INSERT and calculate them.
In SQL Server 2005 take a look at an OUTPUT clause
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:6FBE1B30-CC16-4BCB-9C6C-4E6D3852BC42@.microsoft.com...[vbcol=seagreen]
>I want to findout this information both in SQL Server 2000 and SQL Server
>2005
> "Uri Dimant" wrote:
|||In almost all cases, you have to clock it yourself.
Linchi
"Balaji" wrote:

> How do I findout number of records inserted/sec into a table or database.

No. Of Records inserted into a table/database

How do I findout number of records inserted/sec into a table or database.What is the version of SQL Server?
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
> How do I findout number of records inserted/sec into a table or database.|||I want to findout this information both in SQL Server 2000 and SQL Server 20
05
"Uri Dimant" wrote:

> What is the version of SQL Server?
> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
> news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
>
>|||If you want only INSERTED rows, you can create in both versions trigger on
table for INSERT and calculate them.
In SQL Server 2005 take a look at an OUTPUT clause
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:6FBE1B30-CC16-4BCB-9C6C-4E6D3852BC42@.microsoft.com...[vbcol=seagreen]
>I want to findout this information both in SQL Server 2000 and SQL Server
>2005
> "Uri Dimant" wrote:
>|||In almost all cases, you have to clock it yourself.
Linchi
"Balaji" wrote:

> How do I findout number of records inserted/sec into a table or database.

No. Of Records inserted into a table/database

How do I findout number of records inserted/sec into a table or database.What is the version of SQL Server?
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
> How do I findout number of records inserted/sec into a table or database.|||I want to findout this information both in SQL Server 2000 and SQL Server 2005
"Uri Dimant" wrote:
> What is the version of SQL Server?
> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
> news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
> > How do I findout number of records inserted/sec into a table or database.
>
>|||If you want only INSERTED rows, you can create in both versions trigger on
table for INSERT and calculate them.
In SQL Server 2005 take a look at an OUTPUT clause
"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:6FBE1B30-CC16-4BCB-9C6C-4E6D3852BC42@.microsoft.com...
>I want to findout this information both in SQL Server 2000 and SQL Server
>2005
> "Uri Dimant" wrote:
>> What is the version of SQL Server?
>> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
>> news:406D4E62-A0D3-4CB9-9585-127A5A61D67B@.microsoft.com...
>> > How do I findout number of records inserted/sec into a table or
>> > database.
>>|||In almost all cases, you have to clock it yourself.
Linchi
"Balaji" wrote:
> How do I findout number of records inserted/sec into a table or database.