Hi All,

When I run the code as discussed in above posts, I get the error " Insert Error: Column name or number of supplied values does not match table definition."

@Opc.three & Lowell: Thank you so much!

I tried the second way but it gives me the following error.

Insert Error: Column name or number of supplied values does not match table definition.

Ok. Thank you!!

Have another question...

I want to insert results from sp_depends into a table

SET @sql = 'USE '+@db_name+' EXEC sp_depends '+ @table_name

insert into ##tmp

EXEC (@sql)

But with that I also...

Thanks a lot for your rely..it helped!!

Does it also applies if I have a tablename like ##temp1?

Thanks for the reply.

But I want to find the dependency of those objects which are not yet written in database.

Is there any way?