Hi Kathy, We get the same error if we try to browse tables/views. I've just been living with it. Haven't tried conditional queries - my jobs are only data synchronization tasks.
Cheers! Rick --- "Vance, Kathy" <[EMAIL PROTECTED]> wrote: > I did the same thing in SQL 2000. I created a linked > server in SQL 2000 > with IBM ODBC driver. I could run the query with > Openquery. But I could > not see the tables and views in SQL enterprise > manager. When I clicked > on the tables, I got error saying something like: > "Error0: SqlDumpExceptionHandler: Process 51 > generated fatal exception > C0000005 Exception_Access_Voliation SQL server is > terminating this > process." > > Based on online discussion, the error was related to > the Memory setting > but I have not figured out how to fix it. Any idea > or suggestions? > > Also, I could not add "where" statement in the > openquery query. As I > know, we can do so in SQL 2005. > > Thanks, > > Kathy > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/