I don't know about *bright* but a try/catch might do some good. If an exception is thrown control will change to the catch block, the message will be output to...

Here is a bcp.exe example:

bcp can be used against any version of SQL Server.

That's why I said "It won't affect you" ... you lucked out that it fit your use-case 🙂

I latched onto this thread as a watcher to try and learn something from it so, sorry, I cannot offer any technical assistance.

I could see where replicating from Oracle to...

err...the title of the thread is:

"copy files created in a folder two Months ago to another folder"

Jeff Moden (6/19/2011)

---

opc.three (6/18/2011)

---

I choose not to use SQLCLR for accessing the file system. If I find myself in a situation where I want to retrieve some information about a...

Thank you for attempting to provide what I asked for, however that is quite what I had in mind. Did you read the article? Specifically first section titled "The Wrong...

Hi Brandie, It would be ideal if SSIS contained component(s) to do this kind of work without having to use a Script Task or involving PowerShell, I would actually prefer...

Sorry, almost missed the point...

Using EXCEPT you'll be incurring a lot of the same comparison overhead by comparing every column in both sets. Have you run both methods side by...

The MERGE statement evaluates the predicates in ON clause and applies all assignments in the WHEN MATCHED...THEN clause. What are you trying to prevent by adding the additional checks...a trigger...

Tao Klerks (6/19/2011)

---

Hi, FYI, I did something similar to this using a SQL CLR stored procedure, it actually works pretty well! Doesn't handle the "ROOT" option yet, but should work...

Phil provided the...

What have you tried so far? I am willing to help you if you can provide the following:

1) DDL and DML to build some sample tables.

2) Expected results.

3) The queries...

Another possibility: on the new server did you run Set-ExecutionPolicy under the context of the user trying to run the script?

WRACK (6/19/2011)

---

Hi,

This just happened again. Sunday 2 PM was a full backup right after we restored all the missing records and Monday 9:20 AM 250000 records have been deleted. I...