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: Saturday, April 12, 2014 11:40 AM
Points: 2,795, Visits: 8,297
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: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
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: Saturday, April 12, 2014 11:40 AM
Points: 2,795, Visits: 8,297
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: Friday, January 03, 2014 3:52 PM
Points: 6,066, Visits: 5,277
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