Viewing 15 posts - 3,316 through 3,330 (of 6,216 total)
Does look like a 7.0 problem, code works fine on my machine against a SQL2K instance and a later MSDE instance. Even worked ok if I changed compatibility mode to...
September 5, 2002 at 3:30 pm
September 5, 2002 at 2:58 pm
Before you do that you might try enabling the logging of the distribution agent, see what it says its doing, maybe profile it as well. Were the updates done as...
September 5, 2002 at 12:44 pm
Not that I remember anyway! Can you post the code?
Andy
September 5, 2002 at 12:43 pm
Should work fine. I've got an article posted here on the site that discusses moving to a new server, might give you some more ideas, start of a checklist kinda...
September 5, 2002 at 10:41 am
Sounds like it is still posting transactions. If you're in a hurry you might be better off to stop replication, reinit, send over a new snapshot. On a high speed...
September 5, 2002 at 10:40 am
Dont think so, you can do it from Query Analyzer.
Andy
September 5, 2002 at 10:33 am
September 5, 2002 at 10:32 am
The check is hard coded into the app. You "could" modify the proc and remove that check. Even then, depending on the options selected they would have to have permission...
September 5, 2002 at 6:33 am
Options are to embed a sql password/login, or have it run under the agent account (NT) and make sure it has the appropriate permissions. I normally go with sql login...
September 5, 2002 at 6:30 am
One way would be to implement a group policy that prohibits running isql.exe for that user. Other than that, you could embed a sql login in your application so that...
September 5, 2002 at 5:01 am
Injection attacks are a possibility, but remember that Exec() still only works with permissions given to the login. Typically I grant only execute permissions on procs to standard users, when...
September 5, 2002 at 4:57 am
SQL will usually be the publisher, Access the subscriber. Which version of Access and what type of replication?
Andy
September 5, 2002 at 4:53 am
Update in a different db from the first update? Same server?
Andy
September 4, 2002 at 5:51 pm
Well, not to be rude, but are you sure you're in the right place? I have an image on my dev machine at home rignt now, installs fine on Win2K....
September 4, 2002 at 5:49 pm
Viewing 15 posts - 3,316 through 3,330 (of 6,216 total)