Heh... I still want to know why the op wants to do this. :hehe:

Heh... include my post in your report on usage potential advising against using it.

The only time I even come close to Hungarian notation is that I'll use a "pi" or...

bcronce (9/23/2008)

---

You can't compare text types to eachother, which means you can't run a distinct statement that outputs or groups on a text column. I don't think sql stores text...

Not sure what you mean... what did you do to get it to show ProcA has a ProcC dependency? I can only see ProcB. Maybe I'm doing the...

Now, that's gonna be handy. Didn't know about that. Thanks, Jack! 🙂

A pretty good product to work with for cleaning up/certifying Canadian addresses is a product called "Street Sweeper". I forget who it's made by because the boys in Ops...

Ummm... disregard my last... it appears that you're only interested in clustering and log shipping.:)

Sam,

My recommendation is to peel one potato at a time. To know which potato to peel first, you must do some measuring. Put the following at the beginning...

Ahmad Osama (9/22/2008)

---

but question here is that if i didn't get any experience on SQL server in next 90 days ..... then how will i pitch my self for an...

Heh... and I wasn't responding to your particular post, either. In general, it seems that the direction of this thread is to split the original post into 20 stored...

I ran into this exact same problem on Friday... a couple of scheduled jobs had failed and restarted... they apparently made a mess of things in the SQL Server Agent....

... and, to understand more about how that script works, please lookup "Estimating Table Size" in Books Online.

kumar99ms (9/8/2008)

---

I am pushing data from SQL SERVER TO ORACLE,

So, I can audit the job from sql server.

But how in oracle..?

when we insert data into a table in...

Heh... Daaannngg Gail! Didn't know you could shoot porkchops that hard! 😀

Sure would be nice if you shared your solution, Adam. 😉