Try using an output parameter with datatype "cursor".

Then you can process the cursor and put the rows in a table once the procedure returns.

Gabriela

Yeah, I think that BOL is pretty clear.

Thanks all for your inputs.

Gabriela

This seems a little more compact too me. The only problem might be the undocumented sp_msforeachtable. If the database has a lot of tables and idexes could be a little...

I did a little research on this forum last night and it seems I found my answer in a posting sometimes in February 2004. The below code will to the...

Thank you all.

Gabriela

If the business logic is the one you wrote in your last post, try something like:

declare @txt varchar(255)

set @txt='MAPI:{Jones, Doug}EX:/o=Company Name/ou=Data Center/cn=Value/cn=dojones'

select charindex('/cn=Value',@txt),

(substring(@txt,0,charindex ( '/ou',@txt)))

+'/ou=Data Center/cn=Recipients/cn='+

+(substring(@txt,charindex ( '/cn',@txt,charindex('/cn', @txt)+1)...

It helped, thank you very much.

Gabriela

create function fn_splitstring

(   @strings varchar(255)

)

RETURNS @T TABLE( col1 ....)

AS

BEGIN

... you function here

END

and then call it with:

select * from <user_name>.fn_splitstring(<some string&gt

where <user_name> is function's owner...

What's DBCC DEFRAGDB?

Thanks for the link, I just read that before I posted my question. It seems that I did all as described in the article but @@servename shows NULL instead of...

Thanks. LogParser works fine.

Gabriela

And yes, both databases use the same collation

Here is the stuff. I hope I didn't mess it up when I renamed the fields. I isolated the remote side in the inner query because when mixed with the local...

Thanks, I was thinking about parsing the name, but who can stop me to explicitly call a PK with "PK__TABLE__AA23456FF"? Looks like one generated by the system, but is explicit....

I think I wasn't very clear in what I want: I do not want a list of all constraints in the database, but a list of those that were generated...