yea what is wrong with the good old insert without triggers?

openquery uses linked server , i don't understand what you mean by it executes faster than linked server

ref BOL:

OPENQUERY ( linked_server ,'query' )

did u use a query execution plan to see where the query is taking its time?

you do a comparison of the windows logins on sql again a txt dump of the logins in AD to see which ones no longer exist

you could have used a UDF that returns a table with the values you want. I assume you first insert the values , and the user id then run your...

how are you using the temp table. is it a multi user app?mmm...

can you post your script?

what is the error message you were getting, please give more info

which reporting tool are you using?

can you post your script? both the sql and the vb (only where you are calling the stored proc)

you might be able to get round the problem by using dynamic...

whats MX and MC

i have used redgates sql compare, and its very good. you can download a trial copy which expires in 15 days, do your tests and convince your bosses to buy...

developers with mobile computers (including home computers) should never be allowed to have a copy of any corporate database whatsoever if the db has any live data.

they can have a...

i am not totally understanding your problem, but can you post a sample of your vendor ids.

can you also give us more info on the vendorid creation scheme

did you try

CREATE

LOGIN [someUser] WITH PASSWORD = passwordHash HASHED