Viewing 15 posts - 286 through 300 (of 1,790 total)
One of the columns you are updating is smaller than the data you are trying to insert into it. You will have to figure out which one and adjust the...
February 25, 2011 at 1:56 pm
Sorry if my questions are seemingly nitpicky, I'm just trying to make sure that I understand completely. 🙂 Thanks for your patience.
Have you ever had the query run longer...
February 25, 2011 at 1:55 pm
I guess what I am asking is - If any query from this MS Access program on any machine runs longer than 60 seconds will you ALWAYS get the timeout?...
February 25, 2011 at 1:48 pm
And is that true on every machine that runs large queries that when they hit 60 seconds they get a timeout? Do you get the same?
February 25, 2011 at 1:30 pm
I don't know if I would use the word "overkill" but I would say it seems a bit odd of a use of a replication, even thought it may work...
February 25, 2011 at 1:27 pm
That is the only other thought that I can come up with at this point however I can't confirm that. Can you get to a machine that has the 2000...
February 25, 2011 at 1:12 pm
Hmmm, definitely odd. The only other thing that I can think of is that maybe the SSMS version that you are running somehow prevents you being able to create a...
February 25, 2011 at 12:09 pm
I was more thinking of changing it in the odbc component of the individual machines. So, under control panel, administrative tools, data sources, then either under system or file dsn...
February 25, 2011 at 12:07 pm
Is is possible that sa is not actually a part of the sysadmin server role? Can you check?
February 25, 2011 at 11:15 am
So you have set the timeout for the DSN (odbc defined connection) you are using to link those tables to 0 and are still getting timeouts?
February 25, 2011 at 10:59 am
Yes, maintenance plans were available in 2000. My guess is that you are lacking permissions to see / create those at this point.
February 25, 2011 at 10:56 am
The reality is though that DR is expensive and that is something that the company you work for is going to have to work with you on to determine what...
February 25, 2011 at 9:04 am
Being that your link is the "bottleneck" so to speak your solution should be something that can be sensitive to that and is going to send the least amount of...
February 25, 2011 at 8:19 am
Ian Scarlett (2/25/2011)
It would appear that all Microsoft have done is to make the...
February 25, 2011 at 7:01 am
Thanks Ian! I had not hit that situation, especially since my replication exposure has mostly been with 2005. Still sounds like there could be some issue as you describe.
DJ463...
February 25, 2011 at 6:37 am
Viewing 15 posts - 286 through 300 (of 1,790 total)