Viewing 15 posts - 2,926 through 2,940 (of 6,216 total)
Best you can do is obscure it, not sure even that worth doing. Figure anyone who can edit the package can see the password one way or another. Could look...
November 18, 2002 at 3:49 pm
I find it easier to have the proc initiate a job that runs the app - ok as long as async completion is what you want. Another alternative is to...
November 17, 2002 at 9:15 pm
No reason for you to be there if you go the job route. Have your friend catch up with us, between Brian, Steve, and I we have five sessions.
Andy
November 16, 2002 at 3:57 pm
Dont know that I qualify as guru, just interested in replication! I dont think changing owner will matter, the app role seems to be the issue. Dont have the answer,...
November 16, 2002 at 8:06 am
One approach I've seen is that if a user needs to edit an archived record it gets moved back with the "live" data so that all constraints and app logic...
November 16, 2002 at 5:55 am
November 15, 2002 at 5:01 am
November 14, 2002 at 7:18 pm
I think the "advantage" is that its built in, easy to add a quick note in EM. I think you have to look at what it may cost to build...
November 14, 2002 at 7:17 pm
Cool, had forgotten you posted that! Restoring to another server is just a bit more complicated, have to have the files accessible and you may still need to do the...
November 14, 2002 at 4:24 pm
Havent tried it. Does this article help?
http://support.microsoft.com/default.aspx?scid=KB;en-us;q290054
Andy
November 14, 2002 at 4:11 pm
For #1 (and #2), I'd guess the subscriber didnt have access to the share where the snapshot was created and/or something went wrong with the process, ie it got hung...
November 14, 2002 at 4:07 pm
Hoping that some of the changes mentioned above can be implemented - if not maybe look at marking the rows as deleted initially, then run the query off peak. Alternatively,...
November 14, 2002 at 4:00 pm
This looks close, I think you'd have to rename the data/log files to get it to work (unless you did replace). I'll work on it later tonight and post some...
November 14, 2002 at 3:47 pm
I'd double check that you're connecting with the sql account and not failing over to NT authentication.
Andy
November 13, 2002 at 4:35 pm
We run in per server (I think!, will check) and replication runs fine, but either way it should work. How exactly is it failing? What errors do you get, either...
November 13, 2002 at 4:32 pm
Viewing 15 posts - 2,926 through 2,940 (of 6,216 total)