The staging table to which I am referring is a new table you will create in the destination database. It's sole purpose will be to...

I am curious as to why you want to pass a parameter to a SQL Agent Job. Are you using Agent as a way to execute stored procedures asynchronously?

GSquared (5/15/2012)

---

opc.three (5/15/2012)

---

GSquared (5/15/2012)

---

Because of all of those kinds of exceptions, and dozens more, I don't recommend doing this in T-SQL, and don't recommend doing this at all without serious...

I would not use xp_cmdshell for this work. Have you tried using bcp directly from the command line?

GSquared (5/15/2012)

---

Because of all of those kinds of exceptions, and dozens more, I don't recommend doing this in T-SQL, and don't recommend doing this at all without serious research into...

Which part are you having trouble understanding?

That is a very small table. In general...

This is normal. When the initial restore was done it was done WITH NORECOVERY. Another option is to restore the database WITH STANDBY, but you have to provide an UNDO...

Not really. Please re-read my earlier post.

The Control Flow would look something like this:

And your data flow would look something like this:

Within the second Execute SQL Task is where you...

No, not using T-SQL.

If you use a programming language like C# (what SSMS uses to run your...

Jeff Moden (5/14/2012)

---

opc.three (5/14/2012)

---

bitbucket-25253 (5/12/2012)

---

opc.three (5/11/2012)

---

I do not, but I would be happy to mock up some test data and...

WayneS (5/14/2012)

---

opc.three (5/14/2012)

---

Calling my example function like this:

SELECT dbo.ToTitleCase('The quick brown fox JUMPS over the lazy dog.');

Yields:

JUMPS stays uppercase. I may decide...

This is what I use:

Where to find information about the latest SQL Server builds

rafael_si (5/14/2012)

---

Thank you guys for you time and patience....

I will do what you've proposed in my test environment. My doubts was solved!

obs: is there a way in this forum to...

capn.hector (5/14/2012)

---

opc.three (5/14/2012)

---

Thank goodness. I think...