Answer Posted / lekhrajdeshmukh

We have to decrease the size of a log file by shrinking the
large file.

Syntex:-
DBCC dbname
go
DBCC shrinkfile(filename,sizevalue)
go.
for eg I want to shrink the filename data of databse userdb
to 7 mb.

dbcc userdb
dbcc shrinkfile(data,7)

What do you mean by an execution plan?

1051

---

What is user-defined inline table-valued function?

898

---

What are the different types of replication you can set up in sql server?

983

---

What is identity?

947

---

How to check parameter value in stored procedure sql server?

911

---

What the different types of Replication and why are they used?

978

---

Who is the owner of a schema in ms sql server?

1007

---

Explain what are magic tables in sql server?

947

---

What is apply operator in sql?

956

---

What is 'write-ahead log' in sql server 2000 ?

988

---

What is log in sql server?

1075

---

Explain transaction isolation levels in sql server?

1034

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1800

---

How to select all columns of all rows from a table with a select statement in ms sql server?

1044

---

How to return the date part only from a sql server datetime datatype?

1021

---