Viewing 15 posts - 33,421 through 33,435 (of 39,736 total)
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...
December 28, 2005 at 4:21 pm
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.
December 28, 2005 at 4:19 pm
Charles has a good example.
December 28, 2005 at 4:17 pm
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...
December 28, 2005 at 1:11 pm
firewall?
December 28, 2005 at 1:08 pm
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...
December 28, 2005 at 1:07 pm
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...
December 28, 2005 at 1:06 pm
December 28, 2005 at 9:44 am
1. Yes
2. Look for the data in sysjobhistory in msdb.
3. Write a c# app to query this table ![]()
December 28, 2005 at 9:42 am
Also, pls don't cross post. We check all the forums.
There are other answers in the other thread.
December 28, 2005 at 9:41 am
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...
December 28, 2005 at 9:40 am
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...
December 28, 2005 at 9:39 am
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...
December 28, 2005 at 9:36 am
Yes, publisher and distributor exchange data, then distributor and subscriber.
December 28, 2005 at 9:34 am
Viewing 15 posts - 33,421 through 33,435 (of 39,736 total)