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 are various aggregate functions that are available?
How to find related tables in sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How to convert binary strings into integers in ms sql server?
What are parameterized reports? What are cascading parameters in ssrs reports?
List some major differences between triggers and stored procedures?
How to compare the top two records using sql?
Can we hide the definition of a stored procedure from a use?
Can you move the resources after pausing the node? : sql server database administration
What are the steps you can take to avoid “deadlocks”?
What is logon trigger?
Do you know the cursor optimization tips?
Do you know what is openxml in sql server?
What is the use of set nocount on/off statement?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?