JohanPersson.nu

Find out which SP you have on your SQL Server

From query analyzer run select serverproperty(‘productlevel’)

Thanks Henk

Adding Shortcut from script

This utility is used for adding shortcuts from a script.

Source

xxmklink.zip (18.84 KB)

Bulk setting Ownership and Permissions on userfolders

@echo off
cacls %1 /T /P “DOMAIN%1”:F “DOMAINDomain Admins”:F < y
chown -r -v -d DOMAIN %1 [Userfolder Path]%1*

chown.zip (34.23 KB)

Unable to edit Offline Folder settings in Outlook 2000

Q: I can’t set or change settings for offline folders in Outlook 2000 on my computer

A: Make sure that you do not have Terminal Services of ANY kind installed on your computer. TS is not supported with Outlook 2000 which means that this option will not show up.

Source

Environment Variables in Windows

Variable	Type	Description
%ALLUSERSPROFILE%	Local	Returns the location of the All Users Profile.
%APPDATA%	Local	Returns the location where applications store data by default.
%CD%	Local	Returns the current directory string.
%CMDCMDLINE%	Local	Returns the exact command line used to start the current Cmd.exe.
%CMDEXTVERSION%	System	Returns the version number of the current Command Processor Extensions.
%COMPUTERNAME%	System	Returns the name of the computer.
%COMSPEC%	System	Returns the exact path to the command shell executable.
%DATE%	System	Returns the current date. Uses the same format as the date /t command. Generated by Cmd.exe. For more information about the date command, see Date
%ERRORLEVEL%	System	Returns the error code of the most recently used command. A non zero value usually indicates an error.
%HOMEDRIVE%	System	Returns which local workstation drive letter is connected to the user’s home directory. Set based on the value of the home directory. The user’s home directory is specified in Local Users and Groups.
%HOMEPATH%	System	Returns the full path of the user’s home directory. Set based on the value of the home directory. The user’s home directory is specified in Local Users and Groups.
%HOMESHARE%	System	Returns the network path to the user’s shared home directory. Set based on the value of the home directory. The user’s home directory is specified in Local Users and Groups.
%LOGONSEVER%	Local	Returns the name of the domain controller that validated the current logon session.
%NUMBER_OF_PROCESSORS%	System	Specifies the number of processors installed on the computer.
%OS%	System	Returns the operating system name. Windows 2000 displays the operating system as Windows_NT.
%PATH%	System	Specifies the search path for executable files.
%PATHEXT%	System	Returns a list of the file extensions that the operating system considers to be executable.
%PROCESSOR_ARCHITECTURE%	System	Returns the chip architecture of the processor. Values: x86, IA64.
%PROCESSOR_IDENTIFIER%	System	Returns a description of the processor.
%PROCESSOR_LEVEL%	System	Returns the model number of the processor installed on the computer.
%PROCESSOR_REVISION%	System	Returns the revision number of the processor.
%PROMPT%	Local	Returns the command prompt settings for the current interpreter. Generated by Cmd.exe.
%RANDOM%	System	Returns a random decimal number between 0 and 32767. Generated by Cmd.exe.
%SYSTEMDRIVE%	System	Returns the drive containing the Windows XP root directory (that is, the system root).
%SYSTEMROOT%	System	Returns the location of the Windows XP root directory.
%TEMP% and %TMP%	System and User	Returns the default temporary directories that are used by applications available to users who are currently logged on. Some applications require TEMP and others require TMP.
%TIME%	System	Returns the current time. Uses the same format as the time /t command. Generated by Cmd.exe. For more information about the time command, see Time
%USERDOMAIN%	Local	Returns the name of the domain that contains the user’s account.
%USERNAME%	Local	Returns the name of the user who is currently logged on.
%USERPROFILE%	Local	Returns the location of the profile for the current user.
%WINDIR%	System	Returns the location of the operating system directory.

Source

Printers That Use Ports That Do Not Begin With COM, LPT, or USB Are Not Redirected in a Remote Desktop or Terminal Services Session

If you try to connect to a terminal server and have setup local Printer Redirection this might not work on some USB Printers will not be redirected. This is due to a filter on redirection that only redirects ports beginning with LPT, COM or USB. This filter can be turned of.

KB Article

Policy for offering remote assistance

In Computer Configuration/Administrative Template/System/Remote Assistance enable
Offer Remote Assistance and in the helpers field add users or group that will be allowed
to offer assistance. The users and groups will not be validated. Add the as:

domaingroup or domainuser

Format versus Quick Format

Q: What is the difference between Format and Quick Format when installing a Windows OS

A: The difference between the regular format versus the quick format is whether or not the volume is scanned for bad sectors using the chkdsk command. Both methods remove the files from the volume.

Microsoft Knowledge Base Article: Differences Between a Quick Format and Format During Windows XP Setup (Q302686)

Installing Applications on locked down server

Q: I am tryning to installa an application on a locked down server and I am getting the following error “The system administrator has set policies to prevent this installation”. I have probably locked down something I shouldn’t have…

Ansver: take a look under Computer Configuration / Administrative Templates / Windows Components / Windows Installer in GPedit. It could be that you have disabled Windows Installer.