Linked server

Guys,
I have established a linked server connection from sybase to MS SQL Server. I can run SQL from MSSQL Server and bring data across. The data sync runs as a cron job but the connections to sybase is never released after the job completes. Due to this, I run out of connections on my Sybase server. Has anyone encountered this problem? Please help......

Regards

Subhasa cron?

What does it execute?|||Are the sql statements you're executing against Sybase using the OpenQuery() method?|||No. The queries does not use an OpenQuery method. Instead, I have added a linked server and then created a stored procedure in MS SQL which accesses the data from sybase. For example -- I have used a SQL in the SP saying select customer_id from server_name.db_name.dbo.table_name. It works fine and gets the data from sybase on to MS SQL Server but does not release the user connection on the sybase side. This Stored procedure runs as a scheduled job (Cron) in MS SQL Server.

Regards

subhas