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


Please Help Members By Posting Answers For Below Questions

What is use of attributehierarchyenabled? : sql server analysis services, ssas

609


How do you make a trace?

583


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

556


What is default constraint in ms sql server?

536


Do you know what is lock escalation?

580






what are the new features in SSRS?

104


What are different replication agents and what's their purpose? : sql server replication

572


Is oracle faster than sql server?

549


What is shrink log file?

512


Write a code to select distinct records without using the DISTINCT keyword.

646


How use inner join in sql server?

615


What are the rules to use the rowguidcol property to define a globally unique identifier column?

589


Find first and last day of current month in sql server

595


What is not null constraint?

620


Which are the new data types introduced in sql server 2008?

512