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.

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

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!

Passing an array or DataTable into a stored procedure

http://www.codeproject.com/KB/database/PassingArraysIntoSPs.aspx

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.

• Now it will show the files in detailed view, now click on the Edit Button as shown

• Now to download the RDL file click on the Edit button under Report Definition tab as shown. Your download window will now pop up.

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.

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

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);"

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.