If you don't know the exact characters then you can use their ASCII values to find & replace.

Hope this will help.

Yes i was refering to C2 auditing only.

thanks Karl for explaning.

If auditing is enabled on the server then, you can find the id from there as well.

This May help you.

http://www.sqlservercentral.com/columnists/dpoole/sqlandiisonthesamebox.asp

This code will give the list of child tables and master tables.

SELECT object_name(fkeyid) AS child

 ,object_name(constid)AS FK

 ,object_name(rkeyid) AS master

 FROM sysreferences

WHERE object_name(fkeyid) IN ('<TABLE_NAME>,<TABLE_NAME>,<TABLE_NAME>,<TABLE_NAME>,...')

 OR object_name(rkeyid) IN ('<TABLE_NAME>,<TABLE_NAME>,<TABLE_NAME>,<TABLE_NAME>,...')

ORDER BY 1

It may be possible you can try that...

This is the best way to do it.

if you want your query should be dynamic then you have to write a sp useing cursor in it which will be real pain...

Check this out this may help you.

CREATE TABLE t1 (a int, b int, c int,d int )

INSERT INTO t1 VALUES(1,NULL,NULL,NULL)

INSERT INTO t1 VALUES(NULL,1,NULL,NULL)

INSERT INTO t1 VALUES(NULL,NULL,1,NULL)

INSERT INTO t1 VALUES(NULL,NULL,NULL,1)

select *...

You can get the file locations from the following command.

sp_msforeachdb "use ? ;select name,filename from sysfiles "

It's not possible to get the procedure back after dropping it from the db because it deletes all the entries from the db related to that sp.