Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Linked Server -- Number of connections
0 views
Skip to first unread message
Raziq Shekha
Dec 9, 2009, 5:21:26 AM12/9/09
to
From SQL 2000 linked to a Oracle 10g database. Is there a setting on
the SQL Server side that will limit the number of connections to the
linked Oracle database?
the SQL Server side that will limit the number of connections to the
linked Oracle database?
*** Sent via Developersdex http://www.developersdex.com ***
Erland Sommarskog
Dec 9, 2009, 6:37:12 AM12/9/09
to
Raziq Shekha (raziq....@anadarko.com) writes:
> From SQL 2000 linked to a Oracle 10g database. Is there a setting on
> the SQL Server side that will limit the number of connections to the
> linked Oracle database?
As I recall, no.> From SQL 2000 linked to a Oracle 10g database. Is there a setting on
> the SQL Server side that will limit the number of connections to the
> linked Oracle database?
If you want to make sure, look in Books Online at the system procedure
sp_serveroption.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
0 new messages