Developer Updates

SQL Server 2008 Installation: Rule “Restart Computer” Failed

Gary Zhang — Wed, 28 Apr 2010 00:13:37 GMT

Something hinky went wrong when I installed SQL Server 2008 and the "Restart Computer" rule kept failing no matter how many times I rebooted. After some Googling I found this page which suggested clearing the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations Registry key. I cleared the key and I now the Restart Computer rule passed.

Windows 7 refuse to sleep because mouse keeps waking it up. How to stop the mouse wake up?

Gary Zhang — Sat, 06 Feb 2010 07:54:47 GMT

Do you put your computer into sleep often ? Do you ever accidently touched the mouse and all the sudden find your computer just woke up ? Well to me I don’t purposely to put my computer into sleep often, but instead it sleeps by itself when I don’t use it for over 30 minutes. When that happens chances are I don’t really need to use thecomputer at the moment. But I often I ended up waking up the computer when I try to move around the stuff on my desk, that lead to the mouse to move and eventually lead to the computer to start waking up.

So here is how you can stop the mouse trigger your PC from sleep. This works on both Windows 7 and vista.

First go to start menu search "Mouse"

Click the first result under Control Panel

Go to Hardware tab > Double Click the mouse in the list > Power Management > Uncheck the "Allow this device to wake the computer"

You are done, once you have unchecked this option, you don’t have to worry about accidently touched your mouse while your computer is on sleep anymore.

PrimeObjects Runtime Requirements

Gary Zhang — Sat, 30 Jan 2010 03:54:41 GMT

PrimeObjects provides web based online business software built on a SaaS enterprise application platform. PrimeObjects software can be run and has been tested on the following four browsers.

1. Internet Explorer Ver. 8.0 + on Windows XP, Windows Vista and Windows 7
2. Firefox Ver. 3.5.7 + on Windows XP, Windows Vista and Windows 7
3. Safari Ver.4.0.4 + on Windows XP, Windows Vista, Windows 7
4. Google Chrome Ver.4.0.249.78 + on Windows XP, Windows Vista, Windows 7

Additional requirements for some features
1. Flash need to be supported and enabled on the browser to upload document and play flash video
2. PrimeObjects supports playing of four types of videos online. They are flash video, media player video, real player video and apple’s quick time video. To play the videos in a specific format, the add-on of the corresponding video player need to be installed properly on the browser.

Note: The operation system should have all latest patches applied.

Pass OnLoadJS in the parameter of the form

System Administrator — Wed, 27 Jan 2010 07:13:36 GMT

The OnLoadJS field on the EntityUI record allows us to define the customized OnLoad javascripts to a form. However in some senarios, we may want to pass the OnLoad javascript in the parameter of the form url to make the form behave differently based on different OnLoadJS values in the parameter. For example, when rendering a new Task form for collection the feedback or issues submitted from customer, we want to simplify the Task form by only showing the subject and content. To achieve this, we passed OnLoadJS=OnlyShowContent() in the parameter of the query string so the form will call OnlyShowContent after loaded and hide all unwanted form fields. The whole url will look like this http://www.primeobjects.com/form.aspx?ename=Task&OnLoadJS=OnlyShowContent().

Note: The OnlyShowContent function need to be defined in a javascript file used by the Task entity.

Team Founder Server 2008 - TF53011 Not a licensed user

Gary Zhang — Tue, 05 Jan 2010 13:03:02 GMT

I have tried many ways to add a domain user into Team Foundation Server 2008 without any luck. I keep getting TF53011 error. It seems the security settings on TFS user interface are useless. The Valid User group does not help to make a user "VALID" or say "Licensed".

After Google search for 20 minutes, the command line below eventually did the trick. As I said before Team Foundation Server is garbage. Can you imagine that you have to achieve the most common operation by a command line?

TfsSecurity.exe /server:YourTFSServerName /g+ n:"[Server]\Team Foundation Licensed Users" n:"DomainName\UserName"

Note: You need to keep [Server] as it is without any change.

IE 8 on the Windows XP is different from IE 8 on the Vista or Windows 7

Gary Zhang — Sun, 03 Jan 2010 11:30:29 GMT

Our developer has found some features failed on the IE 8 running on Windows XP. ~~We are looking into the issues and working on the fixes~~. But it is good to know that some scripts work on Vista/Windows7+IE8, Firefox, Safari and Chrome but not on XP+IE8.

Ok we have found the javascript that works in IE8 on Vista and Windows 7 but not on XP. It is the code below.
document.getElementById(id).offsetLeft

We have to change it to $("#"+id).position().left

How does the theme work?

Gary Zhang — Thu, 31 Dec 2009 03:04:17 GMT

The theme selected by the user is saved in the ThemeName attribute of the SystemUser entity, therefore ThemeName column in the SystemUser table. The default value of this field is Lightness.

When user select a theme in the Theme Picker dialog, the page will be redirect to http://www.primeobjects.com/Default.aspx?Theme=[ThemeName]. This will change the theme and at the same time change the user profile.

Announcing the Microsoft AJAX CDN - ScottGu's Blog

Gary Zhang — Thu, 10 Dec 2009 02:49:19 GMT

Announcing the Microsoft AJAX CDN - ScottGu's Blog

Remote desktop (MSTSC) stop working on Windows 7

Gary Zhang — Thu, 10 Dec 2009 02:12:09 GMT

I recently upgraded my machine from Vista Home to Windows 7 Home and since then have been having issues connecting to any machines on my network via remote desktop (MSTSC) connection. Prior to the upgrade, there were no issues and I could connect just fine.

I am able to browse the other machines via windows explorer and can ping them as well, so it doesn't seem to be a connection issue. The machines that I am attempting to remote into are windows server 2003 and 2008.

Essentially what happens is once I open the remote desktop client, enter the name of the machine, then hit connect, the client says "configuring remote session" and hang there forever. The window for the remote connection freezes, and I have to kill it with the task manager.

Fix: Options of remote console -> Local Resources -> Remote Audio -> Settings -> Remote audio playback = Do Not Play

SQL Server Trace File may eat up more than 300GB hard drive space

Gary Zhang — Mon, 07 Dec 2009 04:35:36 GMT

I noticed that my SQL Server box ran out of space today. And the Microsoft SQL Server folder is as big as 350GB, however I know I have no my database files saved there. So what is using up more that 300GB space in this folder? Eventually I found tons of audittrace**.trc files in the folder below. After deleting them all, more than 300GB space came back.

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA

Now the question is how can we disable this auditing feature in SQL Server? I ran the following script but it did not help.

Exec sp_configure 'show advanced options', 1
GO
RECONFIGURE;
GO
Exec sp_configure 'default trace enabled',0
GO
RECONFIGURE;

Then I went to the Server property dialog ->Security Setting, noticed the Login Auditing has Both Failed & Success Login turned on, change it back to only audit failed logins. and unchecked Enable C2 Audit Tracing. They were both not on the default settings. And the above two changes finally helped.