INSERT IDENTITY syntax

Piece of SQL knowledge that I can't seem to keep in my brain...

SET IDENTITY_INSERT table ON

SET IDENTITY_INSERT table OFF


Now to Reseed the Identity column in a table


DBCC CHECKIDENT (table, reseed, newseedvalue)

Download Windows XP Reskit Tools

Download Windows XP Reskit Tools: "Download the Windows XP Support Tools (12.5mb)"

Provides the InstSrv.exe utility to add and remove services

How to remove damaged Windows Service

from url

I have successfully used this with: XP and 2003.

you can also use command prompt and delete a service using following command:
sc delete < SERVICE name>

or to create, simply type
sc create
Update:
If you have space in the file path you need to use quotation marks ("). For example:
sc create "MySQL" binpath= "C:\Archivos de programa\MySQL\MySQL Server 5.1\bin\mysqld.exe"

Map current folder location as a local drive.

@echo off
subst V: /D
subst V: "%CD%"
subst
PAUSE

VB6 Manifest File Follow-Up

Okay, it turns out following the advice in the previous post can produce a valid Windows 7.  Turns the problem was my version number in the manifest file did not match the actual version of the App.exe.  (Stupid stupid mistake).

So here is the manifest file I created. It was too much trouble to convert my manifest file (being XML to something that I can display in blogger, File is Manifest.txt in my BlogFiles folder on skydrive.