The Ji Village News

Category: Technology

  • Drop the empty schema first before you can remove its user

    A few weeks ago, I ran into an issue with a SQL Server 2005 database restored from a Sql Server 2000 backup file. I want to share how I resolved this, hopefully it will be helpful to somebody. You can restore a Sql Server 2000 database backup to a SQL Server 2005 server. When pages…

  • Notes on DNN (DotNetNuke) Roles and Permissions

    1. From Admin menu, the right-most menu item before the search box, pick “Security Roles”; 2. You will see all the roles here. Click the pencil icon next to each role to edit it; 3. To create a new role, click on Security Roles downward triangle icon, which is next to the lock icon, and…

  • No edit in DOS on Windows 64-bit

    I’ve been working with 64-bit SQL Server 2005 laterly. I just finished setting up a 2-node SQL Server 2005 cluster with SP1 on AMD 64-bit processors with Windows 2003 R2. 64-bit is really sweet. Anyway, I guess the venerable DOS editor named edit is not ported to 64-bit machines. I figured this out when testing…

  • Old computers at Dallas Children’s Museum

    We went to Plano, Texas, a suburb of Dallas, for my son’s spring break. My brother’s family just moved there recently. With everybody being new to the area, I didn’t know which place to visit for some fun. Naturally, I started looking for Children’s museums. Some web search revealed there is a place called Dallas…

  • Fixing remote connection problem for Microsoft SQL Server 2005

    Today I played with a server setup a few months ago but has since been neglected. It has Microsoft SQL Server 2005 Standard Edition on it. I got the following error when trying to connect to it using sqlcmd integrated authentication from my workstation: C:\>sqlcmd -S MyServer HResult 0x35, Level 16, State 1 Named Pipes…