RDC Console Option Changed in Windows XP SP3
Friday, 30 May 2008
I nominate this change as one of the strangest I’ve seen.
In Microsoft’s Remote Desktop Connection before Windows XP SP3, the /console switch would connect you to the console session of the remote computer. In SP3, the switch was changed to /admin.
Huh?
A blog post from the Enterprise Platforms Windows Server Performance Team explains.
This was annoying to figure out. I had created a new VM using VMware Fusion 2.0 beta for SP3 and couldn’t connect to my work computer. I ended up downgrading back to VMware Fusion 1.1 before I found out about the above change. Grrrr.
Don’t forget that you can add the /admin switch after the computer name in the Computer text box in RDC (on both Windows and Mac). Here’s a screenshot:
Get System.Diagnostics.Trace Output to you ASP.NET Page
Friday, 22 February 2008
How to view System.Diagnositcs.Trace messages on your ASP.NET page.
SQL Server 2000: "Could not continue scan with NOLOCK due to data movement" or "I/O error (bad page ID) detected during read at offset"
Thursday, 1 February 2007
Running a SQL script against SQL Server 2000 (SP3 and SP4) gave me the following errors:
Could not continue scan with NOLOCK due to data movement. I/O error (bad page ID) detected during read at offset 0xBlah in file ‘C:\Program Files\Microsoft SQL Server\MSSQL\Data\Blah.mdf’.
To fix it, I had to run the following command three times for SQL server to fix the problem.
DBCC CHECKDB ('<DB_NAME>', REPAIR_ALLOW_DATA_LOSS )
To run this command, I had to first put the database in single user mode. To do so, I opened SQL Server Enterprise Manager, right-clicked the database, chose “Properties”, clicked the “Options” tab, checked the “Restrict access” check box, chose the “Single user” radio button, and clicked “OK”. I then connected to that database using Query Analyzer and ran my command three times.
