Yikes, way too much code for me to trawl through while doing my day job!

Leaving the function as it is, are you able to put the function call (only) in...

No - looks OK from what you've said.  Can you post more info (eg the stored proc definition) so that we can the help further?

OK - so have you run out of growing space?

Use EM if you really have to, but check out this thread first and maybe you'll not worry about it

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=98351

Doing this in T-SQL is non-trivial and not recommended.

Does look like a space problem - perhaps with the db itself.  Have you checked to see whether the 'Automatically grow file' property has been set (check the data file...

Seems to me that you might not have gone far enough in your normalisation quest.  I suggest that you should have something like the following tables:

Patient(PatientID, Name, DOB, etc etc)

AandEVisits(VisitID, PatientID,...

Check out this link for some ideas:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=146618

Yes - do you want to warn them first or just torpedo them?

Is the remote server running in 'mixed' mode, or using Windows authentication only?

(Right click the server in Enterprise Manager, properties, Security, Authentication.)

Regards

Apart from msdb, model, master and tempdb, what 'System' databases do you have in mind?

Regards

And I just joined the throng

This code does it in one pass.

declare @InsertParentID int

set @InsertParentID = 2  --or whatever value you need to insert

insert into table1(parentID, itemID)

select @InsertParentID, (select max(t1.itemID) + 1 from table1 t1...

You can also try

select * from child c

left join parent p on c.childID = p.parentID

where p.parentID is null

and see which is faster.

It was fixed in time for me to get it right

How about coming at this from another angle.  Could you write some script, or maybe an executable would be better, that creates a single spreadsheet containing the ~1000 records and...