Simon Steed's Blog About Stuff!

I’ve developed a new website using asp.net in c# to promote my photography business covering weddings,portraits, parties, events, corporates etc – visit the site and let me know your thoughts:

http://www.simonantony.co.uk

This one always catches me out, about time I logged it so I don’t need to googlise it everytime!

SQL SERVER – Fix : Error: 18452 Login failed for user ‘(null)’. The user is not associated with a trusted SQL Server connection.

ALTER LOGIN sa ENABLE
GO
ALTER LOGIN sa WITH PASSWORD = ”
GO

Taken from SQLAuthority.com

I’ve not worked with SQL Server DateTime values for a while now so was a little rusty. I needed to do some date filtering and came across the following site by MVP Tibor Karaszi that I found really useful:

http://www.karaszi.com/SQLServer/info_datetime.asp