Thanks.

Thank you very much.

Thank you very much.

Great idea. Thanks.

Have databases where I don't know which tables are being used and what not. So what I want to do is which ever table I think is not being used,...

Adding brackets around "[?]" was a common sense and I am missing it. Thank you very much.

It is working and it is now creating the files. I have not made any changes since yesterday and this morning it is working and i have no clue why....

The trace is running but it does not create the file.

I have resolved my own question and here it is:

sp_msforeachdb 'select ''?'' AS DBName,Routine_name, routine_definition from ?.information_schema.routines

order by routine_name'

This is what I am running on SQL 2005 which displays each database name, stored proc name and stored proc definition for each database on the server: How do I...

That worked, Thanks.

but that does not give me database name.

Made a mistake. The last one did not work. What works is the following, but I also need database name with it. ANY IDEAS???

EXECUTE sp_msforeachdb 'select s.*, p.*

from ?.sys.sql_modules s

inner...

I found it myself and it is:

EXECUTE sp_msforeachdb 'select specific_catalog, specific_name, routine_definition from information_schema.routines'

Can you please show me the command that i need to pass to sp_MSForEachDB?