MSDTC is an acronym for Microsoft Distributed Transaction Coordinator. It is a separate Windows service which coordinates distributed transactions across SQL Server instances and only needed for transactions etc.

Added the Administrators Group to the file security permissions with full control for the Data file (S:) and the Log File (T:).

Attached the database

You can also do this

SELECT Dividend / ISNULL(NULLIF(Divisor,0),1) AS Result

Try this syntax to drop full text catalog

DROP FULLTEXT CATALOG catalog_name

The most common reason for uncontrolled log growth is being in Full Recovery mode without having any log backups.

Nice explanation, thanks for sharing this informative article with us

Script to disable index:

ALTER Index indexname ON tablename.columnname DISABLE;

Script to enable index:

ALTER Index indexname ON tablename.columnname REBUILD;

check out this link: - https://social.technet.microsoft.com/Forums/windows/en-US/a69b325e-c809-48c6-bf88-b90132fe0dfb/dbf-file-corrupted?forum=itprovistaapps

I have found one article on the same error, maybe this will help you out, see form here: http://www.sqlserverlogexplorer.com/fix-error-message-40/[/url]

Enable TCP/Ip, Piped Protocol

From Computer Management ->SQL and Services, ensure the Service is On. Enable the port on the Firewall. Try to login through Command Prompt -> as Admin;...

then start it

If Aliases are totally blank, then check SQL Server Browser service is running and is kept in automatic Start mode.

From start -> click on run- > type services.msc -> click...

Go to Control Panel -> Administrative Tools -> Computer Management

Expand Services And Application-> SQL...

USE AdventureWorks;

GO

SET ANSI_WARNINGS OFF;

SET NOCOUNT ON;

GO

WITH agg AS

(

SELECT

last_user_seek,

last_user_scan,

...

use [master]

go

create proc dbo.sp_Drop_OrphanedUsers

as

begin

set nocount on

-- get orphaned users

declare

@user varchar(max)

declare c_orphaned_user cursor for

select name

from sys.database_principals

...