Man, today I looked everywhere on the world wide web to find a simple "how-to" to change table ownership with Enterprise Manager and found ziltch!!! Oh yes, I found all kinds of fancy stored procedures but again Microsoft's intuative approach, or lack there of, to simplify things left me with nothing. I had to ask a fellow developer how to do it and this is how without using a stored procedure.

1. Open up Enterprise Manager.
2. Open up the database and get a list of tables. In the list, you should see NAME, OWNER, TYPE, CREATE DATE. The owner by default when a table is created is dbo unless you login as that user.
3. Right click on the table you want to change the owner of and click design table. (Not properties)
4. Another tool bar will show at the top, right below the list of menus. Click Table and Index Properties (A Square White Box).
5. This is where you can change the ownership (provided you have other users).

Please note: This is different from permissions.

Chris

Ah, I just purchased my first SLR camera and I can't wait to use it. I've got some ideas for photography but we'll see how good I am or "not". More than likely not. Anyways, I believe it's important to have for any serious website designer. You never know when you'll be taking pictures of products, store fronts, etc. and it's just good to have for quality pictures.

This camera should be here by next week...oh and by the way Amazon.com has a great deal on them right now. Got everything I need (for now), for a little more than $800. The original price was over $1500 with all the accessories I got.

Some of the components that were bought are:

Great reviews and probably more camera than I need but hey a business has to grow sometimes and besides I'll have fun with it.