NEWS

Tuesday, January 31, 2012

Windows 7 (recovered) boot problem

When you have installed another OS after the Windows 7, then you might get problem in booting the Windows 7. To fix this issue, you need to boot to the Windows 7 CD.
Then, type the command:
:\boot\bootsect.exe /nt60 all

This will repair the boot menu and will fix Windows 7 startup issues.


Monday, January 30, 2012

C: Access is denied from Windows 7 in dual boot

To solve this,
1. Right-click on C:
2. Select Properties->Security->Authenticated Users
3. Click Edit and Add "Everyone" and give full control and "OK"



Query to concatenate column values without loop


DECLARE @Vals varchar(500)
SET @Vals=''
SELECT @Vals= ISNULL(@Vals,'') + CAST(Col1 AS VARCHAR(3)) + ',' from tblData
SELECT @Vals

Thursday, January 26, 2012

BOOTMGR is compressed press ctrl+alt+del to restart

When you dual boot your system with Windows 7 and XP(or Vista) you might get the error"BOOTMGR is compress".

Please note that the following steps require you to have your computer to be able to boot the CD-Drive first. For more information please visit HERE.
Steps:
1.Insert the Windows 7 OS disc into your CD-drive and restart the computer.
2.Wait for the setup window to appear
3.Press Shift+F10 simultaneously to bring up Command Prompt
4.Type in

bootrec/fixboot

then press enter

5.Last but not least type in

bootrec/fixmbr
then press enter

There you have it, all fixed!

Monday, January 9, 2012

To copy/migrate reports from one server to another

1. Download rdls from SSRS to local PC
2. Upload files to a SSRS server
3. Attach datasources automatically on upload(Data source name given in the report must exist on server)



  • Browse to the RDL file folder or location
  • In this case Im going to download databaselist RDL file as shown below. Click on Show Details link in the page located on top right corner.

  • rdl_export_1
    • Now it will show the files in detailed view, now click on the Edit Button as shown
    rdl_export_2
    • Now to download the RDL file click on the Edit button under Report Definition tab as shown. Your download window will now pop up.
    rdl_export_3

    SQL Server 2008 R2

    In SQL Server 2008 R2 Microsoft has made this pretty straight forward.
    • Connect to Report Manager URL (ex: http://localhost/Reports_RS/Pages/Folder.aspx)
    • Browse to the RDL file folder or location
    • Click on the drop down menu near the RDL file. In this case Im going to download dblist file
    • Now just click on download button as shown, your download window will pop up now.
    rdl_export_4

    references: http://code.google.com/p/reportsync/
    http://sql-articles.com/articles/general/download-export-rdl-files-from-report-server/

    Wednesday, January 4, 2012

    To make a CheckBoxList behave like a RadioButtonList using Javascript


    function RadioList(event)
                    {              
                        if(event.srcElement.type=='checkbox')
                        {
                            var childNodes;
                            var tableLayout;
                            var childNode;

                            if(event.srcElement.parentNode.parentNode.parentNode.parentNode.name != undefined)
                            tableLayout = true;
                            childNodes = event.srcElement.parentNode.parentNode.parentNode.childNodes;

                            for(i=0;i
                            {

                                childNode = childNodes[i].childNodes[0].childNodes[0];

                                if(childNode != undefined)
                                {
                                    if(childNode.type == 'checkbox')
                                    {
                                        childNode.checked=false;
                                    }
                                }
                            }
                            event.srcElement.checked=true;
                        }
                    }

    Add the js function to Checkboxlist control

    asp:CheckBoxList ID="chkTabs" runat="server" OnClick="javascript:RadioList(event);"

    Tuesday, January 3, 2012

    SSO in IIS6 (virtual directory path located on remote system)


    To Host Website(Virtual Directory) using a "A share located on another Completer"
    in II6. You need to use valid credentials in the "Connect As" window.

    If you are implementing Single Sign-On, You need to keep the default checkbox in the "Connect As" without giving
    any credentials and use "Integrated Windows Authentication" in "Directory Security" for the website.
    Keep the "Anonymous Access" checked, change the anonymous user credentials to valid admin credentials having access
    to remote system. Then Remove "Intergrated Windows Authentication" to folders like images, javascript which need
    direct access.