Venkatesan's solution will work if you have fixed rows with fixed values. It will also require an extra step beyond what he wrote up to concatenate the list.

This will...

The code that calls the UDF: Is that a proc? Something else?

I've had problems getting SQL 2000 procs to distribute transactions with SQL 2005. My solution has been to move the proc to the 2005 server and make it do...

The best thing to do is set up a service account that you use for that kind of thing.

The only data you have is what's in the transaction log. That should give you what you need. Get a log parser (www.apexsql.com has the one I use),...

If the database was restored from a backup, or if someone manually changed the size, it can end up being whatever size it was at that time. Also, if...

You're welcome.

Those aren't the easiest things to deal with. And it's just barely "not a cursor" even this way. I just can't think of any other way to...

Yes, you can escape/replace the XML characters. But again, you're adding more code to accomplish the same thing. It just comes down to, do you want to have...

On suggestion: Set up a database you can play around in.

I have a ProofOfConcept database in a copy of SQL 2005 Dev Edition, running on my desktop machine.

When I run...

Did you look at the compare/diff products I suggested? Those might do what you need. Might not, but probably worth a look.

Venkatesan Prabu (7/30/2008)

File groups are used to enhance the performance and also domain wise you can group the tables like consider am having a company database. Here employee related information...

;with Hierarchy (ItemID, Item, Parent) as

(select ItemID, SubItem, null

from Table1

union all

select hierarchy.itemid, table2.childitem, table2.parentitem

from table2

inner join hierarchy

on table2.parentitem = hierarchy.item)

select *

from hierarchy

Of course, there's always the really easy way to tell the number of CPUs on a server, when you want to license software for it.

Pop open the box and look...

Simple, single-table CRUD done by Linq or nHibernate or whatever, is fine by me. I've seen the SQL code generated by these kinds of tools for anything more complex...

Glad it worked. I've made that same mistake. Not an easy one to catch.