-
Disable simple file sharing in Windows XP
Simple file sharing means that when you go to a property page of a folder, you will not see the Security and Sharing tabs. This is the default for Windows XP if the machine is not part of a domain. This can be problematic, because you cannot add specific users and groups to access a…
-
Web based Chinese input
I talked about how to install ZiGuang Chinese input software on an English Windows machine here in this post. Recently I came across InputKing, which allows Chinese input on ANY machine that has Internet access through a web interface. This is perfect for people to try different input methods, playing around, and enter Chinese in…
-
Co-writing a book on Sql Server 2005 admin
I am co-writing another book on Sql Server 2005. This book will focus on administration. I’ve been busy with a lot of technical work lately, and will not post as often as before. Long time readers know that I co-wrote a book on Sql Server Integration Services. It has brought me fame from all over…
-
Using up and down arrow to cycle through sql command
Like osql, if you use up and down arrow, sqlcmd will cycle through sql statements you ran earlier. This can be handy. You can also invoke your editor for command editing, as I discussed here.
-
Renamed sa causing problem during replication distribution setup
In a previous post, I mentioned that it may be a good security practice to rename sa to something else. However, if you did that and later on decided to make the server a distributor in replication, you will get the error message below: Cannot find the principal ‘sa’, because it does not exist or…