------bcp create non-XML format file exec master..xp_cmdshell 'bcp .. format nul -f C:\temp\myFormatFile.fmt -c -T -S myServer\MyInstance'; go ------bcp create XML format file exec master..xp_cmdshell 'bcp .. 126 more words
Tags » SQL Server
step1: First create a blank target database.
step2: Then, in “SQL Server Management Studio” restore wizard, look for the option to overwrite target database. It is in ‘Options’ page and is called… 30 more words
So the other day I was reading into project documentation for a new SharePoint 2013 installation for one of our customers. In said documentation I found some disturbing images that made me think that SharePoint and SQL both were to be installed on a domain controller. 519 more words
If you’d like to get the most accurate of row count of any table, select count(*) is still your BFF. However, in some situations, the speed of retrieving a rough estimate of the row count from a very large table is more emphasized upon. 313 more words