MS SQL server: How to troubleshoot orphan users in SQL Server databases?

The most common symptoms are:

• Applications will experience 'login failed' error messages and fail to log into this database.
• Users won't show up in Enterprise Manager, but when you try to add users, you will get error messages saying 'User or role already exists in the current database'

To overcome this problem, you need to link the SIDs of users (from sysusers) to the SIDs of valid logins in the master..sysxlogins table.

use my_db_name
go
exec sp_change_users_login 'Auto_Fix', 'User_name'

Problem arises when you move (using backup/restore or detach/attach) a database to a new server. Since sysusers table is stored within the database, it gets moved over to the new server as well. Now the new server might or might not have the same logins, and the SIDs of these logins could be completely different from the SIDs of these logins in the original server. What this means is that, the sysusers table in the newly moved database has SIDs that aren't anymore there in the sysxlogins table on this new server. So, SQL Server can not map the users in this database to any of the logins. That's what results in orphaned users.

Eric Enge Interviews Google's Matt Cutts

Eric Enge: Let's talk about different kinds of link encoding that people do, such as links that go through JavaScript or some sort of redirect to link to someone, yet the link actually does represent an endorsement. Can you say anything about the scenarios in which the link is actually still recognized as a link?

Matt Cutts: A direct link is always the simplest, so if you can manage to do a direct link that's always very helpful. There was an interesting proposal recently by somebody who works on FireFox or for Mozilla I think, which was the idea of a ping attribute, where the link can still be direct, but the ping could be used for tracking purposes. So, something like that could certainly be promising, because it lets you keep the direct nature of a link while still sending a signal to someone. In general, Google does a relatively good job of following the 301s, and 302s, and even Meta Refreshes and JavaScript. Typically what we don't do would be to follow a chain of redirects that goes through a robots.txt that is itself forbidden.

Full text

Goo.glicio.us - No more PageRank updates, Hello PageRate!

“As far as the toolbar PageRank, I definitely wouldn’t expect to see it in the next few days. Probably not even in the next couple weeks, if I had to guess.” (Sep. 07, 2007). As you could see SERPs bouncing around you could figure Google is probably working on their new and improved algorithm that will cut the SERPs affected by paid links and sort websites that bought PR from those that actually earned it.

http://jplay.info/googlicious-no-more-pagerank-updates-hello-pagerate/

Corel Draw / Photo Paint Palette Generator

You can create a custom palette for Corel Draw and Photo Paint online and save it to your disk.
Corel Draw / Photo Paint Palette Generator

VBScript: Capitalize String Function

Function fncCapitalize(ByVal str)
 Dim intI, arrTmp
 arrTmp = Split(str, " ")
 str = ""
 For intI = 0 To Ubound(arrTmp)
  str = str & UCase(Left(arrTmp(intI), 1)) & Right(arrTmp(intI), Len(arrTmp(intI)) - 1) & " "
 Next
 fncCapitalize = Trim(str)
End Function