Gianluca Sartori (7/25/2011)

---

... unless you're working with Oracle. :Whistling:

It's called "cold backup" and it's advertised as "the only...

jlennartz (7/25/2011)

---

john.arnott (7/22/2011)

---

You...

Tom Van Harpen (7/25/2011)

---

Lowell,

That appeared to work, I'm confused now, when I do the print statement I only get part of the definition, but the execution works.

Is Nvarchar(4000) the...

Mad Myche (7/25/2011)

---

Agree with that as well I do.

Often what they say they want is not really what they want, or is incomplete. I will always let the person giving...

What about the related tables???

That's why I preffer the rs scripting option. It uses supported functions, so you can't really screw it up once the logic is sound.

Can you post the DDL, I'll make this work on my system.

For sure the concatenation will do implicit convertions. This is annoying but I preffer to cast everything explicitely...

Mad Myche (7/25/2011)

---

Looking at the original ages old post, I noticed that the data appears to be a 3 element asterisk delineated string. Depending on the needs, removal of the...

There's just no reason to shutdown the server to take a backup.

The only even remotely possible way it makes sense if when you migrate databases from server a to b....

msdb

How about NVARCHAR(MAX) With exec?

halifaxdal (7/25/2011)

---

Roy Ernest (7/25/2011)

---

I am not sure why you want to do this. You can just take back ups. On SSMS, you can use the maintenance plan to set up...

Mad Myche (7/25/2011)

---

Ninja's_RGR'us (7/24/2011)

---

All we said is that it can delete the wrong data with replace. Left is clear as day. Whack the last 3 characters and most...

pkeeler (7/25/2011)

---

I think the general complaint is that the question was made ambiguous when it didn't need to be. Leaving the table structure and contents undefined did not lend anything...

Marios Philippopoulos (7/25/2011)

---

Makes sense. So you don't...

Ok so he must be confused!

I'm just using the normal text column of the trace to then get the sp_name. Nothing special.