|
Home > Archive > microsoft.public.sqlserver.server > October 2002 > Any Available Scripts To Compare Objects' Counts On Two Servers?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Any Available Scripts To Compare Objects' Counts On Two Servers?
|
|
| marie2002m 2002-10-05, 9:08 pm |
| Hi; Is there a script or trigger somewhere that wold compare the objects'
record count of two databases on different servers and give a listing of the
results?
I just started to learn about SQL and triggers and found out that at this
point its far beyond me to write such a trigger.
Please help.........I need this script real bad.
Thank you very much
marie
| |
| John Bell 2002-10-05, 9:08 pm |
| Marie
You are cross posting separately to multiple groups again. Please see
my reply to your other post(s).
John
On Sun, 15 Sep 2002 13:40:19 GMT, "marie2002m"
<marie2002m@comcast.net> wrote:
>Hi; Is there a script or trigger somewhere that wold compare the objects'
>record count of two databases on different servers and give a listing of the
>results?
>I just started to learn about SQL and triggers and found out that at this
>point its far beyond me to write such a trigger.
>Please help.........I need this script real bad.
>
>Thank you very much
>marie
>
>
>
| |
| marie2002m 2002-10-05, 9:08 pm |
| sorry john, i just thought that from the newsgroup titles that more than one
group would be handling the subject matter of my post.
"John Bell" <jrm_bell@hotmail.com> wrote in message
news:t479ouom45tb6oaiccrdbjno0
vp9nj4amp@4ax.com...
> Marie
>
> You are cross posting separately to multiple groups again. Please see
> my reply to your other post(s).
>
> John
>
> On Sun, 15 Sep 2002 13:40:19 GMT, "marie2002m"
> <marie2002m@comcast.net> wrote:
>
> >Hi; Is there a script or trigger somewhere that wold compare the
objects'
> >record count of two databases on different servers and give a listing of
the
> >results?
> >I just started to learn about SQL and triggers and found out that at
this
> >point its far beyond me to write such a trigger.
> >Please help.........I need this script real bad.
> >
> >Thank you very much
> >marie
> >
> >
> >
>
| |
| John Bell 2002-10-05, 9:08 pm |
| Hi Marie
You can post the same thing to multiple groups in one go by specifying
all the newsgroups separated by a semi-colon in the newsgroups box; in
a similar way to how you specify multiple mail recipients. Then when
someone replies to a message they should then be able to reply to the
same groups all together.
John
On Sun, 15 Sep 2002 15:02:02 GMT, "marie2002m"
<marie2002m@comcast.net> wrote:
>sorry john, i just thought that from the newsgroup titles that more than one
>group would be handling the subject matter of my post.
>
>"John Bell" <jrm_bell@hotmail.com> wrote in message
> news:t479ouom45tb6oaiccrdbjno0
vp9nj4amp@4ax.com...
>> Marie
>>
>> You are cross posting separately to multiple groups again. Please see
>> my reply to your other post(s).
>>
>> John
>>
>> On Sun, 15 Sep 2002 13:40:19 GMT, "marie2002m"
>> <marie2002m@comcast.net> wrote:
>>
>> >Hi; Is there a script or trigger somewhere that wold compare the
> objects'
>> >record count of two databases on different servers and give a listing of
> the
>> >results?
>> >I just started to learn about SQL and triggers and found out that at
> this
>> >point its far beyond me to write such a trigger.
>> >Please help.........I need this script real bad.
>> >
>> >Thank you very much
>> >marie
>> >
>> >
>> >
>>
>
| |
| BP Margolin 2002-10-05, 9:08 pm |
| Marie,
Nobody objects to you posting a question to more than one newsgroup. The
objection is posting to each newsgroup separately. By posting to each
newsgroup separately, you are creating multiple independent threads. This
means that someone might spend time and effort posting a reply when your
question has already been answered in another newsgroup.
If you believe that your post is relevant to multiple newsgroups, then
please list all the newsgroups in the TO line, so that a single thread is
created, and any replies from any of the newsgroups can be seen in all the
newsgroups to which you have posted.
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"marie2002m" <marie2002m@comcast.net> wrote in message
news:Kh1h9.53095$gf6.1628903@bin4.nnrp.aus1.giganews.com...
> sorry john, i just thought that from the newsgroup titles that more than
one
> group would be handling the subject matter of my post.
>
> "John Bell" <jrm_bell@hotmail.com> wrote in message
> news:t479ouom45tb6oaiccrdbjno0
vp9nj4amp@4ax.com...
> > Marie
> >
> > You are cross posting separately to multiple groups again. Please see
> > my reply to your other post(s).
> >
> > John
> >
> > On Sun, 15 Sep 2002 13:40:19 GMT, "marie2002m"
> > <marie2002m@comcast.net> wrote:
> >
> > >Hi; Is there a script or trigger somewhere that wold compare the
> objects'
> > >record count of two databases on different servers and give a listing
of
> the
> > >results?
> > >I just started to learn about SQL and triggers and found out that at
> this
> > >point its far beyond me to write such a trigger.
> > >Please help.........I need this script real bad.
> > >
> > >Thank you very much
> > >marie
> > >
> > >
> > >
> >
>
>
|
|
|
|
|