How to define day name in SQL Server Thursday, Sep 4 2008 

Programming and SQL Server , thomaszae 10:15 am

The SQL function that you could use is datename(datepart, date). Datepart is kind of properties that you’d like to use. For example, dw is kind of datepart to define week day, or mm to define month name. Here is the example

select datename(dw, getdate())

The result is

Thursday

You could try others datepart such as dw, mm, dy, wk, ww. Have a nice try :)

 

Shortcut to faster login (SL 7.0 SP1) Wednesday, Sep 3 2008 

Ms Dynamics Solomon and work , thomaszae 1:55 am

There’s a weakness of SL 7.0 SP1 when I’d like to login while I used the different server as current in the last login. Let’s say I’m using ‘SL7Server’ as server name for the first time, and then I’m going back home and would like to continue my work, which is my local server name is different with the latest server name I’ve used. There’s a problem with time when I’d like to login. It really takes time when SL trace the latest server name as default. I’ve ever waited it for 20 minutes and there was nothing.

The shortcut way to make it faster is deleting the solomon.ini file in C:\Documents and Settings\[my windows login name]\Local Settings\Application Data\Microsoft Dynamics SL.  I’ve tried it and it worked :) , SL will create a new solomon.ini file after the re-login.