If you work with the DMO libraries, there is a ListSQLServers method call that will scan for those servers responding on 1434. this is sometimes blocked, especially after SQLSlammer, so...

If you netstat, is SQL Server listening on 1433 or possibly another port?

I'd double check the firewall. Firewall rules aren't necessarily global. You could have something blocked on that IP.

Charles has a good example.

If you mean the representation of the code as the numbers, then I'd use that. If you mean an image of the code, I wouldn't use that.

You can setup the...

firewall?

I'd suggest calling Microsoft PSS. The $249 cost isn't much and you are dealing with the low level internals here. They can help you work through this, though they may...

You can't do this with a case because that processes for each row. You'd need some way to "join" the two queries together. In other words, how do you get...

http://pcsupport.about.com/od/pcmaintenance/qt/addremove.htm

1. Yes

2. Look for the data in sysjobhistory in msdb.

3. Write a c# app to query this table

Also, pls don't cross post. We check all the forums.

There are other answers in the other thread.

The preview button only grabs like 200 records, so you could have duplicates after that. If you can use a select in the source with an ORDER by, then set...

We did this years ago and just for an hour had everyone double entry things. then we shut down for 10 minutes, copied the VFP database, and went back to...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp

You could see if Red Gate's Data Compare or the ApexSQL tool could give you a flat file of data, but it would be by tables.

I like David's advice if...

Yes, publisher and distributor exchange data, then distributor and subscriber.