What all db objects can be found in MSDB database of a SQL
Answers were Sorted based on User's Feedback
Answer / hari
monitoring the scedule activities
|Is This Answer Correct ?||4 Yes||0 No|
Answer / suri
select * from sysobjects
|Is This Answer Correct ?||2 Yes||0 No|
what r steps to we need to fallow b4 kill the process?
I have Two table First have UserName and second is address, in address table more than value relegated to UserName table, i want to fetch 2nd address if exist other wise 1st address access
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.
How can we call UDF(User Define Function) using C# code in ASP.net ?
is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?
what is node in sql server?
Different Types of Functions ?
What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?
What is difference between Datepart() and Datename() in SqlServer?
What are transactions and its controls?