System.Web is unsupported in SQL Server for a reason. Even if you can get it loaded, you can't get...

So far it still exists in SQL 2008.

Ryan,

I haven't ever actually implemented one, but I am certain that it would be fairly complex, given the fact that there is no international standard, and not all timezones participate...

You can do this from TSQL by building your app as a Console Application that accepts CommandLine arguments, and then calling that app from xp_cmdshell inside a stored procedure with...

I guess to me and probably most people the question back to you would be why do you want to do this from TSQL? This isn't a task that...

Rather than store the name, why don't you store the offset from UTC? Or you can create a lookup table with the Name/Offset pair and use an ID field...

Is it always going to be based on the SQL Servers Local Time Zone?

This might help you some, but here is a function that gets the current UTC Time:

[Microsoft.SqlServer.Server.SqlFunction]

public static SqlDateTime UTCTimeConversion()

...

What are you doing in the procedure before the connection portion you show here? It is almost impossible to look at this small a piece of code and offer...

Generally, you would have issued a CREATE ASSEMBLY for your referenced assembly as well in SQL Server. If you do an auto deploy from VS 2005 it may have...

You can not use SMO inside of SQLCLR. Seems counter intuitive, but it has to do with SMO not supporting partially trusted callers and using special type of connection...

You have pretty much defined your problem correctly, so all you have to do is implement the changes you mention. What problems have you encountered implementing this, and what...

Steve,

I am not sure why that won't work for you, but here is another link:

http://msdn.microsoft.com/en-us/library/ms345124.aspx

If that doesn't work, you can google "SQL Server 2005 Row Versioning-Based Transaction Isolation" and it...

GilaMonster (7/14/2008)

Up until now, I've considered this kind of deadlock theoretically possibel, but not likely to occur in a real system, due to the frequency of queries necessary.

But I did...

Start by checking firewall settings on both ends. Windows firewall blocks SQL by default I believe, so you have to allow it to come through.