I am currently working with SQL Server 2005 and I want to use the BCP Utility to generate reporting information which is processed by another application. The output of the file takes the form of a pipe delimited csv file. The question that I have is how do I include the table columns as part of the report output? Is there a way to do this so that both the columns and the associated data are displayed in the .csv file?
There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005.
The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
Recently, I was involved in a di…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data.
A Microsoft Access subform is used to show relevant calcul…