Coding Tips

Today when I tried to add a project from sourcesafe into a solution I got an strange error message " The project you are trying to open is a Web Project. You need to open it by specifying its URL path ".

After searching net for while I got the solution at the below URL, http://www.aspnetresources.com/blog/sourcesafe_aggravation.aspx ,

well the solution was I added project.vbproj.webinfo file into the solution folder and it got loaded.
Actually this file, has the URL path for the project, that might be the reason why project was successfully added into the solution.

Finally able to blog today after a long break, well past seven weeks was too much to handle at the client's place in UK, well all went well and we are back at our office in Banglore.

Today, when I tried to create a query in sql 2000, got an error
"Cannot resolve collation conflict for equal to operation",

after searching net as usual came across this site which helped me in resolving the issue
http://www.ssw.com.au/SSW/KB/KB.aspx?KBID=Q211874,
thankyou David for the simple answer.

my query that gave problem was

create view SMD_EverestID ASSELECT SD.[Service Name], SD.[Module Name], SD.[Baseline or Optional], Service.ID AS ServiceID, Service_1.ID AS ModuleIDFROM ServiceModuleDependencies SD INNER JOIN Service ON SD.[Service Name] = Service.Name INNER JOIN Service Service_1 ON SD.[Module Name] = Service_1.Name

modfiied query is below:
create view SMD_EverestID ASSELECT SD.[Service Name], SD.[Module Name], SD.[Baseline or Optional], Service.ID AS ServiceID, Service_1.ID AS ModuleIDFROM ServiceModuleDependencies SD INNER JOIN Service ON SD.[Service Name] = Service.Name collate database_default INNER JOIN Service Service_1 ON SD.[Module Name] = Service_1.Name collate database_default