SQL SERVER - Database Suspected in SQL Server 2008

Connected to your database and check if it is in emergency mode, else run this comand:
ALTER DATABASE DB_NAME SET EMERGENCY
set single user in the database property and run this command:
DBCC CHECKDB ('DB_NAME',REPAIR_ALLOW_DATA_LOSS)

Nicola Grillo

CRM 4.0 - Assign entity using Javascript CRM 4.0

function assign(userid,recordid){

  var header = GenerateAuthenticationHeader();

  var target = "TargetOwned<Entityname>";
  var xml = "" +
  "<?xml version=\"1.0\" encoding=\"utf-8\"?>" +
  "<soap:Envelope xmlns:soap=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">" +
  header +
  "  <soap:Body>" +
  "    <Execute xmlns=\"http://schemas.microsoft.com/crm/2007/WebServices\">" +
  "      <Request xsi:type=\"AssignRequest\">" +
  "        <Target xsi:type=\""+ target +"\">" +
  "          <EntityId>"+ recordid +"</EntityId>" +
  "        </Target>" +
  "        <Assignee>" +
  "          <PrincipalId xmlns=\"http://schemas.microsoft.com/crm/2006/CoreTypes\">"+ userid +"</PrincipalId>" +
  "          <Type xmlns=\"http://schemas.microsoft.com/crm/2006/CoreTypes\">User</Type>" +
  "        </Assignee>" +
  "      </Request>" +
  "    </Execute>" +
  "  </soap:Body>" +
  "</soap:Envelope>" +
  "";
  var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
  xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
  xmlHttpRequest.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/Execute");
  xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
  xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
  xmlHttpRequest.send(xml);

  var resultXml = xmlHttpRequest.responseXML;

 }


Nicola Grillo

SQL SERVER - Remove duplicate rows from a table in SQL Server

This query remove just the duplicate rows, if you have the tripled or quadrupled run more one it.

delete Table1

from
(select c1 as t

from Table1 p
having COUNT(*)>1) as t

where c1=Max(t.max)