Hey Paul, that query is really great. I can use that.

I am going to modify it a bit to also allow one to give the column name, and list all...

Me too, I like that poster. You used to be able to order it from MS, and they would send you the poster. Not any longer it seems, I did...

It would be much easier of you perform this task after the table is loaded, then you have a simple update statement.

Then all you have to do is write a...

I found this link that you can download the map for SQL 2005, there is also a link for SQL 2008.

http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=2ec9e842-40be-4321-9b56-92fd3860fb32&displayLang=en

That will help me I am sure, now that I...

Hey Paul

I would like only the Primary Keys table.columns and their related table.column

So one primary key table.column may have 1 or many related table.columns

Thanks

Andrew SQLDBA

Paul

That query is great, but I would like to see all the other tables and columns that those are related too.

I have so many tables in this database, that I...

Paul

I was not referring to your query. I have not tried that one yet. You posted that while I was typing my last post.

Let me work with that one for...

That one is close, but I would like to know, what the other table name and column name for each primary key listed in the query.

Also, how do you make...

Any command that you can run from the command line on the server, can now be ran in that stored procedure, or query. They can go as far as taking...

Actually, it is a SQL 2000 database that I took the backup using SSMS, instead of SQL EM. I would not have thought it would have made a difference, but...

Well, it depends on ho many rows and columns are in both tables. You are using an astrick, You should never use that. Always name the columns that you want...

Why is it that companies never want to spend money on the backbone of the company. How long do you think a company would survive with no data? Ask them...

Sorry

I meant to type 2005. My mind is not working well today.

Andrew SQLDBA

Question that I have....is why would you ever allow a user to modify in any way, the DDL?

You need to remove all permissions for that.

Unless you have some type of...

try using MAX and MIN functions????

Maybe I am making this too simple, or do not understand your question.

SELECT MAX(<ColName>), MIN(<ColName>)

FROM <TableName>

WHERE ??????

Andrew SQLDBA