Tried that to change numeric (16,0) still same error .

problem passing output as select @student id = @@identity if I coment it it works fine without error. Looking for workaround...

It is user definition with Uniqueid(numeric(16,0) and passing as output still seeing this error.

@studentid defined as uniqueid which is numeric - I'm thinking it is problem with excceding the length of value causing this problem .

Jeff - It is uniqueid datatype

Try your query by removing distinct

I'm looking creating database using analysis service not diagram

No I'm looking for script to find procs in the database based on indexes. For example I have index idx_foote need to find which proc is using it.

I'm looking for scirpt which gives list of procs used by indexes. I have bunch of indexes need to find procs used by them

Thanks for your suggestion Jeffrey. You are right it works great for table by table process. I want to add new rows based on primary keys in database A...

this is only one time I need to sync up some table data between database A and database B. Backup and restore will not work in my case. That way...

Hi abair34,

Based on ID field which is primary key in the apps how I do I browser all the tables in Database A and Add missing rows in all...

Thanks Micheal for quick response. Last question what is the statement

number = DIFF.number in the code I belive it is ID field in my table A vs ID...

Thank you Garadin for your quick note.

Micheal thanks again for clarification! If there is no difference row between table A and table B I want to stop loop there without doing any updates. can...

Micheal thanks for your note.

what is SET Source = DIFF.source

, number = DIFF.number in your statement?

Bascially I'm looking for compare table A and table B and update table...