SQL SERVER – Error: Failed to retrieve data for this request. Microsoft.SqlServer.Management.Sdk.Sfc – ‘DATABASEPROPERTY’ is not a recognized built-in function name. (Microsoft SQL Server, Error: 195)

I have four different machine at home.

  1. Office Laptop – Provided by work organization
  2. Personal Laptop – My wife uses it
  3. Demo Machine – A very old machine – I think I can only do demo of my messenger only – it is 32 bit – single CPU 1 GB RAM

I work with SQL Server 2008 (R2) and SQL Server ‘Denali’ and often connect to both the instances. Recently while I was connecting to Denali I encountered following error.

Failed to retrieve data for this request. Microsoft.SqlServer.Management.Sdk.Sfc)
‘DATABASEPROPERTY’ is not a recognized built-in function name. (Microsoft SQL Server, Error: 195)

I was bit confused with the error and suddenly realized that I was attempting to connect to SQL Server ‘Denali’ instance from SQL Server 2008 R2 SSMS.

However, if you try to connect to SQL Server 2008 R2 from SQL Server ‘Denali’ SSMS it will work absolutely fine.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

9 thoughts on “SQL SERVER – Error: Failed to retrieve data for this request. Microsoft.SqlServer.Management.Sdk.Sfc – ‘DATABASEPROPERTY’ is not a recognized built-in function name. (Microsoft SQL Server, Error: 195)

  1. You need to update your skill my friend. Were you able to connect ssms 2008 from ssms 2005 or any higher version form lower version.
    Once you will keep this in mind you will never ask such lovely question.

    Like

      • I am Pallavi Working in Kziero tech. Service Pvt Ltd. as a SQL DBA

        m looking for the trigger which track the Database user activity.

        had gone from following steps ,

        Table created :
        Like
        CREATE TABLE dbLOG(e_time VARCHAR(50),e_servername VARCHAR(25),e_username VARCHAR(15),e_commandtext VARCHAR(max))

        then This trigger is not working… :(
        I tried a lot..

        SET ANSI_NULLS ON
        GO
        SET QUOTED_IDENTIFIER ON
        GO

        CREATE TRIGGER [db_LOG]

        ON database [dummy]
        after create table,drop table,slter table
        AS

        SET NOCOUNT ON

        DECLARE @xEvent XML

        SET @xEvent = eventdata()
        INSERT INTO dbLOG VALUES(

        REPLACE(CONVERT(VARCHAR(50), @xEvent.query(‘data(/EVENT_INSTANCE/PostTime)’)),’T’, ”),

        CONVERT(VARCHAR(25), @xEvent.query(‘data(/EVENT_INSTANCE/ServerName)’)),

        CONVERT(VARCHAR(15), @xEvent.query(‘data(/EVENT_INSTANCE/UserName)’)),

        CONVERT(VARCHAR(MAX), @xEvent.query(‘data(/EVENT_INSTANCE/TSQLCommand/CommandText)’))

        )

        GO

        Like

    • May be I am one of the few lucky ones… I was able to connect to SQL 2005 using Query Analyzer. Also, successfully connected to SQL 2008 R2 using SSMS 2005…

      Like

  2. hey Pinal,

    Though this was an accident,you are in a good shape to provide information to Product Support team that ‘The error’ messages which SQL throws out might route you to a wrong direction all together.

    -Anup

    Like

  3. Pingback: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo) – SQL Server ‘Denali’ - Vishal Gajjar's Blog

  4. please help me, I have tried all these thing still i am facing these 3 error while connecting to sql server 2008 r2,

    1.Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

    2.Failed to connect to server . (Microsoft.SqlServer.ConnectionInfo)

    3.A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 – An existing connection was forcibly closed by the remote host.) (.Net SqlClient Data Provider)

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s