but they handle?

SQLDMO works with SQL Server 2005? that's the question:)

I understand from what you say that sqldmo works with named instances in 2000. Maybe it works with 2005 too?:)

You...

I'm using C#, and the documentation for DMO is prety difficult to understand for my level...:D, I haven't searched enough, I admit

I' managing with SQLDMO , not very good but...

and..another question about SQLDMO...

I see everywhere that is for SQL Server 2000, but I'm using it for 2005.

It can see may server and my SQL Server 2000 databases.

Is there any...

Ok

It seems that this is the only solution...

I need to use it in 2005...so I will try your way

Thanks

I used SQLDMO because there in my way to my solutions I descovered it , and it was a easy way to find servers, to script objects in db.

I know...

I supose it also removes the ones that aren't also...because if a server is really stoped and you try to connect, what happens?

So it's better to keep them in a...

Thank you for your answers ..I will try to use what you posted, and sorry for the way I posted...

it's the last time....I promise :D:)

person

(

person_id,

first_name,

last_name,

adress

)

person_report

(

id,

person_id

report_date,

report_id

)

reports

(

report_id,

report_xml,

report_number

)

report_type

(

report_type_id,

report_name

report_number

)

person:

1 john john xy_adress

2 jane jane yy_adress

person report:

1101.01.20091

2101.01.20094

3201.01.20095

4201.01.20097

reports are like :

1 xml_text 2,

2 xml_text 4,

report_type

1report_x1

2report_y2

3report_z3

and for a person I want to extract...

I should be kicked a little for the way I posted 😀

I will write the tables and the desired output

because i don't know other way.... I haven't found other solution

I have to take the first raport from that table that respects the conditions...

so, I have to check every one...

sorry

I have a parametric table with reports (id int, report_name varchar(30))

For those reports I will get from other table lots of information in a stored procedure in this way :...

and another question....is there an important difference between SQLDMO 8.0 and SQLDMO 8.5, especialy on the sql server detection and manipulation...?

The documentation is poor...so I ask you....

I've searched on the...

I asked the owner of the second computer to try the aplication again and to look at the databases it returns. the (local) databases are stored in MSSQL\Data, and the...

Yes.I have a named instance.but it only shows me the name of the instance when I have the network cable, when I'm in the network.When it is removed the only...

I want to compare...tables,sp, views, etc

After that I want to go back and take the name and the create string I build and use it

So , yes, I will need...