News Stay informed about the latest enterprise technology news and product updates.

Incipient wins fifth patent for storage technology

The U.S. Patent and Trademark Office, has issued a patent to Incipient, Inc., for its split-path architecture that performs block level storage virtualization – a core function within its Incipient Network Storage Platform (iNSP). The iNSP software suite is embedded in SAN switches and helps deliver network data mobility, network volume management and network copy services. Since October 2005, the Waltham, Mass. company has won five patents each covering key storage virtualization technologies that the company has developed. 

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

Hi Eli,
Thank you for this , it is really short and nice , I made a minor changes on the second stored procedure just to add more control on the hard-coded flag: Use Northwind
go
if exists (select * from sysobjects where id = object_id('dbo.sp_ConstraintState'))
drop procedure dbo.sp_ConstraintState
GO
CREATE PROCEDURE sp_ConstraintState
@TblName VARCHAR(128)
, @State BIT = 1
AS
DECLARE @SQLState VARCHAR(500)
IF @State = 0
BEGIN
SET @SQLState = 'ALTER TABLE '+ @TblName + ' NOCHECK CONSTRAINT ALL'
END
ELSE
BEGIN
SET @SQLState = 'ALTER TABLE ' + @TblName + ' CHECK CONSTRAINT ALL'
END
--EXEC (@SQLState)
Print @SQLState
go
exec sp_ConstraintState 'products',0
go
Use Northwind
go
if exists (select * from sysobjects where id = object_id('dbo.sp_disable_all_const_in_db'))
drop procedure dbo.sp_disable_all_const_in_db
GO
create proc sp_disable_all_const_in_db
@Bit bit=0
as
if @Bit=1
begin
exec sp_MsForEachTable 'sp_ConstraintState ''?'',1'
end
if @Bit=0
begin
exec sp_MsForEachTable 'sp_ConstraintState ''?'',0'
end
go

declare @Bit1 bit
set @Bit1=0
--set @Bit=1
exec sp_disable_all_const_in_db @Bit1
go
especially when use print instead of execute in the first stored procedure:
--EXEC (@SQLState)
Print @SQLState
--==================================
ALTER TABLE [dbo].[Employees] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Categories] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Customers] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Shippers] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Suppliers] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Orders] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Products] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Order Details] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[CustomerCustomerDemo] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[CustomerDemographics] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Region] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[Territories] NOCHECK CONSTRAINT ALL
ALTER TABLE [dbo].[EmployeeTerritories] NOCHECK CONSTRAINT ALL


Greetings,
Bahaa Fadam
Cancel

-ADS BY GOOGLE

MicroscopeUK

SearchSecurity

SearchStorage

SearchNetworking

SearchCloudComputing

SearchDataManagement

SearchBusinessAnalytics

Close