Application Warning

I can't find any information to correct the following warning message that I
receive in Event Viewer.
Event Type: Warning
Event Source: Microsoft Search
Event Category: Gatherer
Event ID: 3055
Description: The gatherer property mapping file cannot be opened. Error:
80070003. The default values are being used. You may have to copy the
property mapping file from the Setup CD-ROM, or reinstall the application.
Environment:
Windows 2000 Server SP4
SQL Server 2000 SP4 Standard Edition (8.00.2039)
MDAC 2.81.1117.6
The server is not in a cluster, and doesn't have Exchange installed. Any
assistance would greatly be appreciated!!!
Tom
Tom
Are you sure that it relates to SQL Server?
"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>I can't find any information to correct the following warning message that
>I
> receive in Event Viewer.
> Event Type: Warning
> Event Source: Microsoft Search
> Event Category: Gatherer
> Event ID: 3055
> Description: The gatherer property mapping file cannot be opened. Error:
> 80070003. The default values are being used. You may have to copy the
> property mapping file from the Setup CD-ROM, or reinstall the application.
> Environment:
> Windows 2000 Server SP4
> SQL Server 2000 SP4 Standard Edition (8.00.2039)
> MDAC 2.81.1117.6
> The server is not in a cluster, and doesn't have Exchange installed. Any
> assistance would greatly be appreciated!!!
> --
> Tom
|||Uri:
I don't really have anything else on the server besides backup software.
The only items that I've found related to this message is for Exchange and
SQL in a clustered environment. I don't have Exchange installed on this
server and I'm not running SQL in a clustered environment.
Thanks!!!
Tom
"Uri Dimant" wrote:

> Tom
> Are you sure that it relates to SQL Server?
> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>
>
|||"Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
news:6E260383-2E19-4C9C-8B3B-987293B9B57D@.microsoft.com...
> Uri:
> I don't really have anything else on the server besides backup software.
> The only items that I've found related to this message is for Exchange and
> SQL in a clustered environment. I don't have Exchange installed on this
> server and I'm not running SQL in a clustered environment.
If you search MSDN on "Gatherer", you will find that this term is a part of
other components as well. In particular, sharepoint and the Indexing
Services. There is also something called Windows Desktop Search. Also,
oblique references to outlook.
|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23yE7p9$BHHA.4256@.TK2MSFTNGP04.phx.gbl...
> Tom
> Are you sure that it relates to SQL Server?
Certainly looks like a Full Text Search issue.

> "Tom Roth" <TomRoth@.discussions.microsoft.com> wrote in message
> news:5D9BD93E-3A82-44C9-A462-EEFAF32D1250@.microsoft.com...
>

App. Can't find database after a RESTORE

Hi,
My application in another server can't find the SQLServer database
after a restore. The name of the DB is exactly the same! The application say
s
the the Target Database does not match destination database. My question is:
Is it possible that the reason comes from the database even if the name is
exacty the same?
Do I have to restart the database server?
Thanks!
JoeYou don't have to 'restart' the server after a restore.
Can you connect to the database using Enterprise Mangler or Query Analyzer?
Please try connecting with EM and/or QA and post the entire error message.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Barb" <Barb@.discussions.microsoft.com> wrote in message
news:95F0ED39-6083-4586-936D-9BC582C314AC@.microsoft.com...
> Hi,
> My application in another server can't find the SQLServer database
> after a restore. The name of the DB is exactly the same! The application
> says
> the the Target Database does not match destination database. My question
> is:
> Is it possible that the reason comes from the database even if the name is
> exacty the same?
> Do I have to restart the database server?
> Thanks!
> Joe
>
>

API Reference for SQLDMO?

Ive been googling for a while now and i cant seem to find the API reference for SQLDMO.dll. Can any kind person paste an url? :)

The only thing I want to use it for is to know what kind of exceptions SQLServer.Connet() and SQLServer.attachDB() throws, but an url would be nice for futher use...

There are a couple of places you can find it. If you installed SQL Server, then you can find it in Books Online.

Otherwise, go here: http://msdn2.microsoft.com/en-us/library/ms133993.aspx

ap_ prefix to stored procedures

What does the ap_ stand for as a prefix to stored procedures?

A DBA tried to teach me something about the prefixes etc.. but I can't recall what it meant.

In this case ap_ may represent "ONE" persons naming convention?

something procedure...

other common ones in our database are dt_ and zz_

Its ok.. I know your all busy..

It is probably any naming convention I want..

I just thought it might be a case where the majority of SQL Developers use the same naming conventions.

Thanks.

|||

It is probably just some naming convention that the previous developers or dba's had. I have seen <Action><Table>, sp_<action><table>, and many others in the past.