he can also connect his named instance on local machine by typing

.\instance_name

OR

127.0.0.1\instance_name

Thanks for the link Wayne. However, we still have the option to toggle with the radio button on the installation wizard page which asks user whether to install a named/default...

That's right. If you get NOTHING in that column, nothing is preventing log file from getting truncated. Everything is running fine including your replication.

Also check if your distribution db log...

JamesNZ (6/20/2009)

---

The replication seems to be working just fine. I've just tested it and don't see a problem. Is there something I'm missing? Do I really have to re-set it...

Glad you got it running after so long :-P.

1. You need to re-setup...

nalmir.hugo (6/20/2009)

---

Thanks for the reply. SAP is an ERP ( Single COMPANY ) System. To make it a MultiCOMPANY ERP would you create a COMPANY TABLE and use its CompanyID...

OR type a period (.) in the Server Name and then connect. This will connect you to the default...

that's right.

run that command, backup log and let us know the result.

JamesNZ (6/20/2009)

---

Thanks for the response guys.

This is what I see with select * from syspublications . Please see attached text file.

No one I know of has been messing with...

nalmir.hugo (6/20/2009)

---

I have to create a information service for my clients. Informations for many different companies will be located in a only one database. I Have a companyID. Should a...

Obviously you can come here anytime to ask questions and ppl out here will be more than willing to assist.:-)

Paul White (6/20/2009)

---

Lynn Pettis (6/20/2009)

---

If we just give him answers and he ends up in a position that he isn't qualified for do, who's fault is it, ours or the...

Paul White (6/20/2009)

---

It took an enormous effort of will on my part not to...

Lynn Pettis (6/20/2009)

---

Well (and yes, that is a mighty deep subject for a weekend)...

1. you can put this conversion on the front end application that will convert the field to uppercase...

2. i dont know if this the best practice but you can write...