with sql2k sp3 one can have Cross DB Ownership Chaining.

If I'm correct, this way you can avoid to have to authorize sp-users to the other db unless you encounter...

I have done some testing now.

The problem is that the select which is done to perform then insert, is performed before the actual insert is being done.

This way your new...

Regarding the DRI problem :

Do you upload an new set of parent data with as well the old as some new data ?

if yes :Why not only bulk-instert only the...

IF [is your sp3 on a multi-processor box ? ] = 1

begin

    if [Is it a sql2k standard edition ? ] = 1

       begin

            if [did you apply the...

maybe just perform the select so you can detect and verify the duplicates

How about avoiding the udf and using this select ?

SELECT rs.EmployeeID, rs.School, w.WorkDate

, isnull((select max([counter]) + 1

FROM SchoolServices

WHERE EmployeeID = rs.EmployeeID AND School = rs.School AND ServiceDate = w.WorkDate...

sorry for the delay.... been out for the long weekend

Like Bob Monahon replied : this query...

just to add ..

you can use Alter view . BOL : Alters a previously created view (created by executing CREATE VIEW), including indexed views, without affecting dependent stored procedures or...

- tripple join

or

where with exists-clause for each condition

e.g.

select *

from myself T1

where exists (select * from myself where id = T1.Userid and...

AFAIK this is not possible with sqlserver, unless you use partitioned views. i.e. create a table per partition, manage each table's indexes according to the specific tables needs and create...

this what I use with VB6 sqldmo :

I hope this can help sort things out

Private Sub ScriptJobs()

    On Error GoTo ErrorHandler

    strStatementId...

just my 2 ct

- Why use a count(*) if your functionality is 'if exists '

- case yourcol when 0 then ...

                     else yourcol

                     end

are you member of the sysadm-sqlserver-role on the instance where it fails ?

DECLARE @MaximumDate  char(8) ?? Why not use smalldatetime ??

Is MaximumDate in the table/view also defined char ?? if yes,you'll have to take care of it's format...

We use this T_TableLoadData in a way that we record if data is being loaded (loading_bit = true) and all applications querying the data will use a view which has an...