Answer Posted / babu

The question is not clear.

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2880

---

Explain about temporary stored procedure?

934

---

What is the difference between functions and stored procedures?

1091

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1548

---

Explain Normalization and DE normalization

1053

---

What does Master database contains?

1083

---

What is spid in sql server profiler?

1026

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

930

---

How to use wildcard characters in like operations in ms sql server?

1063

---

How to reaname table name without using sp_Rename in sql server..?

936

---

Describe how to use linked server?

933

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1014

---

what is a deadlock? : Sql server database administration

981

---

How to concatenate two strings in SQL Server.

1080

---

Where do we use trace frag?

968

---