RSS

Monthly Archives: August 2012

Reseting Identity Values for All Tables

USE DATABASE;
EXEC sp_MSForEachTable '
IF OBJECTPROPERTY(object_id(''?''), ''TableHasIdentity'') = 1
DBCC CHECKIDENT (''?'', RESEED, 1)'
GO

IF you want to make it Cursor Follw me on this Link

https://mostafaelmasry.wordpress.com/2011/11/30/reset-the-identity-coulmn/

 
Leave a comment

Posted by on August 23, 2012 in Script

 

Enable Network Discovery Server 2008 R2

Problem

When you try to Enable Network Discovery in Server 2008 R2 After you have enabled this it simple turns off again so you need to enable the following services

Services you must enabled it before enabled Network Discovery :

1- DNS Client

2- Function Discovery Resource Publication

3- SSDP Discovery

4- UPnP Discovery

The ways to Enable this Services :

Way No 1

Open Run then Write CMD then Write this Statment

  • net start “DNS Client”
  • net start “Function Discovery Resource Publication”
  • net start “SSDP Discovery”
  • net start “UPnP Discovery”

Way NO 2

Open Start Menue / Administrative Tools / Services / Then Select your Serives

 
Leave a comment

Posted by on August 17, 2012 in Network