MsQuery

I've heard when using MSQuery on the client side, the where statement
gets processes at the client side, thus many records come across that
are not necessary. Is that true?
If so, would Query Analyzer be a better choice? We are trying to run
queries against our server (we are not in IT) and we have been getting
CBSIO errors.
ThanksCBSIO?
It does seem fine. I ran it from the OFFICE11 folder for Office 2003 and it
sent the where clause to the server. It might do it on the client if you
have disparate sources, but I would doubt it on the same server.
Query Analyzer would be better, but it does not have the joining tools that
MSQuery does. As long as you get the performance you desire, it should be
fine.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
<bdaoust@.yahoo.com> wrote in message
news:1126273874.851824.292530@.g47g2000cwa.googlegroups.com...
> I've heard when using MSQuery on the client side, the where statement
> gets processes at the client side, thus many records come across that
> are not necessary. Is that true?
> If so, would Query Analyzer be a better choice? We are trying to run
> queries against our server (we are not in IT) and we have been getting
> CBSIO errors.
> Thanks
>|||Louis,
Thank you for the reply. When you say joining tools, what are you
referring to?
I guess I wouldnt miss them much since I dont even know what they are!
:)
Also, how can you confirm that the where clause was sent to the server?
Thank you.|||> Thank you for the reply. When you say joining tools, what are you
> referring to?
The query by example stuff that MSQuery has where you can pick the tables,
and it joins them for you, etc. If you don't need this and you are writing
SQL Statements in text, then query analyzer is the way to go anyhow.

> Also, how can you confirm that the where clause was sent to the server?
I used profiler and watched the statements being sent to the server.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
"Arguments are to be avoided: they are always vulgar and often convincing."
(Oscar Wilde)
"BerkshireGuy" <bdaoust@.yahoo.com> wrote in message
news:1126281216.691598.305900@.g47g2000cwa.googlegroups.com...
> Louis,
> Thank you for the reply. When you say joining tools, what are you
> referring to?
> I guess I wouldnt miss them much since I dont even know what they are!
> :)
> Also, how can you confirm that the where clause was sent to the server?
>
> Thank you.
>|||Aww I see, there is no design grid.
I am use to writing the SQL, so it will work for me. Hopefully IT is
willing to install it on my machine.
Thanks for the help.sql

msmerge_tombstone error

Hi everyone.Is there any one who could help me on this error which i
encountered when i manually delete some records on user table in my
database.I cannot delete records,the error indicates:
cannot insert duplicate key in row in object 'msmerge_tombstone' with unique
index 'uc1msmerge_tombstone'.
Someone help on this.
Thank you
Pheter Flores
On Dec 13, 1:29 pm, MICS <M...@.discussions.microsoft.com> wrote:
> Hi everyone.Is there any one who could help me on this error which i
> encountered when i manually delete some records on user table in my
> database.I cannot delete records,the error indicates:
> cannot insert duplicate key in row in object 'msmerge_tombstone' with unique
> index 'uc1msmerge_tombstone'.
> Someone help on this.
> Thank you
> Pheter Flores
Check if there is any trigger on Delete action
|||This must be about Replication. You may get a better answer if you send this
post to Replication NG.
Ekrem ?nsoy
"MICS" <MICS@.discussions.microsoft.com> wrote in message
news:CE9D159A-FC62-4A82-BDCD-CD60D2679709@.microsoft.com...
> Hi everyone.Is there any one who could help me on this error which i
> encountered when i manually delete some records on user table in my
> database.I cannot delete records,the error indicates:
> cannot insert duplicate key in row in object 'msmerge_tombstone' with
> unique
> index 'uc1msmerge_tombstone'.
> Someone help on this.
> Thank you
>
> Pheter Flores
sql

msmerge_tombstone error

Hi everyone.Is there any one who could help me on this error which i
encountered when i manually delete some records on user table in my
database.I cannot delete records,the error indicates:
cannot insert duplicate key in row in object 'msmerge_tombstone' with unique
index 'uc1msmerge_tombstone'.
Someone help on this.
Thank you
Pheter FloresOn Dec 13, 1:29 pm, MICS <M...@.discussions.microsoft.com> wrote:
> Hi everyone.Is there any one who could help me on this error which i
> encountered when i manually delete some records on user table in my
> database.I cannot delete records,the error indicates:
> cannot insert duplicate key in row in object 'msmerge_tombstone' with unique
> index 'uc1msmerge_tombstone'.
> Someone help on this.
> Thank you
> Pheter Flores
Check if there is any trigger on Delete action|||This must be about Replication. You may get a better answer if you send this
post to Replication NG.
--
Ekrem Ã?nsoy
"MICS" <MICS@.discussions.microsoft.com> wrote in message
news:CE9D159A-FC62-4A82-BDCD-CD60D2679709@.microsoft.com...
> Hi everyone.Is there any one who could help me on this error which i
> encountered when i manually delete some records on user table in my
> database.I cannot delete records,the error indicates:
> cannot insert duplicate key in row in object 'msmerge_tombstone' with
> unique
> index 'uc1msmerge_tombstone'.
> Someone help on this.
> Thank you
>
> Pheter Flores

msmerge_tombstone error

Hi everyone.Is there any one who could help me on this error which i
encountered when i manually delete some records on user table in my
database.I cannot delete records,the error indicates:
cannot insert duplicate key in row in object 'msmerge_tombstone' with unique
index 'uc1msmerge_tombstone'.
Someone help on this.
Thank you
Pheter FloresOn Dec 13, 1:29 pm, MICS <M...@.discussions.microsoft.com> wrote:
> Hi everyone.Is there any one who could help me on this error which i
> encountered when i manually delete some records on user table in my
> database.I cannot delete records,the error indicates:
> cannot insert duplicate key in row in object 'msmerge_tombstone' with uniq
ue
> index 'uc1msmerge_tombstone'.
> Someone help on this.
> Thank you
> Pheter Flores
Check if there is any trigger on Delete action|||This must be about Replication. You may get a better answer if you send this
post to Replication NG.
Ekrem ?nsoy
"MICS" <MICS@.discussions.microsoft.com> wrote in message
news:CE9D159A-FC62-4A82-BDCD-CD60D2679709@.microsoft.com...
> Hi everyone.Is there any one who could help me on this error which i
> encountered when i manually delete some records on user table in my
> database.I cannot delete records,the error indicates:
> cannot insert duplicate key in row in object 'msmerge_tombstone' with
> unique
> index 'uc1msmerge_tombstone'.
> Someone help on this.
> Thank you
>
> Pheter Flores