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.

Why would you use sql agent?

0 Answers  

---

How can we get count of the number of records in a table?

0 Answers  

---

Is there any difference between the primary key and unique key?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---

How to create indexed view?

0 Answers  

---

i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..

4 Answers  

---

SQL stops working in every 15 days displaying message that database log file is full. Log file size is 3.95 GB. It is happening after shrinking the database also. What is solution to overcome this problem. Please help me as it's urgent.

5 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

What is a partition function in sql server?

0 Answers  

---

what kind of lan types do you know? : Sql server database administration

0 Answers  

---

What are the advantages of using stored procedures?

0 Answers  

---

How do I find the query plan in sql server?

0 Answers  

---