set locality sql server 2005

by default sql server comes langauge set "english (united states)", sourroundings date format mm/dd/yy instead date format i wish in, australian date format such dd/mm/yy.

is there an choice server supervision studio / settlement collection where i set locality sql server, hinder datetime fields being formatted us date format?

if not, i modify i am controlling sql query such (forgive me there crude syntax, i finished adult spot):

dim dc new sqlcommand("insert hello values (@date)", cn)
dc.parameters.add(new sqlparameter("date", system.datetime.now))

many interjection advance. :)