SQL Server 2005/2008 UTF-8 Collation/Charset
No, there isn't. SQL Server doesn't support UTF-8.
You need to define your columns as nvarchar/nchar if you want unicode data. Note, internally SQL Server stores this as UCS-2.
Note that this has ben requested from MS on Connect and there is an older KB article. And some info on this blog too