title: Missing Index Sysname
body: <p>When I used SQL Server Management Studio to display the estimated execution plan of a query it will sometimes suggest a missing index.</p>
  
  <p>My question is about the sysname in the following suggestion - What does sysname mean?</p>
  
  <p>I would normally just replace the firstline with CREATE NONCLUSTERED INDEX [IX_Users_Surname] so I don't understand the sysname reference.</p>
  
  <pre><code>CREATE NONCLUSTERED INDEX [&lt;Name of Missing Index, sysname,&gt;]
  ON [dbo].[Users] ([Surname])
  INCLUDE ([UserID],[Firstname],[Email],[Password])
  </code></pre>