Can I change SQL Server name?

First. Usually, SQL Server name is equal to computer name. Can I change SQL
Server name? So example: My computer name is ADIW, But SQL Server name is
ALI.
Can I do like it?
Second. Can/may one computer have 2 SQL Server? If Can, So how to make it?Hi,
Login into sql server using Query Analyzer and execute below commands,
sp_dropserver <old server name>
go
sp_addserver <newserver name>,local
After this stop and start sql server service
2. From SQL 2000 onwards you can install 16 instances of sql server in the
same machine. Each of the installation is independant of itself.
First installation will be default and the rest will be of named
installation. For Named instances the server name will be prefixed with a
Name.
This will allow all the sql server services to run in parellel.
Thanks
Hari
SQL Server MVP
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:eoXn92QVFHA.3444@.TK2MSFTNGP10.phx.gbl...
> First. Usually, SQL Server name is equal to computer name. Can I change
SQL
> Server name? So example: My computer name is ADIW, But SQL Server name is
> ALI.
> Can I do like it?
> Second. Can/may one computer have 2 SQL Server? If Can, So how to make it?
>|||1: http://www.karaszi.com/SQLServer/in...server_name.asp
2. Yes. Install several instances (run setup several times).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Bpk. Adi Wira Kusuma" <adi_wira_kusuma@.yahoo.com.sg> wrote in message
news:eoXn92QVFHA.3444@.TK2MSFTNGP10.phx.gbl...
> First. Usually, SQL Server name is equal to computer name. Can I change SQ
L
> Server name? So example: My computer name is ADIW, But SQL Server name is
> ALI.
> Can I do like it?
> Second. Can/may one computer have 2 SQL Server? If Can, So how to make it?
>sql

Can @@ROWCOUNT = 0 even when a row is inserted into a table?

Does @.@.ROWCOUNT always return an accurate acount of rows affected by last query OR can it be equal to zero when some rows have been affected?

The @.@.ROWCOUNT function returns the number of rows affected by the last statement, no matter what type (insert/update/delete/select) of the statement is. It just like if you execute a statement in Query Analyzer with the NOCOUNT option off, a message will come with result indicates how many rows are affected.|||And to be clear, the availability of @.@.ROWCOUNT is not affected by the SET NOCOUNT setting.

Don