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...

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. ...

curious, you are restarting RS... are you also restarting IIS?

you can also use the "move" parameter and specify new file names... putting the files on the same drive.

what are you using to import?

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...

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...

I respect your advice; but doesn't the explain plan I posted say the opposite?

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...

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...

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...

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:

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 -...

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...

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.,...