<div>
You could write a stored procedure for him and have him import and run it.
</div>


You could write a stored procedure for him and have him import and run it.

<div>
This article describes how to import the stored procedure.<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/vstudio/bb896231(v=vs.100).aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/vstudio/bb896231(v=vs.100).aspx</a>
</div>


This article describes how to import the stored procedure.

http://msdn.microsoft.com/en-us/library/vstudio/bb896231(v=vs.100).aspx [http://msdn.microsoft.com/en-us/library/vstudio/bb896231(v=vs.100).aspx]

<div>
The other option would be to make a C# program to connect to the database server and then issue the commands. &nbsp;You would want to prompt the user for the name or IP address of the server, the username and password of a user account that has administrative rights on the DBMS. &nbsp;You could then publish the app and send the executable or installer to him.
</div>


The other option would be to make a C# program to connect to the database server and then issue the commands.  You would want to prompt the user for the name or IP address of the server, the username and password of a user account that has administrative rights on the DBMS.  You could then publish the app and send the executable or installer to him.

<div>
<div class="content wysiwyg-content">
I have a windows form .net application that uses SQL Server 2012 Express. &nbsp;I have a user of this application who knows nothing of SQL Server and he needs a new table added to the SQL Server Database that my application uses. &nbsp;Is there a way to create an executable script that I can send to this user that would execute a SQL script to create a new table? &nbsp;I do have SQL Server management studio so is there anything in this tool that will allow me to create an executable script for this user? &nbsp;I only want this user to execute the script and let the script to the work of create a new table in an existing database.
</div>
</div>


I have a windows form .net application that uses SQL Server 2012 Express.  I have a user of this application who knows nothing of SQL Server and he needs a new table added to the SQL Server Database that my application uses.  Is there a way to create an executable script that I can send to this user that would execute a SQL script to create a new table?  I do have SQL Server management studio so is there anything in this tool that will allow me to create an executable script for this user?  I only want this user to execute the script and let the script to the work of create a new table in an existing database.

Script to create a SQL Server Table

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.