sp_helpdb "database name"

What are mdf,ndf,ldf files and how to see the data in those
files?

Question Posted / sankar

Answer Posted / sankar

Is This Answer Correct ?

40 Yes

20 No

Please Help Members By Posting Answers For Below Questions

Can the “if update (colname)” statement be used in a delete trigger?

981

How to provide column names in insert statements in ms sql server?

1132

What are the different types of sql server replication? : sql server replication

1242

What are the features of Embedded SQL

1116

How we can compare two database data?

925

What is 1nf normalization form?

1020

What are the triggers in sql?

1079

Explain the truncate command?

966

What protocol does sql server use?

929

What is correlated subquery in sql server?

1051

How to use "begin ... End" statement structures in ms sql server?

1018

How to copy data from one table to another table?

984

What is normalization? Explain its different types?

1075

What the difference between UNION and UNIONALL?

1024

What is outer join in sql server joins?

1096