select app_name() as Program_Name
select @@servername ServerName
select db_name() DatabaseName
This is better for finding exact server name especialy when yor server name has changed before
declare @SERVER varchar(20);SELECT @SERVER=CONVERT(varchar(20), SERVERPROPERTY('servername'))