In Microsoft SQL Server 2000 The error logs are located in the C:\Program Files\Microsoft SQL Server\MSSQL\LOG directory.
In Microsoft SQL Server 2005 The error logs are located in the C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG directory.
Where x is the instance ID that you are currently working on.
Microsoft SQL Server 2008 The error logs are located in C:\Program Files\Microsoft SQL Server\MSSQL10.SMSQLSERVER. If you have a named instance, the location is C:\Program Files\Microsoft SQL Server\MSSQL10.<instance name>
In Microsoft SQL Server 2005 The error logs are located in the C:\Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG directory.
Where x is the instance ID that you are currently working on.
Microsoft SQL Server 2008 The error logs are located in C:\Program Files\Microsoft SQL Server\MSSQL10.SMSQLSERVER. If you have a named instance, the location is C:\Program Files\Microsoft SQL Server\MSSQL10.<instance name>