Re: Machine Name In Trigger

From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 02/25/05 

Date: Thu, 24 Feb 2005 20:26:29 -0500

Check out HOST_NAME() in the BOL. 

-- 
   Tom
----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON   Canada
www.pinnaclepublishing.com
.
"Neil" <njones@pxdy.com> wrote in message 
news:N1vTd.5219$873.4670@newsread3.news.pas.earthlink.net...
Is it possible to get the machine name in a trigger so that it can be stored
in a field?
Thanks.

Relevant Pages

  • Re: Indexed Views
    ... Columnist, SQL Server Professional ... >I got this from my BOL: ... >Thomas A. Moreau, BSc, PhD, MCSE, MCDBA ... >SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: IsNull bad?
    ... I find it interesting that SQL Server stop processing when the first non-null parameter is ... disregarding if any other the right-most parameters will cause a datatype conversion ... Tibor Karaszi, SQL Server MVP ... According to BOL, the datatype>> returned is the one of the first parameter, in the case of the script, varchar. ...
    (microsoft.public.sqlserver.programming)
  • Re: Returning Record Identity
    ... Books Online (BOL) is the documentation that comes with SQL Server. ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: creating db from mdf and ldf files
    ... Check out sp_attach_db in the BOL. ... SQL Server MVP ... Columnist, SQL Server Professional ... "hahnja peters" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: View Backup Header from T-SQL
    ... Check out RESTORE HEADERONLY in the BOL. ... SQL Server MVP ... Columnist, SQL Server Professional ... Is there a way you can view the database name from a backup file, ...
    (microsoft.public.sqlserver.programming)