HI all,

Well the point of discussion is to have a script by which i can get all the column name and table name in a db where the data length...

Cadavre (1/9/2012)

---

Untested, but something like this should work

BEGIN TRAN

DECLARE @sql AS VARCHAR(MAX)

SELECT @sql = COALESCE(@SQL,'') + 'SELECT ' + c.name + ', '''+c.name+''' AS columnName FROM...

because in our db there are table with wrong datatype.So i wan to find it by this means to complete a task

yes exactly i want all the column name and table name where value is 9 character

hello plz answer if u know or plz let other to answer

mrdenny can u send me the script

i don't know the table name and column name So this query will not match my requirement.

i don'nt know the table & column

i just want to find table name and column name where data len = 9

can any one ping the script PLZ

hi u mean by using DMV query can u just Send me the query so that i can go through it and find the query

yes u have .thks for ur suggestion.

thnks i just want to know is image datatype can we used in any compare condition or not.

so we can not have compare condition in image datatype column

The Solution which i found out is

Script the both Pk table And FK table and drop those table and recreate it with one shot .As for this there is...

i can do it but

If i have a foreign key related to My Primary key how can i do it

and i don'nt have data in those table it...

just use sql server agent job to do it

very simple

Can u send me the entire query to genrate the script