Error Microsoft Expression Belnd 4 service pack1 cannot be instaled because the program to be upgraded either is missing or is the wrong version. please verify that you have the correct version of the program installed on your computer .

Download
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=5915
Then
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=24036

Error Firefox has detected that the server is redirecting the request for this address in a way that will never complete.

The page isn't redirecting properly
Firefox has detected that the server is redirecting the request for this address in a way that will never complete.
This problem can sometimes be caused by disabling or refusing to accept cookies.


In IIS right click on the web site then go to properties.
Click Home Directory tab and change from A redirection to a URL to A directory located on this computer.

MSSQL ERROR: SQL Server Alert System: 'Demo: Sev. 24 Errors' occurred on \\DatabaseName

ALTER DATABASE DatabaseName
SET single_user WITH ROLLBACK IMMEDIATE;
go
DBCC checkdb ('DatabaseName', repair_allow_data_loss);
go


DBCC CHECKDB

ALTER DATABASE DatabaseName
SET MULTI_USER
GO

MSSQL ERROR - Arithmetic overflow error converting numeric to data type numeric

ERROR - Arithmetic overflow error converting numeric to data type numeric
 
CONVERT (decimal(5 , 2), 1) / CONVERT (decimal(5 , 2), myField)
the error typically occurs when you are trying to pass a numeric value that is too large...
CONVERT (decimal(10 , 2), 1) / CONVERT (decimal(10 , 2), myField) ==Fixed

MS Access Overflow error

- conver number to double or currency CDbl(number) CCur(number) CLng(number)
- make sure there is no division by zero

MS Access Error The field is too small to accept the amount of data you attempted to add - check nulls (nz)

The field is too small to accept the amount of data you attempted to add - check nulls (nz)

Operation must use an updateable query
If updating from a query. 
Create make table query, then update from that table.

MSSQL ERROR 9002 LOG FILE IS FULL

MSSQL 2008

use master

DBCC SQLPERF( LOGSPACE )  - this will show list of databases and log file size

use DatabaseThatHasLogFull
DBCC SHRINKFILE(DatabaseThatHasLogFull_log, 1)
BACKUP LOG DatabaseThatHasLogFull TO DISK = 'C:\AnyFileName.bak'
DBCC SHRINKFILE(DatabaseThatHasLogFull_log, 1)


MSSQL 2000

use master

DBCC SQLPERF( LOGSPACE ) 

DBCC SHRINKFILE(pubs_log, 2)
BACKUP LOG pubs WITH TRUNCATE_ONLY
DBCC SHRINKFILE(pubs_log,2)

Error Unable to Start Debugging on the Web Server

In my case it is because I had to reinstall IIS
To fix open command prompt and run the following:
%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i

Error ID 5000 EventType clr20r3, P1 devenv.exe, P2 9.0.21022.8, P3 47317b3d, P4 NIL, P5 NIL, P6 NIL, P7 NIL, P8 NIL, P9 NIL, P10 NIL.

Copy msmdlocal.dll and msmgdsrv.dll
from C:\Program Files\Common Files\System\Ole DB
to C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies

Visual Studio Error System.Runtime.InteropServices.COMExeption

System.Runtime.InteropServices.COMExeption

This error indicates there is something wrong wrong with IIS.  Restart, login as admin, in worst scenario - reinstall.

In my case it had something to do with permissions, I couldn't start IIS service (error Could not start IIS Admin service on Local Computer.  Error 13: The data is invalid. ) Reinstalled IIS.

Microsoft Visual Web Developer 2010 Express - Missing WPF template

Download and install  Visual C# 2010 Express  or Visual Basic 2010 Express

Then it will ask you to install and update Microsoft Visual Studio 2010 Service Pack 1

Error 280 Unable to copy file "..\..\AjaxControlToolkit.Binary.NET35\fr\AjaxControlToolkit.resources.dll"

Error 280 Unable to copy file "..\..\AjaxControlToolkit.Binary.NET35\fr\AjaxControlToolkit.resources.dll" to "bin\fr\AjaxControlToolkit.resources.dll". Access to the path 'bin\fr\AjaxControlToolkit.resources.dll' is denied. ProjectName


Delete all ajax related (or all) files/folders in bin folder.
Rebuild project.
New files/folders with corrected permissions will be created.

MSSQL - TCP PORT

1433 - Default SQL port
Client ports get a random value between 1024 and 5000
Details: http://support.microsoft.com/kb/287932

MSSQL - Round Down

Round the following number 67.485000 to 67.480000
select ROUND(67.485000,2,1)

MSSQL - Clear Cashe

DBCC FREESESSIONCACHE
DBCC FREEPROCCACHE
DBCC FREESYSTEMCACHE ('ALL') WITH MARK_IN_USE_FOR_REMOVAL;

Populating DropDownList in a ListView InsertItemTemplate

Will not work
I'm using the following function to load dropdownlist on Edit ( <ItemTemplate>)

        protected void lvBackupLog_ItemDataBound(object sender, ListViewItemEventArgs e)
        {
            ListViewDataItem dataItem = (ListViewDataItem)e.Item;
            System.Data.DataRowView dv = (DataRowView)dataItem.DataItem;
            DropDownList ddlServer = (DropDownList)e.Item.FindControl("backup_server_nameDDL");
            DropDownList ddlTape = (DropDownList)e.Item.FindControl("backup_tape_nameDDL");
            if (ddlServer != null)
            {
                DataSet dsServerList = new DataSet();
                DataLib.BackOffice_Open();
                BackOffice.aGetServerList(ref DataLib, ref dsServerList);
                DataLib.BackOffice_Close();
                ddlServer.DataSource = dsServerList;
                ddlServer.DataTextField = "backup_server_name";
                ddlServer.DataValueField = "backup_server_id";
                ddlServer.SelectedValue = dv.Row["backup_server_id"].ToString();
                ddlServer.DataBind();
            }
        }

It will populate DropDownList and will select correct items

To make it work for InsertItemTemplaet use the following
        protected void lvBackupLog_ItemCreated(object sender, ListViewItemEventArgs e)
        {
            DropDownList ddlServer = (DropDownList)e.Item.FindControl("backup_server_nameDDL");
            DropDownList ddlTape = (DropDownList)e.Item.FindControl("backup_tape_nameDDL");
            if (ddlServer != null)
            {
                DataSet dsServerList = new DataSet();
                DataLib.BackOffice_Open();
                BackOffice.aGetServerList(ref DataLib, ref dsServerList);
                DataLib.BackOffice_Close();
                ddlServer.DataSource = dsServerList;
                ddlServer.DataTextField = "backup_server_name";
                ddlServer.DataValueField = "backup_server_id";
                ddlServer.DataBind();
            }
        }
There is no need (and no way) to select item from database as this is new item.  You can of course default it to something

ASP.NET - AJAX and jQuery on the same screen

Don't use  $(document).ready(function()  as it will not work with Ajax.
Use pageLoad() instead

        function pageLoad(){
            $('#gvReport tr[class="ItemStyle"],#gvReport tr[class="AlternatingItemStyle"]')
            .bind('mouseover', function() { $(this).css('background-color', '#6E6E6E') })
            .bind('mouseout', function() { $(this).css('background-color', '') });
        }

Dynamics - GP - Error deleting batch - PM_Transaction_Open has created a duplicate key

1. Ensure no one is connected to GP

2. In Company Database select * from ..activity - no one should be connected.

3. Select * From tempdb ..DEX_SESSION - you should see record with transaction that cannot be deleted

4. Delete From tempdb ..DEX_SESSION

5. select * from ..SY00500 - you will see all uncompleted transactions, find bachnumb of the one that cannot be deleted.

6. View it (for testing purposes)

select MKDTOPST, BCHSTTUS from ..SY00500 where BACHNUMB = 'DH-110711-6'

7. Now you can delete it

update SY00500 set MKDTOPST = 0, BCHSTTUS = 0  where BACHNUMB = 'DH-110711-6'