Listen guys, I apologize for getting uptight. Maybe you guys do things different here by laying out the whole playing field when you post code, but the snippet I provided...

My code clearly illustrates...
@db_name + '.dbo.syscolumns
Anyone with eyes can see it and any sql developer can figure out how to apply it to their setup. 

How is it  that you know how you would do it when no one else in the whole sql world...

Lyle, 

I'm sorry you don't understand that this is a hypothetical example. There is no schema except that which the viewer chooses. Variables such as my_database,  my_table,  and my_column are clearly placeholders where one can simply swap out to match their schema. Nothing more. 

I didn't feel it was necessary to include code for creating tables and inserting records, as that was not the object of discussion.  I think most people would...

Not sure exactly what you are getting at.  This is an ad-hoc process  that can be used for any schema with minimal tweaking. Schema is relative. The user has asked for an example of how the functionality can be performed. It is only an example.

Are you implying that there is no value to the process? If there is value, but you have an improvement to propose, feel free to add to it. 

This is what the forum is about is it not? Or is it just for criticizing. If so what's the use. 

J Livingston,  I hope it can help you with your issue.

Code as requested. A little crude maybe, but it's not a Mona Lisa.

============================

/*==================================================
Stored procedure from procedure database
==================================================*/

CREATE...

I already did. 

"I did run across the thread searching for the same thing for an old mssql 2000 box. I ultimately created a single procedure on one db that could...

Wow, triggered again.

Calm down now Jeff. Don't be triggered yourself. I was only joking will the "Comprende" comment and it wasn't directed at you.

Time and time again, I run across posts where someone asks a specific question and everyone has to question the person's  motives rather than answering the question. This was no exception. If there were other ways to perform the same feat,  there wasn't much dialog about it.

I did run across the thread searching for the same thing for an old mssql 2000 box. I ultimately created a single procedure on one db that could be referenced from another, passing the requesting db name...

I know this post is seven years old, but because I was triggered by all the lame responses given that didn't even address the question, I had to sign in...