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

You want to implement the one-to-one relationship while designing tables. How would you do it?

965

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

954

What is the purpose of the model database?

1015

Explain indexing and what are the advantages of it?

1028

What is resource governor?

974

What is a constant or literal in ms sql server?

1046

Is foreign key unique?

995

What are synonyms?

960

What are distinctive joins find as a part of sql?

953

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1030

What to perform pattern match with the like operator?

883

How do indexes help, types?

961

What is the purpose of data source?

1038

What is implicit mode in sql server?

1105

Explain difference between control flow and data flow?

965