Today I had some problems with a report solution created in Visual Studio 2005:
After I got the latest version out of SourceSafe, I could not open it anymore. The error message was "Project item '4294967294' does not represent a file."
Searching for this error on the internet I came to this solution:

- Open the .rptproj file in notepad (or another text editor) and delete the line that begins with "<State>$base64$"

       Sometime in notepad you may not view complete data, so try to open in CMD -> Edit window.
- Open the solution
- Delete the source control bindings
- Add it to source control again
- Done!

Yesterday I got this error message while running Asp.net application in Visual studio 2005

---------------------------
ASP.NET Development Server
---------------------------
ASP.NET Development Server failed to start listening on port 1085.
Error message:
An attempt was made to access a socket in a way forbidden by its access permissions
---------------------------
OK  
---------------------------

By default the web application uses ASP.NET development server not the IIS. We
can change it to IIS by selecting Project Properties->Web Tab. There we can
create the virtual directory too.
The error must be specifying some port. I try to use some tools like TcpView from
Sysinternals (http://www.sysinternals.com/Utilities/TcpView.html) to check that
port is used by some other process. Normally development server will take the
free port while running the application.

Following query will display stored procedure content through Query.

    SELECT ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_NAME='SPLocationGetByID' AND ROUTINE_TYPE='PROCEDURE';

Good to read basic of SQL Join at

http://en.wikipedia.org/wiki/Join_(SQL)#Inner_join

Following vbscript snippet call web service with parameter.

Dim oXMLDoc, oXMLHTTP
Sub btnclick
Set oXMLHTTP = CreateObject("MSXML2.XMLHTTP.4.0")
Set oXMLDoc = CreateObject("MSXML2.DOMDocument")
Msgbox("Calling WebService To Approve Leave")
oXMLHTTP.onreadystatechange = getRef("HandleStateChange")

Dim strEnvelope

strEnvelope = "userId=1"
call oXMLHTTP.open("POST","http://localhost/MerchantServerWS/MCService.asmx/GetName",true)
call oXMLHTTP.setRequestHeader("Content-Type","application/x-www-form-urlencoded")
'call oXMLHTTP.setRequestHeader("SOAPAction","http://localhost/MerchantServerWS/MCService.asmx?wsdl")

call oXMLHTTP.send(strEnvelope)
End Sub
Sub HandleStateChange
if(oXMLHTTP.readyState = 4) then
dim szResponse: szResponse = oXMLHTTP.responseText
call oXMLDoc.loadXML(szResponse)
if(oXMLDoc.parseError.errorCode <> 0) then
call msgbox("ERROR")
call msgbox(oXMLHTTP.responseText)
call msgbox(oXMLDoc.parseError.reason)
else
call msgbox( oXMLDoc.getElementsByTagName("string")(0).childNodes(0).text)
end if
end if
End Sub