Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked Server - Missing Feature "Provider Options" Expand / Collapse
Author
Message
Posted Tuesday, June 25, 2013 10:01 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:05 PM
Points: 2,834, Visits: 8,544
I see references to changing setting on the "Provider Options" page, but on my 2005 and 2008 servers, I don;t see that option. I have "General", "Security" and "Server Options". Where are these "Provider Options" they speak of ?
What am I missing ? I have 2005 SP4, and 2008 R0



Post #1467260
Posted Tuesday, June 25, 2013 10:36 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
Under linked servers | Providers
Chose a provider, right click on properties, boom provider options.

Also if I read that right R0 isn't a released version, at this point use only released versions. Unless you meant R2 then never mind..

CEWII
Post #1467282
Posted Tuesday, June 25, 2013 11:38 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:05 PM
Points: 2,834, Visits: 8,544
Thanks. The way the documentation is written suggested each linked server had it's own "Provider Options" page


Post #1467303
Posted Tuesday, June 25, 2013 11:53 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, October 9, 2014 1:02 PM
Points: 6,032, Visits: 5,284
homebrew01 (6/25/2013)
Thanks. The way the documentation is written suggested each linked server had it's own "Provider Options" page

In previous versions like SQL 2000 they did.

CEWII
Post #1467309
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse