select * from sysobjects

What all db objects can be found in MSDB database of a SQL
Server instance?

Question Posted / suri

Answer Posted / suri

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is raid and what are different types of raid configurations? : Sql server database administration

975

How to retrieve field values using mssql_result()?

1186

Is it possible to replicate data from sql server to oracle? : sql server replication

1034

Give an example of why you would want to denormalize a database

924

what are user defined datatypes and when you should go for them? : Sql server database administration

961

Explain indexed views and partitioned view with their syntax.

1077

What do you mean by the term 'normalization'?

1127

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

Explain primary key, foreign key and unique key?

934

What is the need for indexing?

887

What are the database roles? : sql server security

1075

What is outer join in sql server joins?

1045

What is unpivot?

968

How to drop existing indexes in ms sql server?

1014

What is the use of stored procedure?

893