When creating a stored procedure and it contains a SELECT statement, you may get the following error message even if the collation of your database seems to be correct.
Cannot resolve collation conflict for column n in SELECT statement.
where n is the column number.
This can be easily fixed by appending the following portion of SQL to the column n in your SELECT statement:
COLLATE <your database collation name>
For example, COLLATE SQL_Latin1_General_CP1_CI_AS.
When trying to change the collation of a database, you may get the following error message:
The database could not be exclusively locked to perform the operation.
To workaround this problem, we first need to set the database for single user. And change it back for multi user after changing the collation.
ALTER DATABASE <database_name> SET SINGLE_USER WITH ROLLBACK IMMEDIATE
ALTER DATABASE <database_name> COLLATE <target_collation_name e.g. SQL_Latin1_General_CP1_CI_AS>
ALTER DATABASE <database_name> SET MULTI_USER
When your ASP.NET application tries to access a file in a folder, you may get an error message saying "Access to the path <file path> is denied.". To solve this problem, you will need to provide permissions for NETWORK SERVICE (Windows 2003/2008) or ASPNET (Windows XP) account to access the folder containing that file. To provide the permissions, do the following:
Now your ASP.NET should have an access to the folder.
What if the Security tab doesn’t show up?
You’ll need to uncheck the Simple File Sharing option in folder options.
Now the security tab should appear and you can start configuring the permissions as stated above.
The first extension I would like to recommend is RSS Ticker. As you may have already known, Firefox can act as an RSS feed reader and you can just bookmark a feed as if it were a Web page. RSS Ticker displays and scrolls a list of those feeds right under your menu bar. Go ahead and give it a try.
That’s it. When there is a new post, you’ll get notified right on your Firefox 
Another extension that I’ve found to be very very useful is Google Bookmark IncSearch. As you browse across the Web and find some useful pages that you want to keep, one way is to bookmark it on Google Bookmark so that you can access your bookmarks from anywhere. However, sooner or later, you will find yourself store TOO MANY bookmarks and just you don’t seem to find what you want within your own bookmarks – even though you’ve well organized them. And you probably end up with googling for what you want again -*- Well, it would be nice if you can just search within your bookmarks if you know it IS there, wouldn’t it? Google Bookmark IncSearch can help. OK. That’s enough for saying. Give it a try and I’m sure you’ll love it just as I do 
By default, Microsoft SQL Server 2008 doesn’t allow any remote connection. What we’ll need to do is to enable TCP/IP protocol in SQL Server Configuration Manager > SQL Server Network Configuration > Protocols for <InstanceName> and enable the TCP/IP protocol as shown in the picture below. An example of InstanceName is MSSQLSERVER.
After restarting SQL Server (InstanceName) service (as shown below), it should work without any problem. You can quickly access the services windows by going to start menu > run > type services.msc. Locate the SQL Server (InstanceName) service, right click on it, and choose restart.
In my case, completing these steps enables me to connect from a remote machine successfully. However, someone reported that we also need SQL Server Browser service running too. Therefore, if completing the steps above doesn’t help you get connected, you may try setting SQL Server Browser service to Automatic and start the service.
When you create a new .NET Web application under a default Web site in IIS 7 (so the URL of your new Web application will be http://localhost/mywebsite, for example), you may encounter an error saying "Failed to map the path…".
To get rid of this error, make sure that the application pool of your new .NET Web application and the application pool of the default Web site are the same. The following pictures show the cause of the error:
Change the application pool of the latter one to be the same of the first one solves the problem 
When you try to add a DataRow from one table to another, you may encounter the following error message:
"This row already belongs to another table."
This error message appears if you try to add (copy) a DataRow from table1 to table2, for example, with the following C# code:
where row is a DataRow object from table1.
To successfully copy the row, you’ll need to use ImportRow() method:
Don’t forget to define a proper value of column number for table2 first or no data will be displayed if you bind table2 with a gridview, for example.
In WSS 3.0, there are three (3) out-of -box security groups.
You can create your own SharePoint groups.
<< Back to [70-631] TS: Configuring Microsoft Windows SharePoint Services (WSS) 3.0 – Exam Notes
When you’re working with Visual Studio and trying to run a web application project, you may encounter a problem of the URL change from http://localhost to http://www.localhost.com
This is caused by the IPv6 issue. Look in your hosts file (usually located under C:WindowsSystem32driversetc). Look for the line:
::1 localhost
Comment it out with a # sign and it’ll become:
#::1 localhost
That’s it. You’re now up and running
