Tuesday, March 11, 2014

Table Modified/Updated Details


Scripts to find when Last transactions are done in a table:

SELECT
      last_user_update
FROM
      sys.dm_db_index_usage_stats
WHERE
      object_id=object_id('TableName')




Scripts to find when the table's Schema are changed last:

SELECT
      name as Table_Name,
      [modify_date]
FROM
      sys.tables

Monday, March 10, 2014

Cannot login to SSAS 2008 from SSMS?

Issue: 
When I tried to connect to a named instance of SQL Server 2008 Analysis Services (SSAS) by using SQL Server Management Studio, I received the following error message intermittently:

The 'InstanceName' instance was not found on the 'ServerName' server. (Microsoft.AnalysisServices.AdomdClient)

Solution:
 When I checked my services all the services was up & running, even I had restarted my SSAS services, but it didn't help me. but the issue was resolved after restart the SQL Server Browser service. 


If you aware, how to to restart any windows services that related SQL server then Ignore the steps below:

Steps to Restart "SQL Server Browser" service:
1.On the Start menu, right-click My Computer, and then click Manage.
2.In Computer Management, expand Services and Applications, and then click Services.
3.In the list of services, double-click SQL Server Browser.
4.In the SQL Server Browser Properties window, click Start or Stop.
5.When the service starts or stops, click OK.


After restarting the "SQL Server Browser" service, I tried to connect SSAS via SSMS, it works. Hope it may help you.

Tuesday, August 20, 2013

SQL Server 2014 CTP1

Microsoft has released SQL Server 2014 CTP1 Product Guide. This product guide release represents a significant milestone for customers and partners who want to experience the extensive new value delivered by SQL Server 2014 CTP1.

Download the datasheets, white papers and technical presentations from,
http://www.microsoft.com/en-us/download/details.aspx?id=39269

This will help you evaluate Microsoft SQL Server 2014 CTP1.

Friday, February 15, 2013

How To: Lists Linked Server

The following Stored procedure will returns the list of linked servers defined in the server in which we are executing it.

sp_linkedservers

This procedure will return the following informations about the linked server
Column name
Data type
Description
SRV_NAME
sysname
Name of the linked server.
SRV_PROVIDERNAME
nvarchar(128)
Friendly name of the OLE DB provider managing access to the specified linked server.
SRV_PRODUCT
nvarchar(128)
Product name of the linked server.
SRV_DATASOURCE
nvarchar(4000)
OLE DB data source property corresponding to the specified linked server.
SRV_PROVIDERSTRING
nvarchar(4000)
OLE DB provider string property corresponding to the linked server.
SRV_LOCATION
nvarchar(4000)
OLE DB location property corresponding to the specified linked server.
SRV_CAT
sysname
OLE DB catalog property corresponding to the specified linked server.

Or... you can use following SQL Scripts to lists all linked servers


select * from master..sysservers
Hope this helps!