<div>
All logins in sysadmin server role (including SA) are granted access to all tables in all databases.<br />
After creating a table I suggest you to create your own database role, grant that role insert priviledge. Then add all your logins as database users in your newly created database role.<br />
<br />
Some resources:<br />
<a href="http://sqlserverpedia.com/wiki/Database_Roles" rel="ugc">http://sqlserverpedia.com/wiki/Database_Roles</a><br />
<a href="http://msdn.microsoft.com/en-us/library/ms189121%28v=SQL.100%29.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms189121%28v=SQL.100%29.aspx</a><br />
<a href="http://www.mssqltips.com/tip.asp?tip=2038" rel="ugc">http://www.mssqltips.com/tip.asp?tip=2038</a>
</div>


All logins in sysadmin server role (including SA) are granted access to all tables in all databases.
After creating a table I suggest you to create your own database role, grant that role insert priviledge. Then add all your logins as database users in your newly created database role.

Some resources:
http://sqlserverpedia.com/wiki/Database_Roles [http://sqlserverpedia.com/wiki/Database_Roles]
http://msdn.microsoft.com/en-us/library/ms189121%28v=SQL.100%29.aspx [http://msdn.microsoft.com/en-us/library/ms189121%28v=SQL.100%29.aspx]
http://www.mssqltips.com/tip.asp?tip=2038 [http://www.mssqltips.com/tip.asp?tip=2038]

<div>
<div class="content wysiwyg-content">
hello , <br />
i want to create table in sql server but restrict access to sa only <br />
other users can only insert in this table 
</div>
</div>


hello , 
i want to create table in sql server but restrict access to sa only 
other users can only insert in this table 

sql server table access restriction

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.