October 30, 2009 at 7:57 am
Hi and thank you in advance.
My environment is
1 SQL SERVER 2005 which I will refer to as server sql2005
1 SQL SERVER 2000 which I will refer to as server sql2000
Sql2005 has a linkserver connection to sql2000.
From Sql2005 I'm running the following:
3 Declare table statements and
INSERT INTO @Table1
EXEC sql2000.db.dbo.sp_Get1
INSERT INTO @Table2
EXEC sql2000.db.dbo.sp_Get2
INSERT INTO @Table3
EXEC sql2000.db.dbo.sp_Get3
No errors are encountered.
The problem is that the 3rd INSERT INTO takes about 1 mminute to execute. If if run "EXEC sql2000.db.dbo.sp_Get3" by itself it executes in 1 sec. Also, the third statement only returns 50 records. This is a very trivial issue.
Has anyone encounter this issue before? Or can point me on away to troubleshoot this issue.
Thank you,
October 30, 2009 at 9:22 am
There's really not enough information here for us to do anything with. Take a look at this article that Gail wrote:
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
October 30, 2009 at 12:09 pm
Thanks for the reply. I read the article I'm not sure what other information is needed.
I thought it was very straight forward that the INSERT INTO was the problem.
1.- Included
2.- DLL 3 tables, each with 2 columns
3.- Not Applicable. When the procedure is ran with out the INSERT INTO in only takes 1 second to run
4.- 100 Rows MAX
5.- Without "Insert Into" 1 second. With "Insert Into" 1 Minutes
6.- Can't create an execution plan with syntax I posted, is not a query..I'm missing something?
Thanks again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply