Megistal (3/31/2009)

---

Hummm from the IP you seems to be on a "home" network (Class C). DNS names are not resolved for this. If I saw it right you then need...

Megistal (4/1/2009)

---

Damjan Djurasek, he is able to connect using the IP address therefore the port is not an issue. If the IP would have fail, then configuration, security configuration, sql...

Megistal (3/30/2009)

---

SQL Server Agent is to schedule tasks inside SQL Server. Not the mean to connect to an instance, this is the SQL Browser Service task to get you that...

Thanks for the help of Jack Corbett & GilaMonster.

I used the Host_Name() to detect record modified by which server.

Big thanks again. 😀

if no SQL Server Agent, how to remote connect the SQL Server?

May I know how to do that? 🙂

If I didn't upgrade SSMS 2005, what error would I get when try connect to SQL Server 2008?

Btw, for SQL Server 2008, I already Enable TCP/IP and Named Pipes at...

yes, sql server & sql browser are...

yes, I already set the Remote Connections to "Local and remote connections -> Using both TCP/IP and named pipes"

i used management studio -> Browse for Servers -> Network Servers, but i cannot see the server that...

If my table contain primary key, will DTS package be done?

If not mistaken, it will show error while copying...

Please correct me if I'm wrong 🙂

Thanks.

DST need done manually rite?

i think 5-10 minutes need pull the data