paul-941374 (4/14/2011)

---

Does SQL Server Native Client just need to be on the machine that is running MSSQL Server?

If so it should be install by default I believe.

"Microsoft SQL Server Native...

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.

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.

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 & ";"

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...

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...

RamSteve (4/14/2011)

---

Hi !

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...

You are probably running into an issue with the encoding attribute of the XML declaration tag within your strings. If it looks like this:

You either need to...

Your statement is...

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...

The note at the top of this article http://msdn.microsoft.com/en-us/library/ms178630.aspx says sp_changedbowner will be removed in...

The attachment contains the complete VS2010 solution and a deploy script which will allow you to deploy the CLR objects without using VS2010.

Enjoy 🙂

SET STATISTICS TIME OFF ;

GO

SET NOCOUNT ON...

Yes, it can cause problems. Here is a good thread on the topic: http://www.sqlservercentral.com/Forums/FindPost949846.aspx

Windows Authentication is preferred, however if you do not have it setup for easy use then create a separate SQL Login for yourself and add it to the sysadmin Fixed...

Dan, are you thinking of the row ID SQL Server uses internally? I don't think we can touch those through the standard means anyway. Some people explicitly use GUIDs as...