hi,

please understand MS SQL are capable software for DBA related activities.

1) if you want table structure from query anlayser:

syntax :

sp_helpdb 'table_name'

2) if you want table structure from enterprise manager:

->...

CM,

r u understand or not?

IF any doubt, first check on test DB enviornment & go on live sever.

i think, this is proper solution as per my knowledge..

Ankit,

this is problem for which table data imported to destination table.

becoz this is datatype are not same or column name are difference.

first check,

1) both tables datatype & data size...

Ankit,

this is problem for which table data imported to destination table.

becoz this is datatype are not same or column name are difference.

first check,

1) both tables datatype & data size...

hi,

first check, how many trancation going on per min. & assign log file growth.

second, how frequent log file growth pattern & those log are important are business or not,

third, dont...