Derik Whittaker

Browse by Tags

• Best Practice
• HowTo

• How to Login to SQL Management Studio if your default database has been deleted.

  Today I had a weird issue, I could not log into SQL Management studio because my default database had been deleted (it was no longer needed). Every time I would try to log in, I would get the following dialog. At first I was kind of stumped, I did not... Posted Feb 19 2008, 07:01 AM by Derik Whittaker with | with 6 comment(s) Filed under: sql2005, HowTo

• Try-Catch in Sql 2005 is your friend.

  I know that SQL 2005 has been out for a while now, but I did not do ANY sql for over a year.  Anyway, anyone that has had to write anything more than trival procs knows that error handling can be a pain. In the past you have had to do something along... Posted Jan 18 2008, 09:00 AM by Derik Whittaker with | with 4 comment(s) Filed under: sql2005, Best Practice