Me playing with Visual Studio 2005

SQLExpress:

1. if you want to see it under server explorer you need to explicitly state the name of the instance to “.\SQLExpress”.

2. Debugging a function under SQL Express is off by default, to enable it right click the connection name under the Data Connections in the Server Explorer and choose 'Allow SQL/CLR Debugging'.