Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
USE [myDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[sbs_ClearAllData] AS BEGIN SET NOCOUNT ON; -- Clear out tables EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' EXEC sp_MSForEachTable 'IF OBJECTPROPERTY(object_id("?"), "TableHasForeignRef") = 1 DELETE FROM ? else TRUNCATE TABLE ?' EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL' EXEC sp_MSForEachTable 'IF OBJECTPROPERTY(object_id("?"), "TableHasIdentity") = 1 DBCC CHECKIDENT ("?", RESEED, 0)' -- Populate a couple of the tables. INSERT INTO myTable1 (Id, Code, Description, IsCredit) VALUES (NEWID(), 'D', 'Debit', 0) INSERT INTO myTable2 (Id, Code, Description, IsCredit) VALUES (NEWID(), 'C', 'Credit', 1) END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.