Answer Posted / gsreddy

In Properties window(F4)

Security:

1)Package password
2)Protection Level:EncriptSencitiveWithUserKey

How to run sql server 2005 books online on your local system?

507

---

What do you understand by coalesce in sql server?

487

---

Ms sql server index?

519

---

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

456

---

How to create a view with data from multiple tables?

549

---

---

How to handle error or exception in sql?

516

---

What does it mean to normalize data?

503

---

Is mysql the same as sql server?

500

---

What is the difference between delete and truncate statements?

558

---

What is inner join? Explain with an example?

674

---

Explain time data type in sal server 2008?

538

---

Can we write a distributed query and get some data which is located on other server and oracle database?

746

---

How do you create type- insensitive operator?

558

---

when would you go for denormalization? : Sql server database administration

475

---

Can a rule be bound to any column of any data type?

550

---