Hi Team,

I compared user defined datatype (activeflag , binaryflag and editstamp) again with sql server 2005 and sql server 2008,

In the Sql server 2008 the sp_bindefault and sp_bindrule missing,...

Hi,

Thanks for your reply, as i don’t have sysadmin role, i am not able to open the sql profiler.(I don’t have sa password).

Below are the exact table and view structure.

NOTE:

When...

Hi,

I drop the view and recreated using schema name in the view, still facing same issue.

USE db1

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE VIEW [dbo].[test] AS

SELECT id,mnc,desc,act,type,t_editstamp FROM db2.dbo.test

Hi,

I recreated the view and inserted the record, still same error occurs.

the problem i found is in mnc field (char(10)), when i just run

INSERT INTO dbo.test (mnc) values ('ddd')

USE...

USE db1

GO

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

CREATE VIEW [dbo].[test] AS

SELECT*

FROMdb2..test

Note: In db2 database actual table structure created.