Well, I'd love to say it would be that easy, but this solution has to be portable. Right now the development database is in SQL Server 2005, but the...

Joel...Jason...to-MAY-toe...to-MAH-toe...whatever works! 😉

Thanks for the replies guys...and Joel, whereever you are...!

Thanks, Joel - that does get me a little closer. I guess I need to figure out how to filter out the tables that don't connect directly to the...

I did in fact read the link and also ran the script in my DB, so I know that I can use it to get the info I need with...

When I look at that table (actually have to extract it from the dbo, since I can't see the dbo table (permissions)) I get this:

(column names = constid, fkeyid, rkeyid,...

Ok, cool...I will give that a look and a shot. Thanks!

Brad

BCP?

Thanks, guys. I can see that the cursor solution will be slower, so I will work on implementing it the CLR way. I'll give a shout if I...

Thanks, I will give that a shot and let you know the results.

On a similar theme...is it possible to run spell check of some sort on the data in a...

Hmmm...ok, I understand what you are saying in concept, but my experience here is probably more than beginner but less than intermediate, so I need more guidance on how you...

Here's a follow-on question - if the DB is ported to Oracle 10g will the same type of function still work, or is that something only available when using SQL...

Thanks, Matt..I'll look at doing it that way, after a quick read on CLR functions.

Ciao...

Brad

I'm not sure if there are DDL triggers, but at least I have things to look into. Thanks for the input. Not my database, but I'm becoming intimately...

Not that I'm aware of...I assume that would be in the triggers for the table? Not a SQL Server expert by anymeans, but if you give me a hint...

I find it runs ok on a database in my home office, too. I am at a client site right now trying to do this on their DB. ...