What all db objects can be found in MSDB database of a SQL
Server instance?
Answer Posted / suri
select * from sysobjects
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is raid and what are different types of raid configurations? : Sql server database administration
How to retrieve field values using mssql_result()?
Is it possible to replicate data from sql server to oracle? : sql server replication
Give an example of why you would want to denormalize a database
what are user defined datatypes and when you should go for them? : Sql server database administration
Explain indexed views and partitioned view with their syntax.
What do you mean by the term 'normalization'?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Explain primary key, foreign key and unique key?
What is the need for indexing?
What are the database roles? : sql server security
What is outer join in sql server joins?
What is unpivot?
How to drop existing indexes in ms sql server?
What is the use of stored procedure?