How much latency are you willing to accept? Will the replicated databases be serving as backup only (no reporting or anything else)?

In what manner does the task fail? Does it produce an error, or does it just not return the correct results (you were expecting to get ten records, but...

Henok,

I didn't want a day to go by without letting you know someone was looking into your issue. Fridays can get a bit crazy, but one of us should...

That's a new one to me. Could you post the sp code, and provide some sample input so we can test on other installs?

Thanks,

Sean

Sounds like what you are doing is just over-writing the .mdb "on the internet" with the local .mdb copy that your program uses. Is that correct? It's just...

Did you add the defualt object you created to the defualts collection first? Any reason why you would not just set the defualt property in the column object (oCol.DRIDefault.Text)?...

Now that's a cool tool. Frebbie's not too bad, and $98.00 for the full version seems a fair price for someone who needs this functionality! Are you connected...

Good find on the KB article David. I don't reccommend workaround #1 .

Patii, I'm curious to find out if workaround #2 works for...

What was the error that it returned? If you could give me the exact number and description, that would be most helpful.

Also, what version of SQL Server are...

... that should read "Can you POST the code...". Typing is not one of my strong points.

Marvin,

For the record, I have to agree with the last few posts about using a canned package - but only if it does what you need (sometimes it's easier to...

One thing I've noticed with the Execute Process task is that if your process has any type of User interface it will hang. I have a similar application as...

I imagine this will be a frequently visited part of the site. For those of you wishing to post and retrieve scripts, please let us know what you like...

When you say the the EOF line does not work, what exactly is the behavior/messages that you are getting as you step through the code?

That's not too bad either. Are they read-only properties, or can you write to them as well?