See http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=16594&FORUM_ID=23&CAT_ID=2&Topic_Title=Identify+Junction+tables&Forum_Title=General

Why don't you first import the complete table into a temp table and then insert/update into the real tables

Just confirming some of the comments made.

http://www.microsoft.com/sql/techinfo/tips/development/July23.asp

Think they are a bit stingy with SQL Server If SQL is not stressed it should release the memory if the box is stressed.

Lastly, adding more spindles...

Reminder: limit SQL max memory to 450 or 480 MB as leave memory for Windows/IIS/COM+, etc.

You may win on the network io transfer time but agree with mccork. Once enough memory then cpu will be too slow, etc.

Can you check the link please

Found another reference at

http://www.experts-exchange.com/Programming/Programming_Languages/Visual_Basic/Q_20413027.html

Talk about jumping through hoops to achieve something.

I only needs the bit upto

Public Function loggedusername() As String

Dim tok As Long

Dim ret...

Hopefully to to far of the mark and only a month late

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Junction]') and OBJECTPROPERTY(id,...

Thanks for the replies.

Phillcart I suspects if the service 'looks' at the environment variable for its thread/shell it will see SYSTEM. I will defnitely give it a try.

Frank thanks for...

Allen_Cui , a fairly complete answer.

Maybe raise an error explicitly in stored procedure 3 an check if the application handle the error correctly[?}

quote:

---

The other question i have is that in one of these tables i have an image in for a digital signature, but...

Informative article in BOL 2000 search on 'Using Partitioned Views'.

quote:

---

However, if the CHECK constraints have not been defined, the query optimizer must...

and finally the url

http://www.sqlmag.com/Forums/messageview.cfm?catid=3&threadid=19497