What are mdf,ndf,ldf files and how to see the data in those
files?
Answer Posted / sankar
sp_helpdb "database name"
| Is This Answer Correct ? | 40 Yes | 20 No |
Post New Answer View All Answers
When I delete any data from a table, does the sql server reduce the size of that table?
Explain the creation and execution of a user-defined function in the sql server?
Will sql server 2005 allow you to reduce the size of a column?
what is the difference between openrowset and openquery?
Why Master database is required?
What are subqueries in sql server? Explain its properties.
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What are subquery and its properties?
How to find the source of a table in sql server?
How to generate create view script on an existing view?
What are the key configuration files for sql server reporting services ?
Other than truncate statement, which other command can by-pass the trigger on the tables?
What is a mixed extent?
What is difference between temp table and cte?
What are the differences between clustered and non-clustered index?