Attribute "target" exists, but can not be used for this element.

These days I am all about valid xhtml and was surprised to receive this validation error when using the target attribute on an anchor tag.

Attribute "target" exists, but can not be used for this element.

<a href="http://www.google.com/" target="_blank">Google</a>

view raw gistfile1.htm hosted with ❤ by GitHub

I found a nice work around that does not involve window.open, using jquery we can hack the attribute on 'after' the dom has loaded.

	<a href="http://www.google.com/" class="target-blank">Google</a>
	<script type="text/javascript">
	$j(document).ready(function() {
	$j('a.target-blank').click(function() {
	this.target = '_blank';
	});
	}
	</script>

view raw gistfile1.htm hosted with ❤ by GitHub

Now instead of target='_blank' you can just use class='target-blank', if the browser does not support javascript it will not open in a new window but the link will still work - and we have our valid xhtml.

Resources

• cre8asiteforums
• W3C Markup Validation Service
• JQuery

Procedure sp_droplogin, Line 93 Login is aliased or mapped to a user in one or more database(s)

Trying to remove a MSSQL login from a database server, recieve the following eror

Msg 15175, Level 16, State 1, Procedure sp_droplogin, Line 93
Login 'qa' is aliased or mapped to a user in one or more database(s). Drop the user or alias before dropping the login.

Solution: run this command to determine what alias or groups the login is associated with and then remove those; might be nice if they just added this to the error message?

sp_helpuser 'qa'