no i dont get any message.i am not trying to create for specific objects.

what i really need is a entity relationship diagram of the database that gives a whole overview...

so is there a way i can get the entity relationship diagram of a database?

They are sql server agent jobs that run in application server .they extract data or update data in the production server.So i want to know which databases of the production...

They are agent jobs.

Well i gave the command,

use msdb;

select * from sysjobsteps.

The subsystem column contained tsql for some jobs,cmdexec for some and SSIS for others.I was able to know that...

Hi ,

few jobs run tsql while few others are cmdexec or SSIS...i cheked the job scripts. the use statement only says use msdb...

I found few scripts which has the name...

Thanks..I checked the query but i get the database names to be either NULL or master database, i dont get the name of the user databases.

I want to know the...

Thankyou....