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

How to insert new line characters into strings?

727


What does the on delete cascade option do?

748


which table keeps the locking information? : Sql server administration

706


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1752


What is store procedure? How do they work? When do you use?

698






How to modify an existing user defined function?

773


mention different types of relationships in the dbms?

700


How to update muliple row in single query?

798


What is “asynchronous” communication in sql server service broker?

721


what exactly sql injuction.how to overcome.....

2245


what is the system function to get current user's user id? : Sql server database administration

741


Explain the first normal form(1nf)?

750


What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

760


What are locks in sql?

709


What is ddl command?

703