In order to fix this bug you can simply run this command on the effected database after you have used the backup (sql2000) / restore sql2005/2008) or detach attach methods.
command to run:
Replace "dbusername" with the problem user account. both should be the same.
This will remove the ghost user from the sql 2000 server and replace it with the new user on your sql 2005 / 2008 server. Be sure to have the user created before running this command.
Errors associated with this are as follows:
"login name must be specified Database user"
"The database principal owns a schema in the database, and cannot be dropped"
"user group or role already exists in the current database"
"can't delete sql user in database"
Preventing comment spam on your blogging pages can be a hard task. However there is a way to prevent the spammers from benifiting by all the comment spam. You can simply include rel="nofollow" to all comment links.
Example: Visit my <a href="http://www.example.com/" rel="nofollow">some generic spam</a> site
ref: http://googleblog.blogspot.com/2005/01/preventing-comment-spam.html
To disconnect from a ghost or rogue network path do the following:
- (Open cmd.exe)
- net use /delete \\(computername)\(sharename)
To disconnect from a ghost or rogue network drive do the following:
- (open cmd.exe)
- net use (diveletter): /delete
The IE developer toolbar is a great little tool. However, it adds one annoying function to IE even when it is not open, the annoying little pop-up ruler box. You can easily disable this function by doing Ctrl+R while it is open and then close it with the x.
Here is the code, add this to your global.asax file: