<div>
did you phsycially change the servers name already?
</div>


did you phsycially change the servers name already?

<div>
when i drop the server, does that technically kill the service?
</div>


when i drop the server, does that technically kill the service?

<div>
You will need to restart the service after the droptable and addtable commands. The service restart will kill all active connections.
</div>


You will need to restart the service after the droptable and addtable commands. The service restart will kill all active connections.

<div>
<div class="content wysiwyg-content">
i need to change the name returned by<br />
select @@servername<br />
<br />
if dropping the servername in sysservers, using sp_dropserver, before adding the correct named one, will there be impact to the users connected to the databases? is it better to do it after hours?<br />
<br />
any other consideration before doing it on a live system?<br />
<br />
thanks
</div>
</div>


i need to change the name returned by
select @@servername

if dropping the servername in sysservers, using sp_dropserver, before adding the correct named one, will there be impact to the users connected to the databases? is it better to do it after hours?

any other consideration before doing it on a live system?

thanks

dropping server while users are connected

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.