how to change owner for many tables

sorry to be dumb!
i have a whole bunch of tables with me as owner - i want to make dbo owner.
how?
i just can't find an appropriate mouse click in enterprise manager, and i don't really want the 40 command lines to do it manually.
thanks for ideas, izyNo bulk way that I know of in Enterprise Mangler.

So we are reduced to being deviant... Er, devious. We use a script to write a script!SELECT 'EXECUTE sp_changeobjectowner ''[' + su.name + '].['
+ so.name + ']'', ''dbo'''
FROM dbo.sysusers AS su
JOIN dbo.sysobjects AS so
ON (so.uid = su.uid)
WHERE 'izy' = su.name
ORDER BY so.nameThis will create a script as its output that you can copy into query analyzer, exectute, and go merrily on your way.

-PatP|||big gulp!

Pat - thanks: that's really scary but i'll give it a thrash and see what falls out of the tree.

izy|||purrrrfect.

thanks a lot, izy|||See, it helps to have deviant... Er, devious friends!

Thinking "outside the box" is a bit difficult at first, but the dividends can be huge. I keep wondering "What box?" whenever I hear that phrase though!

-PatP|||See, it helps to have deviant... Er, devious friends!

Thinking "outside the box" is a bit difficult at first, but the dividends can be huge. I keep wondering "What box?" whenever I hear that phrase though!

-PatP

Boy that is such an opening...nah, better not...|||Boy that is such an opening...nah, better not...Allright! Where have you put the real Brett ?

-PatPsql

how to call Excel file in SSRS

Hi ,

I have one report in SSRS , in my report I have one table that display severel links,

and when I click in one line in the table I want to display the Excel file linked to this line.

exemmple :

Line1: Report Balance

Line2: Report Statistic

.....

and When i click on the line1 it will call one Excel file called RPTBAL.xls

Thanks for your help

Where are these Excel files? On a web server? If so, you can add a hyperlink expression that points to the Excel file for each row.

You can't add them on an entire row but you could add them on all the textboxes in the row. You can also make the hyperlink dynamic based on the content of the textbox. That way each row could point to a different file.

|||

Thanks for your eplay , is correct and I tested it and it works fine,

but each time it gives meesage when I call this Excel file , so please you have solution about this , to don't ask me in each call ,

I have the same problem in sharepoint when I call Excel file it dispay message before to open the file .

Regards