Let’s consider a scenario where the end user require a CSV file of all the records in a table then BCP is one of the simplest way. BCP stands for Bulk copy program. By the name you got the feeling of lots of data . Although, there are various options & parameters available with …
To open SQL Profiler (right now I am talking about SQL Server 2012) you need to write Profiler.exe on run command as shown in below figure for earlier version you can use profiler90.exe. You can find various parameters option using Profiler.exe –? command When you run this command you will find below screen. Although …
It is just a simple tip nothing fancy. On command prompt you just type SSMS and hit OK. Your SQL server Management studio will be open. You can get other option also by typing ssms/? . You will get below options Now if you want to login to particular SQL Server Instance you can choose …