Meta Data Catalogue

I am wanting to set up some kind of metadata catalogue to manage
metadata records of the data we collect and create for my companies
clients.

I am thinking I want to do this using XML and SQL Server and have some
type of web-based browser to search for records.

Any suggestions on existing applications or resources that I could use?

ThanksHi

You may want to look at full text searching.

SQL 2005 has more XML functionality so check out the new features as it may
influence your plans.

John

"dharr" <darylh@.envisiontools.com> wrote in message
news:1123275095.936622.208720@.g44g2000cwa.googlegr oups.com...
>I am wanting to set up some kind of metadata catalogue to manage
> metadata records of the data we collect and create for my companies
> clients.
> I am thinking I want to do this using XML and SQL Server and have some
> type of web-based browser to search for records.
> Any suggestions on existing applications or resources that I could use?
>
> Thanks

Message Queue Task

Simple Question.

I have a requirement to read XML Messages from a Remote private MSMQ.

These messages are essentially Database records that will need cleaning up and insterting into a Local Database table.

Is this possible with SSIS?

Would Biztalk be a more suitable tool for this type of process?

If its possible, are there any resources taht can point me in the right direction?

Thanks for your help!

J.

That is what the Message Queue task is for, so it seems possible, though I don't have personal experience with using it to read a Remote private queue.

Message for Blank Reports

Sometimes there are cases where no records match the selection criteria. When that occurs, I want to display a message such as "No Data This Report". Preferably this would be where you would expect to see the first detail line.
I would appreciate any ideas on this. Thanks.If you call the report fron Front end, check whether there are records for the query used in CR. If there are no records then call the Blank Report which display "No Records Found". So you have to have two records; one actual report and other one is dummy|||Tried it and it works great. Thanks a bunch!

Merging two tables

SQL 7
How do I merge two table's records? In other words, merge
T1 into T2. There are records in both tables that are the
same, but where T1 has a record that T2 doesn't have,
T1's record needs to be inserted into T2.
I've been reading Join syntax til my head is spinning.
Thanks,
DonInsert into T2
select * from T1 where T1.PrimaryKey
where T1.PrimaryKey NOT IN (Select PrimaryKey from T2)
Replace PrimaryKey with the unique priamry key from each table.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Don" <anonymous@.discussions.microsoft.com> wrote in message
news:7ff101c402df$8f68d030$a101280a@.phx.gbl...
> SQL 7
> How do I merge two table's records? In other words, merge
> T1 into T2. There are records in both tables that are the
> same, but where T1 has a record that T2 doesn't have,
> T1's record needs to be inserted into T2.
> I've been reading Join syntax til my head is spinning.
> Thanks,
> Don
>|||Don,

> How do I merge two table's records? In other words, merge
> T1 into T2. There are records in both tables that are the
> same, but where T1 has a record that T2 doesn't have,
> T1's record needs to be inserted into T2.
insert T2
select * from T1
where not exists (select * from T2 where T1.keycol = T2.keycol)
Linda