updated: Thursday, 09 February 2017, 08:41:14


Document is not valid

12 errors and 0 warnings in 12 lines
size: 23870 bytes, 461 lines
doctype: -//W3C//DTD XHTML 1.0 Transitional//EN
encoding: utf-8
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html dir="ltr" xmlns="http://www.w3.org/1999/xhtml">

<head id="ctl00_ctl00_Head1"><base href="http://www.sqlteam.com/default.aspx" /><link rel="stylesheet" href="http://static2.sqlteamx.com/csharp.css" type="text/css" /><link rel="stylesheet" href="http://static2.sqlteamx.com/sqlteam2.css" type="text/css" /><meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><link rel="SHORTCUT ICON" href="http://static2.sqlteamx.com/images/favicon.ico" /><link rel="apple-touch-icon" href="http://static2.sqlteamx.com/images/sqlteam-touch-icon.png" /><link rel="alternate" type="application/rss+xml" title="SQLTeam.com -- SQL Server Information" href="http://feeds.sqlteam.com/sqlteam" /><title>
	SQL Server Information at SQLTeam.com
</title>
<meta name="verify-v1" content="7i8SPJZFQb3hJ6+PgkEIIZ52tig8nuSuDW5/nhISIt4=" /><meta name="robots" content="noarchive" /><meta property="fb:page_id" content="181788198509369" />
there is no attribute "property"
Line: 9, Col: 138
… content="noarchive" /><meta property="fb:page_id" content="181788198509369" /…
<script type="text/javascript">

    var _gaq = _gaq || [];
    _gaq.push(['_setAccount', 'UA-222470-2']);
    _gaq.push(['_trackPageview']);
    _gaq.push(['_trackPageLoadTime']);

    (function() {
        var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
        ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
        (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(ga);
    })();

</script>
<meta name="DESCRIPTION" content="Microsoft SQL Server articles, forums and blogs for database administrators (DBA) and developers." /></head>

<body>
<!-- ================================  Site Header ========================================= -->
<div id="site_header">


<!-- Logo and banner -->
<table>
	<tr style="height: 100px;">
		<td class="site_header_cell">
		    <a id="ctl00_ctl00_TopHomePage" href="./">
		        <img src="http://static2.sqlteamx.com/images/SqlTeamHDR2.jpg" alt="SQLTeam.com Logo" width="123" height="80"/>
		   </a>
		  
		</td>
		<td class="site_header_cell">
		
		
    
<!-- Begin -  Site: SQLTeam.com Zone: SiteBanner -->
<script language="javascript"  type="text/javascript">
<!--
var browName = navigator.appName;
var SiteID = 1;
var ZoneID = 1;
var browDateTime = (new Date()).getTime();
if (browName=='Netscape')
{
document.write('<s'+'cript lang' + 'uage="jav' + 'ascript" src="http://bulldog.sqlteam.com/a.aspx?ZoneID=' + ZoneID + '&amp;Task=Get&amp;IFR=False&amp;Browser=NETSCAPE4&amp;PageID=30521&amp;SiteID=' + SiteID + '&amp;Random=' + browDateTime + '">'); document.write('</'+'scr'+'ipt>');
}
if (browName!='Netscape')
{
document.write('<s'+'cript lang' + 'uage="jav' + 'ascript" src="http://bulldog.sqlteam.com/a.aspx?ZoneID=' + ZoneID + '&amp;Task=Get&amp;IFR=False&amp;PageID=30521&amp;SiteID=' + SiteID + '&amp;Random=' + browDateTime + '">'); document.write('</'+'scr'+'ipt>');
}
// --> 
</script>
<noscript>
    <a href="http://bulldog.sqlteam.com/a.aspx?ZoneID=1&amp;Task=Click&amp;Mode=HTML&amp;SiteID=1&amp;PageID=30521" target="_blank">
    <img src="http://bulldog.sqlteam.com/a.aspx?ZoneID=1&amp;Task=Get&amp;Mode=HTML&amp;SiteID=1&amp;PageID=30521" width="468" height="60" border="0"  alt=""></a>
end tag for "img" omitted, but OMITTAG NO was specified
Line: 63, Col: 162
…&amp;SiteID=1&amp;PageID=30521" width="468" height="60" border="0" alt=""></a>
</noscript>
<!-- End -  Site: SQLTeam.com Zone: SiteBanner -->
   
     
	   
		
		</td>
	</tr>
</table>

<!-- End Logo and Banner -->
<div class="site_header_menu1">
<table width="100%" class="site_header_menu1" >

    <tr>  
        <td>
            <a id="ctl00_ctl00_hypHome" href="./"> Home </a> |        
            <a id="ctl00_ctl00_hypWeblogs" href="http://weblogs.sqlteam.com"> Weblogs </a> | 
            
            <a id="ctl00_ctl00_hypForums" href="http://forums.sqlteam.com/"> Forums </a> |
            
            <!-- <a href="newsletter.aspx">&nbsp;Newsletter&nbsp;</a> |  -->
            
            <a id="ctl00_ctl00_hypLinks" href="sql-server-links.aspx"> SQL Server Links </a>
   
    
        </td> 
        
       <td style="text-align: right; padding-right: 15px;">

<!-- Google CSE Search Box Begins  -->
<form action="/search.aspx" id="searchbox_011171816663894899992:aow51lf_dim" style="padding: 0px; margin: 0px;">
    Search: 
  <input type="hidden" name="cx" value="011171816663894899992:aow51lf_dim" />
  <input type="hidden" name="cof" value="FORID:9" />
  <input type="text" name="q" size="25" />
  <input type="submit" name="sa" value="&nbsp;Go&nbsp;" />
</form>

<!-- Google CSE Search Box Ends -->
       </td> 
    </tr>
</table> 
</div> 

<div id="site_header_menu2">
    
    <a id="ctl00_ctl00_HyperLink4" href="forums/active.asp"> Active Forum Topics </a> |  
    <a href="popular-articles.aspx">&nbsp;Popular Articles&nbsp;</a> |
   <a href="tag.aspx">&nbsp;All Articles by Tag&nbsp;</a> | 
	
	<a id="ctl00_ctl00_HyperLink5" href="store.aspx"> SQL Server Books </a> |  
	<!-- &nbsp;Resources&nbsp; | 
	&nbsp;Books&nbsp; | -->
	<a id="ctl00_ctl00_HyperLink2" href="about.aspx"> About </a>
	
</div>

<!-- Site Sponsorship -->	

    
<!-- Begin -  Site: SQLTeam.com Zone: SiteSponsor -->
<script language="javascript"  type="text/javascript">
<!--
var browName = navigator.appName;
var SiteID = 1;
var ZoneID = 7;
var browDateTime = (new Date()).getTime();
if (browName=='Netscape')
{
document.write('<s'+'cript lang' + 'uage="jav' + 'ascript" src="http://bulldog.sqlteam.com/a.aspx?ZoneID=' + ZoneID + '&amp;Task=Get&amp;IFR=False&amp;Browser=NETSCAPE4&amp;PageID=42851&amp;SiteID=' + SiteID + '&amp;Random=' + browDateTime + '">'); document.write('</'+'scr'+'ipt>');
}
if (browName!='Netscape')
{
document.write('<s'+'cript lang' + 'uage="jav' + 'ascript" src="http://bulldog.sqlteam.com/a.aspx?ZoneID=' + ZoneID + '&amp;Task=Get&amp;IFR=False&amp;PageID=42851&amp;SiteID=' + SiteID + '&amp;Random=' + browDateTime + '">'); document.write('</'+'scr'+'ipt>');
}
// --> 
</script>
<noscript>
    <a href="http://bulldog.sqlteam.com/a.aspx?ZoneID=7&amp;Task=Click&amp;Mode=HTML&amp;SiteID=1&amp;PageID=42851" target="_blank">
    <img src="http://bulldog.sqlteam.com/a.aspx?ZoneID=7&amp;Task=Get&amp;Mode=HTML&amp;SiteID=1&amp;PageID=42851" width="100" height="20" border="0"  alt=""></a>
end tag for "img" omitted, but OMITTAG NO was specified
Line: 144, Col: 162
…&amp;SiteID=1&amp;PageID=42851" width="100" height="20" border="0" alt=""></a>
</noscript>
<!-- End -  Site: SQLTeam.com Zone: SiteSponsor -->
  
	   

</div>
<!-- ================================  End Site Header ========================================= -->

<form name="aspnetForm" method="post" action="default.aspx" id="aspnetForm">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUJNzIzNDE1NTEyZGTd1Hwe8m4Iqm+PlVLIsTFqkSSZxw==" />
</div>

<div>

	<input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="CA0B0334" />
	<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEWAwKN4JTuDALG5aPEBQKatazxCN72v32Pf8YV8uNnIqlvvCFMkADI" />
</div>
<div id="site_body">


	
	
<table id="content">
	<tr>

	   		<td id="leftcolumn">
		
		<div id="page_content">
		<!-- google_ad_section_start -->
		

<div id="featured-article">
<!-- <h1>Featured Article</h1> -->
  
		    
            <p class="featured-article">Featured Article: <a href="http://www.sqlteam.com/article/fast-csv-import-in-powershell-to-sql-server">Fast CSV Import in PowerShell to SQL Server</a></p>
            <p>I recently had to write some simple scripts for a proof of concept.  These scripts use PowerShell to import and export CSV files from SQL Server.  The scripts were simple to write and maintain but were slow.  It turns out there are a few ways to improve CSV import and export performance in PowerShell.</p>  
           <p class="new-tag-line">
           18 March 2014 -
           <a href="http://www.sqlteam.com/author/bill-graziano">Bill Graziano</a> -
           <a  rel="nofollow"  href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=193235">2 Comments</a> </p> 
                
 </div> 

<div id="middle-column-div">
  <div class="middle-column-div-inside">
       
<h2>Recent Blog Posts</h2>
    
        <p style="padding-bottom: 4pt; margin-bottom: 0pt;">
            <a rel="nofollow" href="http://weblogs.sqlteam.com/billg/archive/2016/12/31/configuring-msdtc-across-domains.aspx">Configuring MSDTC Across Domains</a>  (0&nbsp;Comments)</p> 
            
        <p style="padding-bottom: 4pt; margin-bottom: 0pt;">
            <a rel="nofollow" href="http://weblogs.sqlteam.com/billg/archive/2016/12/19/is-it-sql-now-shows-availability-groups.aspx">Is It SQL now shows Availability Groups</a>  (2&nbsp;Comments)</p> 
            
        <p style="padding-bottom: 4pt; margin-bottom: 0pt;">
            <a rel="nofollow" href="http://weblogs.sqlteam.com/mladenp/archive/2016/11/28/ssms-tools-pack-4-2-is-out-with-beta-support.aspx">SSMS Tools Pack 4.2 is out with beta support for SSMS 17 RC1, new features and minor bug fixes.</a>  (1&nbsp;Comment)</p> 
            
        <p style="padding-bottom: 4pt; margin-bottom: 0pt;">
            <a rel="nofollow" href="http://weblogs.sqlteam.com/billg/archive/2016/11/10/database-mirroring-in-is-it-sql.aspx">Database Mirroring in Is It SQL</a>  (1&nbsp;Comment)</p> 
            
        <p style="padding-bottom: 4pt; margin-bottom: 0pt;">
            <a rel="nofollow" href="http://weblogs.sqlteam.com/denisem/archive/2016/10/04/my-statement-of-support-of-wendy-pastrick-for-the-pass.aspx">My Statement of Support of Wendy Pastrick for the PASS Board</a>  (0&nbsp;Comments)</p> 
            
        <p style="padding-bottom: 4pt; margin-bottom: 0pt;">
            <a rel="nofollow" href="http://weblogs.sqlteam.com/billg/archive/2016/09/20/tagging-servers-in-is-it-sql.aspx">Tagging Servers in Is It SQL</a>  (0&nbsp;Comments)</p> 
            
        <p style="padding-bottom: 4pt; margin-bottom: 0pt;">
            <a rel="nofollow" href="http://weblogs.sqlteam.com/billg/archive/2016/08/30/isitsql-shows-databases.aspx">IsItSql Shows Databases</a>  (0&nbsp;Comments)</p> 
            
        <p style="padding-bottom: 4pt; margin-bottom: 0pt;">
            <a rel="nofollow" href="http://weblogs.sqlteam.com/billg/archive/2016/08/04/isitsqlndash1-0-18.aspx">IsItSql&ndash;1.0.18</a>  (0&nbsp;Comments)</p> 
            

    


  </div>
  <div class="middle-column-div-inside">
		 
        <h2 style="color: #393594;">Recent Forum Posts</h2>
		<p>  
        <p style="padding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=188730">Preview</a> (4&nbsp;Replies)</p>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del" start-tag
Line: 228, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
      
        <p style="padding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=129475">Error:Subreport could not be shown</a> (7&nbsp;Replies)</p>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del" start-tag
Line: 230, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
      
        <p style="padding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=173025">Failed to convert parameter value from a String to</a> (3&nbsp;Replies)</p>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del" start-tag
Line: 232, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
      
        <p style="padding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=166952">Export dataset  into excel sheet in C#</a> (6&nbsp;Replies)</p>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del" start-tag
Line: 234, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
      
        <p style="padding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=201232">Search 2 Dates between Date Range</a> (0&nbsp;Replies)</p>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del" start-tag
Line: 236, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
      
        <p style="padding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=201230">SQL group by clause issue</a> (0&nbsp;Replies)</p>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del" start-tag
Line: 238, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
      
        <p style="padding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=181469">How to insert from SQL server to Oracle server.</a> (8&nbsp;Replies)</p>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del" start-tag
Line: 240, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
      
        <p style="padding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56499">Parse and format name strings.</a> (21&nbsp;Replies)</p>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del" start-tag
Line: 242, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
    </p>

    </div>
 </div>
		
		
<h2 id="recent-articles">Recent Articles</h2> 

		    
               <div style="">
            <h3><a href="http://www.sqlteam.com/article/using-dynamic-sql-in-stored-procedures" class="document-icon" >Using Dynamic SQL in Stored Procedures</a></h3>
            <p>Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements.  The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause.  These are typically called from reports or screens that have multiple, optional search criteria.  This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.</p>  
           <p class="new-tag-line">
           7 March 2011 -
           <a href="http://www.sqlteam.com/author/bill-graziano">Bill Graziano</a> -
           <a  rel="nofollow"  href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=157830">20 Comments</a> </p> 
          </div> 
                
               <div style="">
            <h3><a href="http://www.sqlteam.com/article/handling-sql-server-errors" class="document-icon" >Handling SQL Server Errors</a></h3>
            <p>This article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005.  It includes the usage of common functions to return information about the error and using the TRY CATCH block in stored procedures and transactions.</p>  
           <p class="new-tag-line">
           5 April 2010 -
           <a href="http://www.sqlteam.com/author/bill-graziano">Bill Graziano</a> -
           <a  rel="nofollow"  href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=142481">10 Comments</a> </p> 
          </div> 
                
               <div style="">
            <h3><a href="http://www.sqlteam.com/article/using-replace-in-an-update-statement" class="document-icon" >Using REPLACE in an UPDATE statement</a></h3>
            <p>This article covers using the REPLACE function to selectively replace text inside a string in SQL Server. The REPLACE function is easy to use and very handy with an UPDATE statment.</p>  
           <p class="new-tag-line">
           31 March 2010 -
           <a href="http://www.sqlteam.com/author/bill-graziano">Bill Graziano</a> -
           <a  rel="nofollow"  href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=12211">12 Comments</a> </p> 
          </div> 
                
               <div style="">
            <h3><a href="http://www.sqlteam.com/article/efficiently-reuse-gaps-in-an-identity-column" class="document-icon" >Efficiently Reuse Gaps in an Identity Column</a></h3>
            <p>This article will demonstrate an efficient way to reuse gaps in an identity column. Please note that this is something you normally shouldn't be bothered about in a well-designed database or application. However, there are circumstances where you are forced to do this.</p>  
           <p class="new-tag-line">
           9 February 2010 -
           <a href="http://www.sqlteam.com/author/peter-larsson">Peter Larsson</a> -
           <a  rel="nofollow"  href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=139584">13 Comments</a> </p> 
          </div> 
                
               <div style="">
            <h3><a href="http://www.sqlteam.com/article/testing-with-profiler-custom-events-and-database-snapshots" class="document-icon" >Testing with Profiler Custom Events and Database Snapshots</a></h3>
            <p>We've all had them. One of those stored procedures that is huge and contains complex
business logic which may or may not be executed. These procedures make it an absolute
nightmare when it comes to debugging problems because they're so complex and have
so many logic offshoots that it's very easy to get lost when you're trying to determine
the path that the procedure code took when it ran. Fortunately Profiler lets you
define custom events that you can raise in your code and capture in a trace so you
get a better window into the sub events occurring in your code. I found it very
useful to use custom events and a database snapshot to debug some code recently
and we'll explore both in this article. I find raising these events and running
Profiler to be very useful for testing my stored procedures on my own as well as
when my code is going through official testing and user acceptance. It's a simple
approach and a great way to catch any performance problems or logic errors.</p>  
           <p class="new-tag-line">
           22 June 2009 -
           <a href="http://www.sqlteam.com/author/mike-femenella">Mike Femenella</a> -
           <a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=128042">1 Comment</a> </p> 
          </div> 
                
               <div style="">
            <h3><a href="http://www.sqlteam.com/article/advanced-sql-server-2008-extended-events-with-examples" class="document-icon" >Advanced SQL Server 2008 Extended Events with Examples</a></h3>
            <p>In the previous article we learned about SQL Server 2008 Extended Events terminology, components and 
took a look at a simple example. In this article we&#39;ll take a deeper look with some more complex examples.</p>  
           <p class="new-tag-line">
           25 May 2009 -
           <a href="http://www.sqlteam.com/author/mladen-prajdic">Mladen Prajdić</a> -
           <a rel="nofollow" href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=126411">1 Comment</a> </p> 
          </div> 
                
               <div style="">
            <h3><a href="http://www.sqlteam.com/article/introduction-to-sql-server-2008-extended-events" class="document-icon" >Introduction to SQL Server 2008 Extended Events</a></h3>
            <p>SQL Server 2008 Extended Events are the new low level, high performance eventing system in SQL Server.  They use less system resources and provide better tracking of SQL Server performance than previous methods like Perfmon and SQL Trace/Profiler events.</p>  
           <p class="new-tag-line">
           19 May 2009 -
           <a href="http://www.sqlteam.com/author/mladen-prajdic">Mladen Prajdić</a> -
           <a  rel="nofollow"  href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=125977">0 Comments</a> </p> 
          </div> 
                
               <div style="">
            <h3><a href="http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell" class="document-icon" >Monitoring SQL Server Agent with Powershell</a></h3>
            <p>This article introduces the reader to Powershell.  The application that it demonstrates is one that monitors SQL Server Agent to make sure it is running.</p>  
           <p class="new-tag-line">
           24 March 2009 -
           <a href="http://www.sqlteam.com/author/mike-femenella">Mike Femenella</a> -
           <a  rel="nofollow"  href="http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=122354">2 Comments</a> </p> 
          </div> 
                

<div id="article-paging">
    
    &nbsp;&nbsp;
    
    </div>


	<!-- google_ad_section_end -->
	</div> 
	   </td> 
		<td id="rightcolumn">
		
	

<div class="right-box"  style="">
<h2>Subscribe to SQLTeam.com</h2>
<p>Weekly <a href="newsletter.aspx">SQL Server newsletter</a> with articles, 
forum posts, and blog posts via email.  Subscribers receive our <strong>white paper
with performance tips for developers</strong>.</p>

<!-- <p style="text-align: center; font-size: 75%;">Enter your email address:<br/> -->
<p style="text-align:center;">
<input name="ctl00$ctl00$SiteContent$RightColumn1$NS$Email" type="text" id="ctl00_ctl00_SiteContent_RightColumn1_NS_Email" style="width:165px;" />
<input type="submit" name="ctl00$ctl00$SiteContent$RightColumn1$NS$btnSubscribe" value="Subscribe" id="ctl00_ctl00_SiteContent_RightColumn1_NS_btnSubscribe" />
</p>




			
	
<p style="text-align: center;"><a href="http://feeds.sqlteam.com/Sqlteam" style="margin-left: 3px;  padding: 0 0 0 19px;  background: url('http://static2.sqlteamx.com/images/feed-icon-14x14.png') no-repeat 0 50%;">SQLTeam.com Articles via RSS</a></p>
<p style="text-align: center;"><a href="http://feeds.sqlteam.com/SqlteamcomWeblogs" style="margin-left: 3px;  padding: 0 0 0 19px;  background: url('http://static2.sqlteamx.com/images/feed-icon-14x14.png') no-repeat 0 50%;">SQLTeam.com Weblog via RSS</a></p>
</div>

			
<!-- <p style="text-align:center; border-bottom: dotted 1px silver; border-top: solid 1px silver; color:silver; padding-bottom: 3px; padding-top:3px; margin-top: 10px;">Advertisement</p> -->
<!-- <p style="text-align: center;"> -->
<div class="right-box"   style="margin-top: 15px; padding-bottom: 15px;">
<p style="font-size: 9px; text-align: center;">- Advertisement -</p>

		
    

<!-- Begin -  Site: SQLTeam.com Zone: Site300x250 -->
<script language="javascript"  type="text/javascript">
<!--
var browName = navigator.appName;
var SiteID = 1;
var ZoneID = 12;
var browDateTime = (new Date()).getTime();
if (browName=='Netscape')
{
document.write('<s'+'cript lang' + 'uage="jav' + 'ascript" src="http://bulldog.sqlteam.com/a.aspx?ZoneID=' + ZoneID + '&amp;Task=Get&amp;IFR=False&amp;Browser=NETSCAPE4&amp;PageID=47369&amp;SiteID=' + SiteID + '&amp;Random=' + browDateTime  + '">'); document.write('</'+'scr'+'ipt>');
}
if (browName!='Netscape')
{
document.write('<s'+'cript lang' + 'uage="jav' + 'ascript" src="http://bulldog.sqlteam.com/a.aspx?ZoneID=' + ZoneID + '&amp;Task=Get&amp;IFR=False&amp;PageID=47369&amp;SiteID=' + SiteID + '&amp;Random=' + browDateTime  + '">'); document.write('</'+'scr'+'ipt>');
}
// --> 
</script>
<noscript>
    <a href="http://bulldog.sqlteam.com/a.aspx?ZoneID=12&amp;Task=Click&amp;Mode=HTML&amp;SiteID=1&amp;PageID=47369" target="_blank">
    <img src="http://bulldog.sqlteam.com/a.aspx?ZoneID=12&amp;Task=Get&amp;Mode=HTML&amp;SiteID=1&amp;PageID=47369" width="300" height="250" border="0"  alt=""></a>
end tag for "img" omitted, but OMITTAG NO was specified
Line: 400, Col: 164
…amp;SiteID=1&amp;PageID=47369" width="300" height="250" border="0" alt=""></a>
</noscript>
<!-- End -  Site: SQLTeam.com Zone: Site300x250 -->


    
	   
		
<!-- </p> -->

</div>

 
   

<div class="right-box" style="margin-top: 15px;">
            
<h2>Resources</h2>
<p><a id="ctl00_ctl00_SiteContent_RightColumn1_rs1_HyperResources" href="sql-server-resources.aspx">SQL Server Resources</a></p>
<p><a id="ctl00_ctl00_SiteContent_RightColumn1_rs1_HyperLink1" href="advertise.aspx">Advertise on SQLTeam.com</a></p>
<p><a id="ctl00_ctl00_SiteContent_RightColumn1_rs1_HyperLink4" href="store.aspx">SQL Server Books</a></p>
<p><a id="ctl00_ctl00_SiteContent_RightColumn1_rs1_HyperLink5" href="newsletter.aspx">SQLTeam.com Newsletter</a></p>

<p><a id="ctl00_ctl00_SiteContent_RightColumn1_rs1_HyperLink2" href="contactus.aspx">Contact Us</a></p>
<p><a id="ctl00_ctl00_SiteContent_RightColumn1_rs1_HyperLink3" href="about.aspx">About the Site</a></p>
<p><span id="ctl00_ctl00_SiteContent_RightColumn1_rs1_lblUserName"></span></p>
           </div> 
          


		    

		

		</td>

	

	</tr>
</table>	
	
	
	


</div>
<div id="site-footer"><hr />
    © 2000-2017 
    SQLTeam Publishing, LLC |
    <a id="ctl00_ctl00_privacyHyperlink" href="privacy.aspx">Privacy Policy</a>
    
    
</div>
</form>

<script type="text/javascript" src="http://www.google.com/coop/cse/brand?form=searchbox_011171816663894899992%3Aaow51lf_dim"></script>

</body>

</html>

end tag for "img" omitted, but OMITTAG NO was specified
Line: 144, Col: 162
…&amp;SiteID=1&amp;PageID=42851" width="100" height="20" border="0" alt=""></a>
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del"
Line: 228, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del"
Line: 230, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del"
Line: 232, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del"
Line: 234, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del"
Line: 236, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del"
Line: 238, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del"
Line: 240, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
document type does not allow element "p" here; missing one of "object", "applet", "map", "iframe", "button", "ins", "del"
Line: 242, Col: 60
…ding-bottom: 6pt; margin-bottom: 0pt;"><a rel="nofollow" href="http://www.sqlt…
end tag for "img" omitted, but OMITTAG NO was specified
Line: 400, Col: 164
…amp;SiteID=1&amp;PageID=47369" width="300" height="250" border="0" alt=""></a>
end tag for "img" omitted, but OMITTAG NO was specified
Line: 63, Col: 162
…&amp;SiteID=1&amp;PageID=30521" width="468" height="60" border="0" alt=""></a>
there is no attribute "property"
Line: 9, Col: 138
… content="noarchive" /><meta property="fb:page_id" content="181788198509369" /…