Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fprovoste
Starting Member
5 Posts |
 Posted - 2008-07-04 : 17:24:58
|
| Hi, when i'm loggin to a SQL Server 2000 with user 'fred', and i create a table , the owner of the table is 'dbo', but when i create stored procedures, the owner is 'fred'. How could i make to 'fred' be the default user when i create a table?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 18:07:20
|
| Ues this:create table fred.tab (...) ... |
 |
|
|
fprovoste
Starting Member
5 Posts |
Posted - 2008-07-04 : 18:14:11
|
| from sql server management?, i think this could work from SQL Query analyzer :) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 19:42:46
|
| In em, you can specift owner when save new created table. |
|
|
|
|
|
|
Default dbo table owner when create