Viewing 15 posts - 33,496 through 33,510 (of 39,804 total)
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
Probably a reg entry that you can remove, but I don't know how to do this. Might try a more Windows related site to help here.
I'll ask around.
December 28, 2005 at 9:32 am
Check that, it won't get committed until completed. So the entire thing will be noted in the transaction log, even in simple mode and not cleared until it completes.
December 28, 2005 at 9:32 am
Simple mode won't help unless you are processing other work. I believe this runs as one transaction, which means it wouldn't get logged until it was completed.
December 28, 2005 at 9:31 am
One of our authors, Haidong Ji, has written a little about it. There also was a competition from Microsoft and they provide a free tool to help you migrate:
December 28, 2005 at 9:28 am
Do you get this same counter in Performance Monitor, or System Monitor? Sounds like your counters might be screwed up.
For the article, create the stored procedure at the bottom, and...
December 28, 2005 at 9:26 am
I've heard the same thing. Usually PSS will instruct you to do this under certain circumstances. Not sure why they don't publish those circumstances, but who knows.
If it works for...
December 28, 2005 at 9:23 am
All the technology is there. The key is that it doesn't easily integrate.
December 27, 2005 at 5:16 pm
Viewing 15 posts - 33,496 through 33,510 (of 39,804 total)