Friday, June 28, 2013

Network share in command prompt


pushd \\server\share

This will create a temporary mapped drive automatically for you and make it your current working directory.

When you're finished on the network share enter the popd command. This will return you to the directory you were in before and delete the temporary network drive.

Monday, June 3, 2013

Change Password of the sa user in MS SQL server

USE [master]

GO

ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master],

DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=ON, CHECK_POLICY=ON

GO

USE [master]

GO

ALTER LOGIN [sa] WITH PASSWORD='password@123' MUST_CHANGE

GO