The Ji Village News

Category: Technology

  • 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…

  • 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…

  • Find out version number of Reporting Services

    Here is how to find out the version number of Sql Server Reporting Services on your machine: Go to http://MyServerName/ReportServer. The version number is listed at the bottom of the page, like this: Microsoft SQL Server Reporting Services Version 8.00.1038.00