[dba-SQLServer]Linking to Local Table

Stuart McLachlan stuart at lexacorp.com.pg
Wed Oct 29 19:31:09 CST 2003


On 29 Oct 2003 at 19:27, Djabarov, Robert wrote:

> I don't think Hostname() is a valid function.  There is a global
> variable that'll return the computer name of the server where SQL Server
> is installed, also known as an instance name (due to multi-instance
> capabilities of 2K), - @@SERVERNAME.
> 
>
Sorry, I was working from memory. I just checked it. 
That should have been Host_name().


-- 
Stuart McLachlan
Lexacorp Ltd
Application Development,  IT Consultancy
http://www.lexacorp.com.pg



More information about the dba-SQLServer mailing list