Our need is to be able to convert an abitrary UTC time to local time (and vice versa) for an arbitrary US county or country in Europe.  what I mean by arbitrary...

another reason is code reuse.

In our org, we use CLR functions to expose to our procs in SQL a library of useful functions that are shared with other managed components.  For example,...

this whitepaper has lots of good information about adminstering AS 2005:

http://download.microsoft.com/download/8/5/e/85eea4fa-b3bb-4426-97d0-7f7151b2011c/SSAS2005PerfGuide.doc

indeed, a trigger that reaches across to another server will KILL your perf, as well as cause many other problems already mentioned.

did you try uninstalling msxml 6.0 from add/remove programs?

T-SQL is not the optimal language for string parsing.  You might consider exporting the data to a flat file and then parsing it with a language built for the task, such as...

I'll say it once more and then stop.  create a backup.

all good production databases have a good backup strategy.  if you don't, you risk this: http://www.iht.com/articles/ap/2007/03/20/america/NA-GEN-US-Lost-Data.php

Mohammed, that article doesn't describe logon triggers, rather logon events that are processed (asynchronously) by service broker.

logon triggers are different in that they are synchronous.  described here: http://msdn2.microsoft.com/en-us/library/bb326598.aspx.  This is what...

also I ran across this blog post today that might be of use:

http://weblogs.sqlteam.com/phils/archive/2007/04/30/60193.aspx

it will find logins that aren't mapped to any users.

You can encrypt data in 2005.  See: http://www.microsoft.com/technet/itshowcase/content/sqldatsec.mspx

sounds to me like the login you are using to connect doesn't have permissions to create databases.

You really ought to report this to MS.

in 2005 you can make a DDL trigger to catch a login event to do this.  Just update a table with the login name and current time, and after a...

100% reliance on DTA is not a good idea.  You need to use your common sense as a DBA to evaluate whether the indexes it suggests are really appropriate for your...

I very much doubt there is a way to determine this.