Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

LINK Server/Provider Expand / Collapse
Posted Tuesday, February 17, 2009 7:50 AM


Group: General Forum Members
Last Login: Thursday, May 14, 2009 7:33 AM
Points: 112, Visits: 61
Good dya,

I am using SQL server 2005. When I tried link a server, I click the server objects and then linked servers. Then when click the Provider in other to select the provider type I received the following error message after about 5 minutes:

TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
Cannot insert the value NULL into column 'Description', table 'tempdb.dbo.#OLEDBProv__________________________________________________________________________00000000001D'; column does not allow nulls. INSERT fails.
The statement has been terminated. (Microsoft SQL Server, Error: 515)
For help, click:

Can some help with this issue?

Post #658526
Posted Tuesday, February 17, 2009 9:05 PM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, November 22, 2016 3:38 PM
Points: 283, Visits: 2,228
see if this is related at all:

MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Post #659034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse