Generating uniqu GUIDS in MS Sql Server

Use NewId() to generate new unique guids .

Stupid MS Sql Server Logon failure

The So called MS Sql Server throws up a ERROR 1069 : Logon failure everytime you change indows password .

The way to get it working is :

o correct the password in Microsoft Windows 2000 Server and Microsoft Windows XP:

1.	Click Start, point to Settings, and then click Control Panel.
2.	Double-click Administrative Tools, and then double-click Services.
3.	Use one of the following steps based on your instance type: • For a default instance of SQL Server, double-click MSSQLServer, and then click the Log On tab. • For a named instance of SQL Server, double-click MSSQL$YourInstanceName, and then click the Log On tab. Replace YourInstanceName with the actual name of the SQL Server instance. • For a default instance of SQL Server Agent, double-click SQLAgent, and then click the Log On tab. • For a named instance of SQL Server Agent, double-click SQLAgent$YourInstanceName, and then click the Log On tab. Replace YourInstanceName with the actual name of the SQL Server instance.
4.	Type the correct password in the Password and Confirm password textbox, and then click OK.