Just another thought Matt...

Your code could 1st check for the existance of the Link Server entry, then if it's

not yet there, create it and leave it.

-- In SP A...

Create Table Table1 .....

-- From SP A

INSERT INTO Table1 (col list)

EXEC SP_B

-- as long SP_B's has

1 result

Just steppin' in for "offline" Rawhide....

The link server entry remains in existance until DROPed.

Any subsequent calls to the server from other sources

will have access to this Linked server while it...

What I sometime do....

IF 1=2 -- only line added to make next statement NOT execute

    SELECT ......

IF condition statement [ELSE statement]

works only for 1 statement and does not require an...

Views based on a single table are no problem.

I've not ever attempted to even try to delete from view where the view was comprised of 2 or more tables.

Be intrested...

INSERT INTO tblMechanicJobType (mechanicId, jobTypeId)

SELECT Mech.mechanicId, JobT.jobTypeId

FROM tblMechanic Mech

CROSS JOIN tblJobType JobT

[WHERE whatever]

Not tested, just written....

SELECT *

FROM [ContactTable] CT

WHERE contactd_id IN (

     SELECT contactd_id

     FROM [ContactTable] BestRecsID

     JOIN (

               SELECT contactd_contactmid, MAX(contactd_status) as High_contactd_status

               FROM...

Any other ideas folks?

Thanks in advance.

Thanks for input folks...

Rawhide, as soon as the error occurs, any subsequent SQL statements do not get executed

so as is, I can not...

....What do you try to achieve by lower the status of the error?

status = severity

No Server Event Log entry or Job Failed status for the customer to "complain" about.

Any SP Statements...

I appoligize

Das neste mahl schribe ich es in Duetch.

"Should leave enough room for expansion"...

Only if we purge Frank's posts every so often

Manny, it's a security issue.

I know it's not exactly the same, but chack out

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=93674#bm93678

Or in addition to what Rawhide wrote,

SELECT .. Into #TempTable FROM ....

then maybe even CREATE [CLUSTERED] INDEX ... on #TempTable ()

Then use #TempTable...

Interesting. How much faster? Slightly, or realy worth looking into? etc?