hey guys at least give some hint from where i can start troubleshooting

thanks but we have already applied the said settings but no use

thanks but we have already applied the said settings but no use

Thanks buddy,

I have already installed both 'SQL ANYWHERE OLEDB Driver' and 'SYBASE ASE ODBC Driver' as we have 64bit environment for SQL Server 2008. So i am able to see...

There is no such option available in DSN for SYABASE ASE ODBC driver 4.20.00.15

I am also facing the same problem while querying through linked server of SYBASE ASE OLEDB PROVIDER. I have just use simple join query.

i mean to say host machine where sql client is installed ..which entry i can found in sysprocesses. i want to restrict such clients. So that if anyhow they manage...

->Check iI there any daily EOD process running which creates the n no. of temp tables and inserting a data into your prod.

->have you recently rebuild your all indexes?