Answer / lmr

The primary data file cannot be made smaller than the size
of the primary file in the model database.
for eg. while creating a db having size 10 MB
N GREW 100MB
then max the can be shrunk to 10MB.

Find columns used in stored procedure?

0 Answers  

---

what is the difference between a primary key and a unique key? : Sql server database administration

0 Answers  

---

When multiple after triggers are attached to sql table, how to control the order of execution?

0 Answers  

---

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

0 Answers   IBM,

---

Difference between uniqe index and uniqe constraint?

0 Answers  

---

---

What is truncate table?

0 Answers  

---

What's the maximum size of a row?

4 Answers   IBM,

---

what are candidate key, alternate key and composite key? : Sql server database administration

0 Answers  

---

What is a join and their types?

2 Answers   Challenger Financial,

---

How to optimize stored procedure optimization?

0 Answers  

---

What are the types of joins in sql?

0 Answers  

---

What is co-related sub query?

0 Answers  

---