Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60

3 Answers   IT Decisions,

---

What is temporary stored procedure?

0 Answers  

---

sql server architecture ?

0 Answers  

---

What is constraints and its types?

0 Answers  

---

What xml support does the sql server extend?

0 Answers  

---

---

CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.

2 Answers  

---

What is the use of tempdb? What values does it hold?

0 Answers   Abacus,

---

What is Covering Indexes? Plz explain with example

3 Answers  

---

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

0 Answers  

---

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

0 Answers  

---

Define views.

0 Answers  

---

please tell me the query to get details of the employee having the second largest salary

11 Answers   247Customer,

---