As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
No Answer is Posted For this Question
Be the First to Post Answer
What is the size of transaction log file?
what is the difference between Delete and Truncate
4 Answers CarrizalSoft Technologies, Geo Research Centre,
What do you mean by COLLATION?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
Can you explain what are commit and rollback in sql?
explain how to create a new schema in a database? : Sql server database administration
event classes in sql server
Difference between 2NF &3NF ?
Explain what is dbcc?
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
What is 2nf normalization form?
what is the main difference between constraints(like primary key etc..)& joins?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)