Add program to startup programs in windows xp home

To add Windows Task Manager (or any program) to your Startup folder (that will make it work each time you start the windows and you will see it in the system tray), please follow the below instructions:

1. Click Start>Programs, then right click on Startup folder and choose Open.

2. On the Startup window, go to File menu and choose New>Shortcut.

3. In the dialog box click the Browse button to specify the Task Manager program, it's by default at C:\windows\system32\taskmgr.exe (Where C is the partition that your windows XP is installed on).

4. After specifying the program path, click next and finish. Then you will see a new shortcut (computer icon) in the Startup folder.

5. Right click on that shortcut and choose Properties, select Minimized from the Run combo box, and click Ok, then close the Startup folder.

6. At the next time you start your computer the program will run automatically and you will see it in the system tray.

How to Disable Internet Options in XP

1

Open the Windows XP Group Policy Editor. Go to Start, click on "Run," then type "gpedit.msc" into the search field and click "OK."

2

Remove Internet Options from the Control Panel. Under "Local Computer Policy," go to User Configuration > Administrative Templates > Control Panel, then click "Hide specified control panel applets" in the right pane. Click "ENABLED," then select "Show" and click on "Add." Type "Internet Options," then click "OK."

3

Remove Internet Options from Internet Explorer. Under "Local Computer Policy," go to User Configuration > Administrative Templates > Windows Components > Internet Explorer > Browser Menus, then double-click "Tools menu: Disable Internet Options menu option" in the right pane. Select "ENABLED," then click "OK."

Recover Database from Suspact Mode

 EXEC sp_configure 'allow updates', 1
RECONFIGURE WITH OVERRIDE
GO

BEGIN TRAN
UPDATE master..sysdatabases
SET status = status | 32768
WHERE name = 'Munim001'
IF @@ROWCOUNT = 1
BEGIN COMMIT TRAN
RAISERROR('Emergency Mode Successfully Set', 0, 1)
END
ELSE
BEGIN ROLLBACK
RAISERROR('Setting Emergency Mode Failed', 16, 1)
END

DBCC REBUILD_LOG('Munim001','D:\MSSQLDATA\Munim001.ldf')
--ALTER DATABASE 'Munim001' SET MULTI_USER
alter database Munim001 set multi_user with rollback immediate
DBCC CHECKDB ('Munim001')

Here are the steps (without details):

   1. Rename existing .mdf file to .mdf_old
   2. Create a new database with same .mdf and .ldf file as old one.
   3. Stop the sql server
   4. Rename .mdf and .ldf files of the new db to .mdf_old and .ldf_old
   5. Rename .mdf_old to .mdf
   6. Start sql server
   7. You should see db in suspect mode
   8. Change the database context to Master and allow updates to system tables
   9. Set the database in Emergency (bypass recovery) mode.
  10. Stop and restart SQL server.
  11. Rebuild the log.
  12. Set the database in single-user mode and run DBCC CHECKDB to validate physical consistency.
  13. Turn off the updates to system tables.

link|flag


Query Example


Sp_configure 'allow update', 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = 'Munim001'
go
Sp_configure 'allow updates', 0
go
Reconfigure with override
GO

DBCC REBUILD_LOG('Munim001','D:\MSSQLDATA\Munim001.ldf')

sp_resetstatus 'munim001'