Viewing 15 posts - 6,661 through 6,675 (of 7,168 total)
Oh well...that's not something bcp can do with built-in functionality. You would have to do something with UNION ALL in your query to make the first row of your resultset...
April 14, 2011 at 2:41 pm
Jeff Moden (4/13/2011)
April 14, 2011 at 2:22 pm
Have you tried using bcp? bcp may prove to be faster than sqlcmd. bcp was designed to be fast at getting data from a file on disk into SQL Server,...
April 14, 2011 at 1:28 pm
Jack Corbett (4/14/2011)
I've run the script in my environment (different query) and it has worked. I'm not sure what's happening in your environment.
Ditto.
April 14, 2011 at 12:33 pm
paul-941374 (4/14/2011)
If so it should be install by default I believe.
"Microsoft SQL Server Native...
April 14, 2011 at 11:54 am
Object required means the instance of the COM object could not be created. Please verify that the 2008 SQL Native Client has been installed on the remote machine.
April 14, 2011 at 10:54 am
xp_cmdshell calling bcp....yuck!
Write a PowerShell script to (1) get the list of tables from sys.tables (2) loop over the list of tables and call bcp for each one.
April 14, 2011 at 10:33 am
You are using the wrong driver. Try this connection string:
"Driver={SQL Server Native Client 10.0};Server=" & srv & ";Database=" & db & ";Uid=" & uid & ";Pwd=" & pwd & ";"
April 14, 2011 at 10:21 am
If you specify the port you do not want to specify the instance name. IIRC SQL Server Native Client treats instance name with a higher precedence so in supplying them...
April 14, 2011 at 10:05 am
The fact that you can telnet to port 1433 from a remote machine but cannot reach it using the instance name from a remote machine says to me that the...
April 14, 2011 at 9:23 am
RamSteve (4/14/2011)
Can some one guide me how to implement power shell scripts using the SSIS development ,as i need to run on all my present servers(around 300) to get...
April 14, 2011 at 9:14 am
You are probably running into an issue with the encoding attribute of the XML declaration tag within your strings. If it looks like this:
<?xml version="1.0" encoding="UTF-8" ?>
You either need to...
April 14, 2011 at 9:00 am
sturner (4/14/2011)
The ordering of the columns as they appear in a table definition script is cosmetic, they are organized internally in a way that is best for SQL.
Your statement is...
April 14, 2011 at 8:39 am
I just ran across this article and thought it might be of use if you have not arrived at a solution yet. The author is solving a portion of your...
April 14, 2011 at 6:53 am
annasql (4/12/2011)
So what you do is a simple step like below:USE dbname
EXEC sp_changedbowner 'sa'
Is that correct?
The note at the top of this article http://msdn.microsoft.com/en-us/library/ms178630.aspx says sp_changedbowner will be removed in...
April 12, 2011 at 8:49 pm
Viewing 15 posts - 6,661 through 6,675 (of 7,168 total)