Found the answer on another site:

select DB_NAME() as Database_name, * from information_schema.columns

I figured out where I was having a problems when I was doing a lookup with sys.tables it was only bring back the second part of the name. So...

I am not familiar with using CTE. I usually work with an older version of SQL Server. I ran the SET script, it is showing the error:

Msg...

Rename Table '0%' to '02%'

So that all the tables in the database would have a number 2 in the name.

thanks for the code. Not exactly what I was looking to do

I want to able to specify a wildcard like

'O%' to '02%' can I do something like this?

Go what I needed (see below). Thanks.

select c.name,c.customerid,c.linkid

,case when c.linkid=x.linkid then x.orderitem end as orderitem

,case when c.linkid=x.linkid...

J to answer your questions:

can you actually see the relevant tables in SQL 2000 ?

do you have necessary permissions to access the table(s) we are asking you to document?

Yes I...

Unfortunately I think posting the script info isn't going to help much.

I see other people posting about select into and then Union all.

What I am looking to do is something...

What I was looking for was what Grant Fritchey finally posted.

As I mentioned I don't want to post everything for privacy reasons and I would now have to go back...

I am not sure if I posted my last reply in the correct area, so I am adding it in again. Thanks

Thanks for the info. Can I obtain some...

Thanks for the info. Can I obtain some of that info by looking at the properties of the database? It is SQL Server 2000 and I using Management...

I read Jeff's posting, especially the part about people posting for homework assignments or a job interview - neither apply in my case.

I am still somewhat new working with...

I wasn't sure you meant to post some sample data when you asked for

"'create table' scripts"

Here is an example of what I am currently getting and what I need as a result of the query:

I need to display not only the Name and CustomerID of...

Thanks for the feedback. I would post the data but for security reasons

I can't. Some of the items in the query have been changed as well for this...