We recently started experiencing a problem where certain customers at random 
would show up when searching for customers in the customer list in store ops 
manager, but will not show up in the list to select from when in POS.  We 
reindex the database regularly.  Any idea what could possibly be causing 
this?  Thanks for the help

Kevin

The customer(s) aren't set as global. Go to FILE, CONFIG, OPTIONS, CUSTOMER 
OPTIONS. You should enable GLOBAL CUSTOMERS FOR MULTI-STORE and NEW CUSTOMERS 
DEFAULT AS GLOBAL CUSTOMERS. Then, you may need to run a SQL QUERY to flip 
the Global Customer flags on for existing customer records (In SO Admin enter 
"Update Customer SET GlobalCustomer = 1").

And finally, don't let your cashiers change the CUSTOMER IS A 
GLOBAL/ENTERPRISE CUSTOMER flag when they enter NEW customer records.

Scott

"kskinne" wrote:

> We recently started experiencing a problem where certain customers at random 
> would show up when searching for customers in the customer list in store ops 
> manager, but will not show up in the list to select from when in POS.  We 
> reindex the database regularly.  Any idea what could possibly be causing 
> this?  Thanks for the help
> 
> Kevin

Scott thanks for the reply - but I don't believe this is the problem.

We already have both of these settings set this way in Manager, and have 
since we set up Store ops coming up on a few years ago.  We never have had 
this problem before, it has just started.

I checked to make sure and all of our customers in the store are currently 
set as global customers. 

Any other ideas?

Thanks,
Kevin


"Luminox" wrote:

> The customer(s) aren't set as global. Go to FILE, CONFIG, OPTIONS, CUSTOMER 
> OPTIONS. You should enable GLOBAL CUSTOMERS FOR MULTI-STORE and NEW CUSTOMERS 
> DEFAULT AS GLOBAL CUSTOMERS. Then, you may need to run a SQL QUERY to flip 
> the Global Customer flags on for existing customer records (In SO Admin enter 
> "Update Customer SET GlobalCustomer = 1").
> 
> And finally, don't let your cashiers change the CUSTOMER IS A 
> GLOBAL/ENTERPRISE CUSTOMER flag when they enter NEW customer records.
> 
> Scott
> 
> "kskinne" wrote:
> 
> > We recently started experiencing a problem where certain customers at random 
> > would show up when searching for customers in the customer list in store ops 
> > manager, but will not show up in the list to select from when in POS.  We 
> > reindex the database regularly.  Any idea what could possibly be causing 
> > this?  Thanks for the help
> > 
> > Kevin

Are the "customers" that DO show in SO and DON'T show in HQ defined as 
GLOBAL? Go into POS and look at the CUSTOMER OPTIONS tab for the PROPERTIES 
of the records.

If not, then my opinion is that the person (presumably a cashier) that 
created the record unchecked the CUSTOMER IS A GLOBAL/ENTERPRISE CUSTOMER 
flag when the record was created in POS by mistake. If the box is not checked 
try checking it and waiting for the next connection cycle.

If you run the query (UPDATE CUSTOMER SET GLOBALCUSTOMER = 1) against the SO 
database all of the flags will be set properly.


Scott

"kskinne" wrote:

> Scott thanks for the reply - but I don't believe this is the problem.
> 
> We already have both of these settings set this way in Manager, and have 
> since we set up Store ops coming up on a few years ago.  We never have had 
> this problem before, it has just started.
> 
> I checked to make sure and all of our customers in the store are currently 
> set as global customers. 
> 
> Any other ideas?
> 
> Thanks,
> Kevin
> 
> 
> "Luminox" wrote:
> 
> > The customer(s) aren't set as global. Go to FILE, CONFIG, OPTIONS, CUSTOMER 
> > OPTIONS. You should enable GLOBAL CUSTOMERS FOR MULTI-STORE and NEW CUSTOMERS 
> > DEFAULT AS GLOBAL CUSTOMERS. Then, you may need to run a SQL QUERY to flip 
> > the Global Customer flags on for existing customer records (In SO Admin enter 
> > "Update Customer SET GlobalCustomer = 1").
> > 
> > And finally, don't let your cashiers change the CUSTOMER IS A 
> > GLOBAL/ENTERPRISE CUSTOMER flag when they enter NEW customer records.
> > 
> > Scott
> > 
> > "kskinne" wrote:
> > 
> > > We recently started experiencing a problem where certain customers at random 
> > > would show up when searching for customers in the customer list in store ops 
> > > manager, but will not show up in the list to select from when in POS.  We 
> > > reindex the database regularly.  Any idea what could possibly be causing 
> > > this?  Thanks for the help
> > > 
> > > Kevin

This has absolutely nothing to do with Headquarters.  I checked the customer 
table in the Store Ops database, and every customer in the table has the 
'Global Customer' property set to = 1, so they are all global.  Certain of 
those customers show up in Store Operations manager when I go in and search 
for customers from the list of customers.  However when i log into POS, and 
go to set a customer on a transaction, those same customers that are visible 
in store ops Manager, are not showing up to choose from in the list of 
available customers.  Same store database.  Again, this has nothing to do 
with the HQ database.

Any other ideas?

Thanks,
Kevin


"Luminox" wrote:

> Are the "customers" that DO show in SO and DON'T show in HQ defined as 
> GLOBAL? Go into POS and look at the CUSTOMER OPTIONS tab for the PROPERTIES 
> of the records.
> 
> If not, then my opinion is that the person (presumably a cashier) that 
> created the record unchecked the CUSTOMER IS A GLOBAL/ENTERPRISE CUSTOMER 
> flag when the record was created in POS by mistake. If the box is not checked 
> try checking it and waiting for the next connection cycle.
> 
> If you run the query (UPDATE CUSTOMER SET GLOBALCUSTOMER = 1) against the SO 
> database all of the flags will be set properly.
> 
> 
> Scott
> 
> "kskinne" wrote:
> 
> > Scott thanks for the reply - but I don't believe this is the problem.
> > 
> > We already have both of these settings set this way in Manager, and have 
> > since we set up Store ops coming up on a few years ago.  We never have had 
> > this problem before, it has just started.
> > 
> > I checked to make sure and all of our customers in the store are currently 
> > set as global customers. 
> > 
> > Any other ideas?
> > 
> > Thanks,
> > Kevin
> > 
> > 
> > "Luminox" wrote:
> > 
> > > The customer(s) aren't set as global. Go to FILE, CONFIG, OPTIONS, CUSTOMER 
> > > OPTIONS. You should enable GLOBAL CUSTOMERS FOR MULTI-STORE and NEW CUSTOMERS 
> > > DEFAULT AS GLOBAL CUSTOMERS. Then, you may need to run a SQL QUERY to flip 
> > > the Global Customer flags on for existing customer records (In SO Admin enter 
> > > "Update Customer SET GlobalCustomer = 1").
> > > 
> > > And finally, don't let your cashiers change the CUSTOMER IS A 
> > > GLOBAL/ENTERPRISE CUSTOMER flag when they enter NEW customer records.
> > > 
> > > Scott
> > > 
> > > "kskinne" wrote:
> > > 
> > > > We recently started experiencing a problem where certain customers at random 
> > > > would show up when searching for customers in the customer list in store ops 
> > > > manager, but will not show up in the list to select from when in POS.  We 
> > > > reindex the database regularly.  Any idea what could possibly be causing 
> > > > this?  Thanks for the help
> > > > 
> > > > Kevin

This is a multi-part message in MIME format.

------=_NextPart_000_05A5_01C74B8B.EBEE9F90
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

Kevin,

Make sure you are attached to the main database and not running in =
offline mode.

Make sure that you don't have Find turned on with some options turned =
off.

Make sure that you are connected to the same database/server: SO Admin | =
File | Connect | look at the database and server names on both machines.

--=20

Jeff=20
Check Point Software

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

You must be using Outlook Express/Windows Mail or some other type of =
newsgroup reader to
see and download the file attachment(s).  If you are not using a reader, =
follow
the link below to setup Outlook Express.  Click on "Open with =
newsreader"
under the MS Retail Management System on the right.

http://tinyurl.com/75bgz
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D

  "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message =
news:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
  We recently started experiencing a problem where certain customers at =
random=20
  would show up when searching for customers in the customer list in =
store ops=20
  manager, but will not show up in the list to select from when in POS.  =
We=20
  reindex the database regularly.  Any idea what could possibly be =
causing=20
  this?  Thanks for the help

  Kevin
------=_NextPart_000_05A5_01C74B8B.EBEE9F90
Content-Type: text/html;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.5730.11" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#008000>Kevin,</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Make sure you are attached to the main =
database and not=20
running in offline mode.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Make sure that you don't have Find turned on =
with some=20
options turned off.</FONT></DIV>
<DIV><FONT color=3D#008000></FONT>&nbsp;</DIV>
<DIV><FONT color=3D#008000>Make sure that you are connected to the same=20
database/server: SO Admin | File | Connect | look at the =
database&nbsp;and=20
server names on both machines.</FONT></DIV>
<DIV><BR>-- <BR><BR>Jeff <BR>Check Point Software</DIV>
<DIV>&nbsp;</DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D</DIV>
<DIV>&nbsp;</DIV>
<DIV>You must be using Outlook Express/Windows Mail or some other type =
of=20
newsgroup reader to<BR>see and download the file attachment(s).&nbsp; If =
you are=20
not using a reader, follow<BR>the link below to setup Outlook =
Express.&nbsp;=20
Click on "Open with newsreader"<BR>under the MS Retail Management System =
on the=20
right.</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"http://tinyurl.com/75bgz">http://tinyurl.com/75bgz</A><BR>=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<BR></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #008000 2px solid; MARGIN-RIGHT: 0px">
  <DIV>"kskinne" &lt;<A=20
  =
href=3D"mailto:kskinnerNOSPAM@win-4-u.com">kskinnerNOSPAM@win-4-u.com</A>=
&gt;=20
  wrote in message <A=20
  =
href=3D"news:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com">news:FA5=
AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com</A>...</DIV>We=20
  recently started experiencing a problem where certain customers at =
random=20
  <BR>would show up when searching for customers in the customer list in =
store=20
  ops <BR>manager, but will not show up in the list to select from when =
in=20
  POS.&nbsp; We <BR>reindex the database regularly.&nbsp; Any idea what =
could=20
  possibly be causing <BR>this?&nbsp; Thanks for the=20
help<BR><BR>Kevin</BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_05A5_01C74B8B.EBEE9F90--

Thanks for the reply - 

We haven't made any changes to any find option settings, or to any of the DB 
settings in Admin, I double-checked and they are all fine.  Also the database 
is not running offline mode either, so I'm not sure what is causing this to 
happen.

It has never happened prior to this, just started recently.  And the 
customers that are suddenly not appearing in POS are customers that have been 
in the store DB for many months.

Any other possible ideas?

Thanks for the help
Kevin


"Jeff @ Check Point Software" wrote:

> Kevin,
> 
> Make sure you are attached to the main database and not running in offline mode.
> 
> Make sure that you don't have Find turned on with some options turned off.
> 
> Make sure that you are connected to the same database/server: SO Admin | File | Connect | look at the database and server names on both machines.
> 
> -- 
> 
> Jeff 
> Check Point Software
> 
> =====================================================
> 
> You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
> see and download the file attachment(s).  If you are not using a reader, follow
> the link below to setup Outlook Express.  Click on "Open with newsreader"
> under the MS Retail Management System on the right.
> 
> http://tinyurl.com/75bgz
> =====================================================
> 
>   "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message news:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
>   We recently started experiencing a problem where certain customers at random 
>   would show up when searching for customers in the customer list in store ops 
>   manager, but will not show up in the list to select from when in POS.  We 
>   reindex the database regularly.  Any idea what could possibly be causing 
>   this?  Thanks for the help
> 
>   Kevin

If you haven't re-indexed the db from Store Ops Administrator, that
fixed a similar problem we were having.

-CP

On Feb 13, 10:15 am, kskinne <kskinnerNOS...@win-4-u.com> wrote:
> Thanks for the reply -
>
> We haven't made any changes to any find option settings, or to any of the DB
> settings in Admin, I double-checked and they are all fine.  Also the database
> is not running offline mode either, so I'm not sure what is causing this to
> happen.
>
> It has never happened prior to this, just started recently.  And the
> customers that are suddenly not appearing in POS are customers that have been
> in the store DB for many months.
>
> Any other possible ideas?
>
> Thanks for the help
> Kevin
>
> "Jeff @ Check Point Software" wrote:
>
>
>
> > Kevin,
>
> > Make sure you are attached to the main database and not running in offline mode.
>
> > Make sure that you don't have Find turned on with some options turned off.
>
> > Make sure that you are connected to the same database/server: SO Admin | File | Connect | look at the database and server names on both machines.
>
> > --
>
> > Jeff
> > Check Point Software
>
> > =====================================================
>
> > You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
> > see and download the file attachment(s).  If you are not using a reader, follow
> > the link below to setup Outlook Express.  Click on "Open with newsreader"
> > under the MS Retail Management System on the right.
>
> >http://tinyurl.com/75bgz
> > =====================================================
>
> >   "kskinne" <kskinnerNOS...@win-4-u.com> wrote in messagenews:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
> >   We recently started experiencing a problem where certain customers at random
> >   would show up when searching for customers in the customer list in store ops
> >   manager, but will not show up in the list to select from when in POS.  We
> >   reindex the database regularly.  Any idea what could possibly be causing
> >   this?  Thanks for the help
>
> >   Kevin- Hide quoted text -
>
> - Show quoted text -

It reindexes nightly right before it backs up, we have it set up with an osql 
command in a batch file, it runs as a scheduled task each night

"CP" wrote:

> If you haven't re-indexed the db from Store Ops Administrator, that
> fixed a similar problem we were having.
> 
> -CP
> 
> On Feb 13, 10:15 am, kskinne <kskinnerNOS...@win-4-u.com> wrote:
> > Thanks for the reply -
> >
> > We haven't made any changes to any find option settings, or to any of the DB
> > settings in Admin, I double-checked and they are all fine.  Also the database
> > is not running offline mode either, so I'm not sure what is causing this to
> > happen.
> >
> > It has never happened prior to this, just started recently.  And the
> > customers that are suddenly not appearing in POS are customers that have been
> > in the store DB for many months.
> >
> > Any other possible ideas?
> >
> > Thanks for the help
> > Kevin
> >
> > "Jeff @ Check Point Software" wrote:
> >
> >
> >
> > > Kevin,
> >
> > > Make sure you are attached to the main database and not running in offline mode.
> >
> > > Make sure that you don't have Find turned on with some options turned off.
> >
> > > Make sure that you are connected to the same database/server: SO Admin | File | Connect | look at the database and server names on both machines.
> >
> > > --
> >
> > > Jeff
> > > Check Point Software
> >
> > > =====================================================
> >
> > > You must be using Outlook Express/Windows Mail or some other type of newsgroup reader to
> > > see and download the file attachment(s).  If you are not using a reader, follow
> > > the link below to setup Outlook Express.  Click on "Open with newsreader"
> > > under the MS Retail Management System on the right.
> >
> > >http://tinyurl.com/75bgz
> > > =====================================================
> >
> > >   "kskinne" <kskinnerNOS...@win-4-u.com> wrote in messagenews:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
> > >   We recently started experiencing a problem where certain customers at random
> > >   would show up when searching for customers in the customer list in store ops
> > >   manager, but will not show up in the list to select from when in POS.  We
> > >   reindex the database regularly.  Any idea what could possibly be causing
> > >   this?  Thanks for the help
> >
> > >   Kevin- Hide quoted text -
> >
> > - Show quoted text -
> 
> 
> 

kskinne,
Could I ask you the osql command to reindex? I have all other tasks 
scheduled, but haven't been able to figure that one out.
Craig

"kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message 
news:95EEC694-7775-4D84-B22B-E8AF8CB61A25@microsoft.com...
> It reindexes nightly right before it backs up, we have it set up with an 
> osql
> command in a batch file, it runs as a scheduled task each night
>
> "CP" wrote:
>
>> If you haven't re-indexed the db from Store Ops Administrator, that
>> fixed a similar problem we were having.
>>
>> -CP
>>
>> On Feb 13, 10:15 am, kskinne <kskinnerNOS...@win-4-u.com> wrote:
>> > Thanks for the reply -
>> >
>> > We haven't made any changes to any find option settings, or to any of 
>> > the DB
>> > settings in Admin, I double-checked and they are all fine.  Also the 
>> > database
>> > is not running offline mode either, so I'm not sure what is causing 
>> > this to
>> > happen.
>> >
>> > It has never happened prior to this, just started recently.  And the
>> > customers that are suddenly not appearing in POS are customers that 
>> > have been
>> > in the store DB for many months.
>> >
>> > Any other possible ideas?
>> >
>> > Thanks for the help
>> > Kevin
>> >
>> > "Jeff @ Check Point Software" wrote:
>> >
>> >
>> >
>> > > Kevin,
>> >
>> > > Make sure you are attached to the main database and not running in 
>> > > offline mode.
>> >
>> > > Make sure that you don't have Find turned on with some options turned 
>> > > off.
>> >
>> > > Make sure that you are connected to the same database/server: SO 
>> > > Admin | File | Connect | look at the database and server names on 
>> > > both machines.
>> >
>> > > --
>> >
>> > > Jeff
>> > > Check Point Software
>> >
>> > > =====================================================
>> >
>> > > You must be using Outlook Express/Windows Mail or some other type of 
>> > > newsgroup reader to
>> > > see and download the file attachment(s).  If you are not using a 
>> > > reader, follow
>> > > the link below to setup Outlook Express.  Click on "Open with 
>> > > newsreader"
>> > > under the MS Retail Management System on the right.
>> >
>> > >http://tinyurl.com/75bgz
>> > > =====================================================
>> >
>> > >   "kskinne" <kskinnerNOS...@win-4-u.com> wrote in 
>> > > messagenews:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
>> > >   We recently started experiencing a problem where certain customers 
>> > > at random
>> > >   would show up when searching for customers in the customer list in 
>> > > store ops
>> > >   manager, but will not show up in the list to select from when in 
>> > > POS.  We
>> > >   reindex the database regularly.  Any idea what could possibly be 
>> > > causing
>> > >   this?  Thanks for the help
>> >
>> > >   Kevin- Hide quoted text -
>> >
>> > - Show quoted text -
>>
>>
>> 

Craig insert the following line into a OSQL command line, as the query string:

sp_msforeachtable @command1 = 'DBCC DBREINDEX ([?])

The sp_msforeachtable is a stored procedure in the master DB that allows you 
to run the reindex command as shown above, on every table in the DB you 
specify in your OSQL command line

Hope this helps
Kevin


"Craig" wrote:

> kskinne,
> Could I ask you the osql command to reindex? I have all other tasks 
> scheduled, but haven't been able to figure that one out.
> Craig
> 
> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message 
> news:95EEC694-7775-4D84-B22B-E8AF8CB61A25@microsoft.com...
> > It reindexes nightly right before it backs up, we have it set up with an 
> > osql
> > command in a batch file, it runs as a scheduled task each night
> >
> > "CP" wrote:
> >
> >> If you haven't re-indexed the db from Store Ops Administrator, that
> >> fixed a similar problem we were having.
> >>
> >> -CP
> >>
> >> On Feb 13, 10:15 am, kskinne <kskinnerNOS...@win-4-u.com> wrote:
> >> > Thanks for the reply -
> >> >
> >> > We haven't made any changes to any find option settings, or to any of 
> >> > the DB
> >> > settings in Admin, I double-checked and they are all fine.  Also the 
> >> > database
> >> > is not running offline mode either, so I'm not sure what is causing 
> >> > this to
> >> > happen.
> >> >
> >> > It has never happened prior to this, just started recently.  And the
> >> > customers that are suddenly not appearing in POS are customers that 
> >> > have been
> >> > in the store DB for many months.
> >> >
> >> > Any other possible ideas?
> >> >
> >> > Thanks for the help
> >> > Kevin
> >> >
> >> > "Jeff @ Check Point Software" wrote:
> >> >
> >> >
> >> >
> >> > > Kevin,
> >> >
> >> > > Make sure you are attached to the main database and not running in 
> >> > > offline mode.
> >> >
> >> > > Make sure that you don't have Find turned on with some options turned 
> >> > > off.
> >> >
> >> > > Make sure that you are connected to the same database/server: SO 
> >> > > Admin | File | Connect | look at the database and server names on 
> >> > > both machines.
> >> >
> >> > > --
> >> >
> >> > > Jeff
> >> > > Check Point Software
> >> >
> >> > > =====================================================
> >> >
> >> > > You must be using Outlook Express/Windows Mail or some other type of 
> >> > > newsgroup reader to
> >> > > see and download the file attachment(s).  If you are not using a 
> >> > > reader, follow
> >> > > the link below to setup Outlook Express.  Click on "Open with 
> >> > > newsreader"
> >> > > under the MS Retail Management System on the right.
> >> >
> >> > >http://tinyurl.com/75bgz
> >> > > =====================================================
> >> >
> >> > >   "kskinne" <kskinnerNOS...@win-4-u.com> wrote in 
> >> > > messagenews:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
> >> > >   We recently started experiencing a problem where certain customers 
> >> > > at random
> >> > >   would show up when searching for customers in the customer list in 
> >> > > store ops
> >> > >   manager, but will not show up in the list to select from when in 
> >> > > POS.  We
> >> > >   reindex the database regularly.  Any idea what could possibly be 
> >> > > causing
> >> > >   this?  Thanks for the help
> >> >
> >> > >   Kevin- Hide quoted text -
> >> >
> >> > - Show quoted text -
> >>
> >>
> >> 
> 
> 
> 

I hate to be a pest, but this is a little over my head. I know how to make a 
batch file, but really don't know that much about writing Osql commands. If 
you would be so kind as to elaborate I would be grateful.
Craig

"kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message 
news:900462AF-AE4F-414F-8BA8-D6A6BCF81C47@microsoft.com...
> Craig insert the following line into a OSQL command line, as the query 
> string:
>
> sp_msforeachtable @command1 = 'DBCC DBREINDEX ([?])
>
> The sp_msforeachtable is a stored procedure in the master DB that allows 
> you
> to run the reindex command as shown above, on every table in the DB you
> specify in your OSQL command line
>
> Hope this helps
> Kevin
>
>
> "Craig" wrote:
>
>> kskinne,
>> Could I ask you the osql command to reindex? I have all other tasks
>> scheduled, but haven't been able to figure that one out.
>> Craig
>>
>> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message
>> news:95EEC694-7775-4D84-B22B-E8AF8CB61A25@microsoft.com...
>> > It reindexes nightly right before it backs up, we have it set up with 
>> > an
>> > osql
>> > command in a batch file, it runs as a scheduled task each night
>> >
>> > "CP" wrote:
>> >
>> >> If you haven't re-indexed the db from Store Ops Administrator, that
>> >> fixed a similar problem we were having.
>> >>
>> >> -CP
>> >>
>> >> On Feb 13, 10:15 am, kskinne <kskinnerNOS...@win-4-u.com> wrote:
>> >> > Thanks for the reply -
>> >> >
>> >> > We haven't made any changes to any find option settings, or to any 
>> >> > of
>> >> > the DB
>> >> > settings in Admin, I double-checked and they are all fine.  Also the
>> >> > database
>> >> > is not running offline mode either, so I'm not sure what is causing
>> >> > this to
>> >> > happen.
>> >> >
>> >> > It has never happened prior to this, just started recently.  And the
>> >> > customers that are suddenly not appearing in POS are customers that
>> >> > have been
>> >> > in the store DB for many months.
>> >> >
>> >> > Any other possible ideas?
>> >> >
>> >> > Thanks for the help
>> >> > Kevin
>> >> >
>> >> > "Jeff @ Check Point Software" wrote:
>> >> >
>> >> >
>> >> >
>> >> > > Kevin,
>> >> >
>> >> > > Make sure you are attached to the main database and not running in
>> >> > > offline mode.
>> >> >
>> >> > > Make sure that you don't have Find turned on with some options 
>> >> > > turned
>> >> > > off.
>> >> >
>> >> > > Make sure that you are connected to the same database/server: SO
>> >> > > Admin | File | Connect | look at the database and server names on
>> >> > > both machines.
>> >> >
>> >> > > --
>> >> >
>> >> > > Jeff
>> >> > > Check Point Software
>> >> >
>> >> > > =====================================================
>> >> >
>> >> > > You must be using Outlook Express/Windows Mail or some other type 
>> >> > > of
>> >> > > newsgroup reader to
>> >> > > see and download the file attachment(s).  If you are not using a
>> >> > > reader, follow
>> >> > > the link below to setup Outlook Express.  Click on "Open with
>> >> > > newsreader"
>> >> > > under the MS Retail Management System on the right.
>> >> >
>> >> > >http://tinyurl.com/75bgz
>> >> > > =====================================================
>> >> >
>> >> > >   "kskinne" <kskinnerNOS...@win-4-u.com> wrote in
>> >> > > messagenews:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
>> >> > >   We recently started experiencing a problem where certain 
>> >> > > customers
>> >> > > at random
>> >> > >   would show up when searching for customers in the customer list 
>> >> > > in
>> >> > > store ops
>> >> > >   manager, but will not show up in the list to select from when in
>> >> > > POS.  We
>> >> > >   reindex the database regularly.  Any idea what could possibly be
>> >> > > causing
>> >> > >   this?  Thanks for the help
>> >> >
>> >> > >   Kevin- Hide quoted text -
>> >> >
>> >> > - Show quoted text -
>> >>
>> >>
>> >>
>>
>>
>> 

This is a command line in our batch file:

OSQL -U sa -P password -S servername -Q "sp_msforeachtable @command1 = 'DBCC 
DBREINDEX ([?])"

replace password with your sa password, and replace servername with the name 
of your server.  If you google 'OSQL' you can also find a lot of sites that 
explain in more data how to use OSQL to run SQL queries

hth
kevin


"Craig" wrote:

> I hate to be a pest, but this is a little over my head. I know how to make a 
> batch file, but really don't know that much about writing Osql commands. If 
> you would be so kind as to elaborate I would be grateful.
> Craig
> 
> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message 
> news:900462AF-AE4F-414F-8BA8-D6A6BCF81C47@microsoft.com...
> > Craig insert the following line into a OSQL command line, as the query 
> > string:
> >
> > sp_msforeachtable @command1 = 'DBCC DBREINDEX ([?])
> >
> > The sp_msforeachtable is a stored procedure in the master DB that allows 
> > you
> > to run the reindex command as shown above, on every table in the DB you
> > specify in your OSQL command line
> >
> > Hope this helps
> > Kevin
> >
> >
> > "Craig" wrote:
> >
> >> kskinne,
> >> Could I ask you the osql command to reindex? I have all other tasks
> >> scheduled, but haven't been able to figure that one out.
> >> Craig
> >>
> >> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message
> >> news:95EEC694-7775-4D84-B22B-E8AF8CB61A25@microsoft.com...
> >> > It reindexes nightly right before it backs up, we have it set up with 
> >> > an
> >> > osql
> >> > command in a batch file, it runs as a scheduled task each night
> >> >
> >> > "CP" wrote:
> >> >
> >> >> If you haven't re-indexed the db from Store Ops Administrator, that
> >> >> fixed a similar problem we were having.
> >> >>
> >> >> -CP
> >> >>
> >> >> On Feb 13, 10:15 am, kskinne <kskinnerNOS...@win-4-u.com> wrote:
> >> >> > Thanks for the reply -
> >> >> >
> >> >> > We haven't made any changes to any find option settings, or to any 
> >> >> > of
> >> >> > the DB
> >> >> > settings in Admin, I double-checked and they are all fine.  Also the
> >> >> > database
> >> >> > is not running offline mode either, so I'm not sure what is causing
> >> >> > this to
> >> >> > happen.
> >> >> >
> >> >> > It has never happened prior to this, just started recently.  And the
> >> >> > customers that are suddenly not appearing in POS are customers that
> >> >> > have been
> >> >> > in the store DB for many months.
> >> >> >
> >> >> > Any other possible ideas?
> >> >> >
> >> >> > Thanks for the help
> >> >> > Kevin
> >> >> >
> >> >> > "Jeff @ Check Point Software" wrote:
> >> >> >
> >> >> >
> >> >> >
> >> >> > > Kevin,
> >> >> >
> >> >> > > Make sure you are attached to the main database and not running in
> >> >> > > offline mode.
> >> >> >
> >> >> > > Make sure that you don't have Find turned on with some options 
> >> >> > > turned
> >> >> > > off.
> >> >> >
> >> >> > > Make sure that you are connected to the same database/server: SO
> >> >> > > Admin | File | Connect | look at the database and server names on
> >> >> > > both machines.
> >> >> >
> >> >> > > --
> >> >> >
> >> >> > > Jeff
> >> >> > > Check Point Software
> >> >> >
> >> >> > > =====================================================
> >> >> >
> >> >> > > You must be using Outlook Express/Windows Mail or some other type 
> >> >> > > of
> >> >> > > newsgroup reader to
> >> >> > > see and download the file attachment(s).  If you are not using a
> >> >> > > reader, follow
> >> >> > > the link below to setup Outlook Express.  Click on "Open with
> >> >> > > newsreader"
> >> >> > > under the MS Retail Management System on the right.
> >> >> >
> >> >> > >http://tinyurl.com/75bgz
> >> >> > > =====================================================
> >> >> >
> >> >> > >   "kskinne" <kskinnerNOS...@win-4-u.com> wrote in
> >> >> > > messagenews:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
> >> >> > >   We recently started experiencing a problem where certain 
> >> >> > > customers
> >> >> > > at random
> >> >> > >   would show up when searching for customers in the customer list 
> >> >> > > in
> >> >> > > store ops
> >> >> > >   manager, but will not show up in the list to select from when in
> >> >> > > POS.  We
> >> >> > >   reindex the database regularly.  Any idea what could possibly be
> >> >> > > causing
> >> >> > >   this?  Thanks for the help
> >> >> >
> >> >> > >   Kevin- Hide quoted text -
> >> >> >
> >> >> > - Show quoted text -
> >> >>
> >> >>
> >> >>
> >>
> >>
> >> 
> 
> 
> 

Thanks Kevin, this will really beat having to remember to reindex on a 
regular basis after backing up. Just to clarify, this command will reindex 
the entire database? Thanks again.
Craig

"kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message 
news:7EA45ED5-401A-43A4-B14E-ADFC13CE6C3B@microsoft.com...
> This is a command line in our batch file:
>
> OSQL -U sa -P password -S servername -Q "sp_msforeachtable @command1 = 
> 'DBCC
> DBREINDEX ([?])"
>
> replace password with your sa password, and replace servername with the 
> name
> of your server.  If you google 'OSQL' you can also find a lot of sites 
> that
> explain in more data how to use OSQL to run SQL queries
>
> hth
> kevin
>
>
> "Craig" wrote:
>
>> I hate to be a pest, but this is a little over my head. I know how to 
>> make a
>> batch file, but really don't know that much about writing Osql commands. 
>> If
>> you would be so kind as to elaborate I would be grateful.
>> Craig
>>
>> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message
>> news:900462AF-AE4F-414F-8BA8-D6A6BCF81C47@microsoft.com...
>> > Craig insert the following line into a OSQL command line, as the query
>> > string:
>> >
>> > sp_msforeachtable @command1 = 'DBCC DBREINDEX ([?])
>> >
>> > The sp_msforeachtable is a stored procedure in the master DB that 
>> > allows
>> > you
>> > to run the reindex command as shown above, on every table in the DB you
>> > specify in your OSQL command line
>> >
>> > Hope this helps
>> > Kevin
>> >
>> >
>> > "Craig" wrote:
>> >
>> >> kskinne,
>> >> Could I ask you the osql command to reindex? I have all other tasks
>> >> scheduled, but haven't been able to figure that one out.
>> >> Craig
>> >>
>> >> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message
>> >> news:95EEC694-7775-4D84-B22B-E8AF8CB61A25@microsoft.com...
>> >> > It reindexes nightly right before it backs up, we have it set up 
>> >> > with
>> >> > an
>> >> > osql
>> >> > command in a batch file, it runs as a scheduled task each night
>> >> >
>> >> > "CP" wrote:
>> >> >
>> >> >> If you haven't re-indexed the db from Store Ops Administrator, that
>> >> >> fixed a similar problem we were having.
>> >> >>
>> >> >> -CP
>> >> >>
>> >> >> On Feb 13, 10:15 am, kskinne <kskinnerNOS...@win-4-u.com> wrote:
>> >> >> > Thanks for the reply -
>> >> >> >
>> >> >> > We haven't made any changes to any find option settings, or to 
>> >> >> > any
>> >> >> > of
>> >> >> > the DB
>> >> >> > settings in Admin, I double-checked and they are all fine.  Also 
>> >> >> > the
>> >> >> > database
>> >> >> > is not running offline mode either, so I'm not sure what is 
>> >> >> > causing
>> >> >> > this to
>> >> >> > happen.
>> >> >> >
>> >> >> > It has never happened prior to this, just started recently.  And 
>> >> >> > the
>> >> >> > customers that are suddenly not appearing in POS are customers 
>> >> >> > that
>> >> >> > have been
>> >> >> > in the store DB for many months.
>> >> >> >
>> >> >> > Any other possible ideas?
>> >> >> >
>> >> >> > Thanks for the help
>> >> >> > Kevin
>> >> >> >
>> >> >> > "Jeff @ Check Point Software" wrote:
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > > Kevin,
>> >> >> >
>> >> >> > > Make sure you are attached to the main database and not running 
>> >> >> > > in
>> >> >> > > offline mode.
>> >> >> >
>> >> >> > > Make sure that you don't have Find turned on with some options
>> >> >> > > turned
>> >> >> > > off.
>> >> >> >
>> >> >> > > Make sure that you are connected to the same database/server: 
>> >> >> > > SO
>> >> >> > > Admin | File | Connect | look at the database and server names 
>> >> >> > > on
>> >> >> > > both machines.
>> >> >> >
>> >> >> > > --
>> >> >> >
>> >> >> > > Jeff
>> >> >> > > Check Point Software
>> >> >> >
>> >> >> > > =====================================================
>> >> >> >
>> >> >> > > You must be using Outlook Express/Windows Mail or some other 
>> >> >> > > type
>> >> >> > > of
>> >> >> > > newsgroup reader to
>> >> >> > > see and download the file attachment(s).  If you are not using 
>> >> >> > > a
>> >> >> > > reader, follow
>> >> >> > > the link below to setup Outlook Express.  Click on "Open with
>> >> >> > > newsreader"
>> >> >> > > under the MS Retail Management System on the right.
>> >> >> >
>> >> >> > >http://tinyurl.com/75bgz
>> >> >> > > =====================================================
>> >> >> >
>> >> >> > >   "kskinne" <kskinnerNOS...@win-4-u.com> wrote in
>> >> >> > > messagenews:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
>> >> >> > >   We recently started experiencing a problem where certain
>> >> >> > > customers
>> >> >> > > at random
>> >> >> > >   would show up when searching for customers in the customer 
>> >> >> > > list
>> >> >> > > in
>> >> >> > > store ops
>> >> >> > >   manager, but will not show up in the list to select from when 
>> >> >> > > in
>> >> >> > > POS.  We
>> >> >> > >   reindex the database regularly.  Any idea what could possibly 
>> >> >> > > be
>> >> >> > > causing
>> >> >> > >   this?  Thanks for the help
>> >> >> >
>> >> >> > >   Kevin- Hide quoted text -
>> >> >> >
>> >> >> > - Show quoted text -
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>> 

yes that's correct

"Craig" wrote:

> Thanks Kevin, this will really beat having to remember to reindex on a 
> regular basis after backing up. Just to clarify, this command will reindex 
> the entire database? Thanks again.
> Craig
> 
> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message 
> news:7EA45ED5-401A-43A4-B14E-ADFC13CE6C3B@microsoft.com...
> > This is a command line in our batch file:
> >
> > OSQL -U sa -P password -S servername -Q "sp_msforeachtable @command1 = 
> > 'DBCC
> > DBREINDEX ([?])"
> >
> > replace password with your sa password, and replace servername with the 
> > name
> > of your server.  If you google 'OSQL' you can also find a lot of sites 
> > that
> > explain in more data how to use OSQL to run SQL queries
> >
> > hth
> > kevin
> >
> >
> > "Craig" wrote:
> >
> >> I hate to be a pest, but this is a little over my head. I know how to 
> >> make a
> >> batch file, but really don't know that much about writing Osql commands. 
> >> If
> >> you would be so kind as to elaborate I would be grateful.
> >> Craig
> >>
> >> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message
> >> news:900462AF-AE4F-414F-8BA8-D6A6BCF81C47@microsoft.com...
> >> > Craig insert the following line into a OSQL command line, as the query
> >> > string:
> >> >
> >> > sp_msforeachtable @command1 = 'DBCC DBREINDEX ([?])
> >> >
> >> > The sp_msforeachtable is a stored procedure in the master DB that 
> >> > allows
> >> > you
> >> > to run the reindex command as shown above, on every table in the DB you
> >> > specify in your OSQL command line
> >> >
> >> > Hope this helps
> >> > Kevin
> >> >
> >> >
> >> > "Craig" wrote:
> >> >
> >> >> kskinne,
> >> >> Could I ask you the osql command to reindex? I have all other tasks
> >> >> scheduled, but haven't been able to figure that one out.
> >> >> Craig
> >> >>
> >> >> "kskinne" <kskinnerNOSPAM@win-4-u.com> wrote in message
> >> >> news:95EEC694-7775-4D84-B22B-E8AF8CB61A25@microsoft.com...
> >> >> > It reindexes nightly right before it backs up, we have it set up 
> >> >> > with
> >> >> > an
> >> >> > osql
> >> >> > command in a batch file, it runs as a scheduled task each night
> >> >> >
> >> >> > "CP" wrote:
> >> >> >
> >> >> >> If you haven't re-indexed the db from Store Ops Administrator, that
> >> >> >> fixed a similar problem we were having.
> >> >> >>
> >> >> >> -CP
> >> >> >>
> >> >> >> On Feb 13, 10:15 am, kskinne <kskinnerNOS...@win-4-u.com> wrote:
> >> >> >> > Thanks for the reply -
> >> >> >> >
> >> >> >> > We haven't made any changes to any find option settings, or to 
> >> >> >> > any
> >> >> >> > of
> >> >> >> > the DB
> >> >> >> > settings in Admin, I double-checked and they are all fine.  Also 
> >> >> >> > the
> >> >> >> > database
> >> >> >> > is not running offline mode either, so I'm not sure what is 
> >> >> >> > causing
> >> >> >> > this to
> >> >> >> > happen.
> >> >> >> >
> >> >> >> > It has never happened prior to this, just started recently.  And 
> >> >> >> > the
> >> >> >> > customers that are suddenly not appearing in POS are customers 
> >> >> >> > that
> >> >> >> > have been
> >> >> >> > in the store DB for many months.
> >> >> >> >
> >> >> >> > Any other possible ideas?
> >> >> >> >
> >> >> >> > Thanks for the help
> >> >> >> > Kevin
> >> >> >> >
> >> >> >> > "Jeff @ Check Point Software" wrote:
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> > > Kevin,
> >> >> >> >
> >> >> >> > > Make sure you are attached to the main database and not running 
> >> >> >> > > in
> >> >> >> > > offline mode.
> >> >> >> >
> >> >> >> > > Make sure that you don't have Find turned on with some options
> >> >> >> > > turned
> >> >> >> > > off.
> >> >> >> >
> >> >> >> > > Make sure that you are connected to the same database/server: 
> >> >> >> > > SO
> >> >> >> > > Admin | File | Connect | look at the database and server names 
> >> >> >> > > on
> >> >> >> > > both machines.
> >> >> >> >
> >> >> >> > > --
> >> >> >> >
> >> >> >> > > Jeff
> >> >> >> > > Check Point Software
> >> >> >> >
> >> >> >> > > =====================================================
> >> >> >> >
> >> >> >> > > You must be using Outlook Express/Windows Mail or some other 
> >> >> >> > > type
> >> >> >> > > of
> >> >> >> > > newsgroup reader to
> >> >> >> > > see and download the file attachment(s).  If you are not using 
> >> >> >> > > a
> >> >> >> > > reader, follow
> >> >> >> > > the link below to setup Outlook Express.  Click on "Open with
> >> >> >> > > newsreader"
> >> >> >> > > under the MS Retail Management System on the right.
> >> >> >> >
> >> >> >> > >http://tinyurl.com/75bgz
> >> >> >> > > =====================================================
> >> >> >> >
> >> >> >> > >   "kskinne" <kskinnerNOS...@win-4-u.com> wrote in
> >> >> >> > > messagenews:FA5AFF25-86F5-4DD5-8891-D8BAC8AB1CEA@microsoft.com...
> >> >> >> > >   We recently started experiencing a problem where certain
> >> >> >> > > customers
> >> >> >> > > at random
> >> >> >> > >   would show up when searching for customers in the customer 
> >> >> >> > > list
> >> >> >> > > in
> >> >> >> > > store ops
> >> >> >> > >   manager, but will not show up in the list to select from when 
> >> >> >> > > in
> >> >> >> > > POS.  We
> >> >> >> > >   reindex the database regularly.  Any idea what could possibly 
> >> >> >> > > be
> >> >> >> > > causing
> >> >> >> > >   this?  Thanks for the help
> >> >> >> >
> >> >> >> > >   Kevin- Hide quoted text -
> >> >> >> >
> >> >> >> > - Show quoted text -
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >> 
> 
> 
>