Problem with Jobs

Hello all,

I am having a problem with the sql

DB on the company that I work for.

I got message under job history

on Enterprise manager is :

"The job failed.The Job was invoked by Schedule 15 (Replication

agent schedule.).The last step to run

was step 1 (Run agent.)"

and in the event log is:

Event ID: 208

Source: SQLAgent$(company DB)

"sql server Schedule (company DB)

status:Failed"

Please advice.

Thanks in advance

Kind regards

This relates to replication issues, which can be quite complex depending on what you're trying to do. You should review your replication scheme to ensure that all the data is going where it should. If the replication isn't happening, your files will grow on the distributor until it runs out of room.

If you're new to replication, check here:

http://msdn2.microsoft.com/en-us/library/ms151198.aspx

Problem with Hyphen in Full Text Catalog Search

Hi All,

we have a problem with the Full Text Catalog Search.
We use the following SQL Statement for matching companies from a table:

select company, lastname, firstname, pkcustomers, fkcustomers,
location, title, fkFunktionen, TypeOfPosition
from customers
where (fkcustomers = 0 or fkcustomers is null)
and active = 1
and pkCustomers in (select [KEY] from CONTAINSTABLE(Customers, Company,
'"*SEARCHTERMS*"'))
order by company asc

The search so far is working perfect.
Now the problem: There are two companies in the table called "i-fabrik"
and "b-wise". Theres no way to find these two companies. I find out
that the search is successful if there are more than three letters in
front of the hyphen (for exampe iii-fabrik or bbb-wise). How can that
be? Why exactly 3 letters?

I hope somebody can help me.

Best regards
Markus Weberhttp://support.microsoft.com/defaul...b;en-us;Q200043

Simon