Hi,

try this :

select right(getdate(),8)

and stored it in a nvarchar(8).

PS:You may need to convert it.

If you won't have to start it each time manually :

Right click on MSSQL Server and change startup type to automatic in properties (do the same with SQL Server Agent)