Viewing 15 posts - 121 through 135 (of 234 total)
On another Sybase subject, not linked servers; but odbc/jdbc driver usage... we got two separate DBs to connect to ASA (9.0) DBs and could query them; but even though it...
October 24, 2006 at 5:39 pm
We tried last November, first with Beta SW and then with GA... it would not work properly and we had two Sybase "guru's" on the premises with a marketing guy. ...
October 24, 2006 at 5:34 pm
curious, you are restarting RS... are you also restarting IIS?
October 24, 2006 at 5:28 pm
you can also use the "move" parameter and specify new file names... putting the files on the same drive.
October 24, 2006 at 5:24 pm
There are two forms of "snapshot" and since you are posting in the "notification" section, vs. in the 7/2000 or 2005 DB sections (both of which have "replication" forums), it's...
October 24, 2006 at 5:20 pm
BTW, speaking of explain plans... I decided that I had better test production to see that I was getting the same result in the plan... and I am not. Here...
October 24, 2006 at 4:16 pm
I respect your advice; but doesn't the explain plan I posted say the opposite?
October 24, 2006 at 4:09 pm
Here are some of the results from explain plan before and after your recommended change. The change added five steps to the expain plan, and seems to have increased the...
October 24, 2006 at 3:45 pm
Well, it could be a permanent table; but the contents would have to float based on customer input... I will try. Not sure how this will be any better than the...
October 24, 2006 at 2:51 pm
They are built dynamically in the report writer application. The customer specifies what they want to see... and at the "store" level they are okay, performance wise, can only see...
October 24, 2006 at 2:48 pm
Okay, I had to clean it up a little bit so as not to "reveal" my customer... and I snipped out of the middle to make it shorter:
SELECT COALESCE(CAST(client_contacts.DateContacted As...October 24, 2006 at 2:28 pm
Sorry for the delay in responding. Hopefully you have an answer by now. I suspect that you need to properly configure your IIS 5.0 to get it to work -...
October 23, 2006 at 12:55 pm
one of the initial steps in setting up log shipping is to disable (i.e., remove) any existing backup(s). This is to include maintenance plans and/or 3rd party backup. I know...
October 23, 2006 at 12:39 pm
Graeme, Thanks for your response. I should have closed this thread out. The problem was apparently because I tried to generate the script before completing the replication process entirely (i.e.,...
October 23, 2006 at 12:28 pm
Viewing 15 posts - 121 through 135 (of 234 total)