How to create a simple stored procedure in ms sql server?

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

What is use of @@ spid in sql server?

0 Answers  

---

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,

---

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

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.

0 Answers  

---

What is raiseerror? What is raiseerror?

0 Answers  

---

What is a collation in ms sql server?

0 Answers  

---

What are the OS services that the SQL Server installation adds?

3 Answers  

---