July 23, 2004 at 1:23 pm
hi, everybody I have the next view
I'm in database1
CREATE VIEW dbo.myview AS
SELECT *
FROM database2.dbo.mytable
when I to insert a record in mytable through myview i receive the next error message
[Microsoft][ODBC-SQL Server Driver] Timeout expired -2147217871
Please what settings or what's wrong in this.
July 23, 2004 at 1:33 pm
Hey,
Are you able to do a SELECT on the view such as:
SELECT * FROM myview
Just taking a guess here:
I'm thinking that maybe mytable in database2 might contain computed column(s) that are taking a long time.
To check for this, open mytable in Design view from SQL Server Enterprise Manager and see if there are any columns that have calls to user-defined functions and identify which one(s) is/are taking a long time.
Hope this helps ...
JP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply