December WARDY IT Community Dinner

The final WARDY IT Community Dinner for 2007 is being held at Mint Indian Gourmet, Fortitude Valley on Monday the 17th of December. To RSVP to be at this event send an email to peter @ wardyit.com.

WHERE Mint Indian Gourmet | 394 Brunswick Street | Fortitude Valley

WHEN Monday 17th December | 6:30PM

RSVP Friday 14th December

Please note that you are responsible for the cost of your own dining.

Add this event to your Outlook Calendar

Free Inside SQL Server 2005 Books

Any bookings that are completed for Kalen Delaney’s SQL Server Architecture, Internals and Optimisation course prior to the 30th of November 2007 receive the entire four book series of Inside SQL Server 2005 valued at over $400.00. Make sure you do not delay taking advantage of this offer, as there are only a limited number of places remaining in Brisbane and Sydney. Phone 1300 WARDY IT (927 394) to make a booking today.

More details about this course can be found here.

Course dates:

  • Brisbane 18th to 22nd February
  • Sydney 25th to 29th February

SMO Impersonate Windows Account

I received an email from a colleague this morning asking how to use SMO to impersonate another windows user to connect to SQL Server. Below is how this can be achieved using SMO:

Dim myServerConn As New Microsoft.SqlServer.Management.Common.ServerConnection

myServerConn.LoginSecure = True

myServerConn.ConnectAsUser = True

myServerConn.ConnectAsUserName = “username@domain”

myServerConn.ConnectAsUserPassword = “password*”

myServerConn.ServerInstance = “ServerInstance”

myServerConn.Connect()

The one thing to be aware of is that the username needs to be in the format username@domain instead of username\domain.