Hi Jeff, thanks a lot...

Now that you are talking something about the WLAN, when i execute this query in the local server the time is 1 second, but when i execute the query in other computer in another office loke 1kilometer from the server the time too bad!.....

thankyou Jeff!!!

this is my create

CREATE TABLE .[SubClasesMateriales](

[IdSubClasesMateriales] [int] IDENTITY(1,1) NOT NULL,

[IdClasesMateriales] [int] NOT NULL,

[NoSubClase] [int] NULL,

[NoTerminacionClase] [int] NULL,

[Subclase] [varchar](25) NULL,

[Descripcion] [varchar](1000) NULL,

[Lote] [char](25) NULL,

[Activo] [nchar](1) NULL,

[FechaSistema] [smalldatetime] NULL,

CONSTRAINT [PK_SubClasesMateriales] PRIMARY KEY CLUSTERED

(

[IdSubClasesMateriales] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [MAYALUMM].[SubClasesMateriales] WITH CHECK ADD CONSTRAINT [FK_SubClasesMateriales_ClaseMateriales] FOREIGN KEY([IdClasesMateriales])

REFERENCES [MAYALUMM].[ClaseMateriales] ([IdClaseMateriales])

GO

ALTER TABLE [MAYALUMM].[SubClasesMateriales] CHECK CONSTRAINT [FK_SubClasesMateriales_ClaseMateriales]