In database on Sql Server 2005, I have to change schema names from some username to dbo and I wrote the following sql statements which simply generates alter queries. All you have to do is to change 'Username Here' to actual username, it will generates alter queries for you and then just copy and execute them in query window.

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + p.Name FROM sys.Procedures p INNER JOIN sys.Schemas s on p.schema_id = s.schema_id WHERE s.Name = 'Username Here'  

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + t.Name FROM sys.Tables t INNER JOIN  
sys.Schemas s on t.schema_id = s.schema_id WHERE s.Name = 'Username Here'  

SELECT 'ALTER SCHEMA dbo TRANSFER' + s.Name + '.' + v.Name FROM sys.Views v INNER JOIN
sys.Schemas s on v.schema_id = s.schema_id WHERE s.Name = 'Username Here'

I was in training yesterday and the training office did not have Internet access. I know that the T-mobile Dash smartphone I have has the capability of sharing its Internet access. So I played around with the setting and struck gold. It was pretty easy to setup.

On the Dash, go to Start>Accessories>Internet Sharing on the PC Connection make sure is set to USB or Bluetooth PAN and Network Connection make sure is set to T-Mobile Data and hit Connect. That should do it. You should be able to get an IP address from the Dash for your laptop to be able to connect to the Internet.

From your PC, connect to the Dash with USB cable or Bluetooth PAN (preferred). The connection is as fast as GPRS could offer but it is better than nothing when you are desperate for an Internet connection.