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

That's great news! Windows Scheduler calling a batch file would work. SQL Agent doing the same, or calling bcp.exe directly would also work. SQL Agent jobs have a step type...

CirquedeSQLeil (4/12/2011)

---

There are also good reasons to enable it and in a controlled environment would mitigate those reasons for it being off by default. The biggest reason for it...

Sorry, double post...

That implies turning on xp_cmdshell which is off by default...for good reason.

From T-SQL you'd have to read the registry or run a WMI script. I would recommend inverting your design and developing a SQL PowerShell script that can grab the host...

You are in an area that not a lot of people go. With all due respect, this scenario is exactly why DBAs who do not have close working relationships with,...

Jeff Moden (4/8/2011)

---

The reason I was asking is that if you had special characters such as < or >, etc, then we'd have to add just a little more code...

SQL 2005 (the forum you posted in) does...

Duplicate post, direct comments here: http://www.sqlservercentral.com/Forums/Topic1091056-391-1.aspx

Duplicate post, direct comments here: http://www.sqlservercentral.com/Forums/Topic1089813-364-1.aspx

steve smith-401573 (4/8/2011)

---

The sql query is written and works. To accommodate the limitations of bcp performing only a single select, I took my memory table and made it a...