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
How to create new tables with "create table" statements in ms sql server?
What are constraints?
What is the security principal at the server level that represents your session?
What is lock escalation and what is its purpose?
What are the advantages of log shipping?
Different types of keys in SQL?
Is it possible in sql table to have more than one foreign key?
What is store procedure? How do they work?
How to connect to a sql server using odbc_connect()?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
How to get all stored procedures in sql server?
Explain Geometry datatype in sql server 2008 with example
what stored procedure would you use to view lock information? : Sql server administration
What are the requirements on sql server network connections?
what is a traditional network library for sql servers? : Sql server database administration