Thanks Bru for that workaround. I'm hoping that there are settings in the Management Studio that we can set.

Thank you for quick reply. I'm afraid I only have Activity Monitor in Management.

Thanks again Jeff. I will take time to read and study your articles. 🙂

hi jeff, thanks for the adviced. I'm working on a large data for a particular client. Are there any other options w/o using a while loop? how...

Thanks Sankar and Chris for your replies. It helps my project. 🙂

Thank you very much guys for your effort on this... I just get back over the weekend. The problem that I mention above occurs one of our users and...

I just figured out yesterday that I has an import/export wizard on it and I made it. I'm still learning on this tool. Thank you very much Greg!

Sorry... My bad. What I mean here is that how do I transfer from one databse to another database using SSIS?

Thanks... However I already used the Activity Monitor in SQL Management Studi 2005.

My problem here is that how would I know if a certain application is consuming more CPU, Phsyical...

Hi:

Try this out...

/* This sp is referred from the following web site: http://www.orcsweb.com/articles/sendmailsql.aspx */

create procedure sendnotification @cfrom varchar(100), @cto varchar(100), @csubject varchar(50),

@cbody text, @csmtp varchar(20), @cretvalue...

Thanks you guys... I really appreciate it. 🙂

Thanks! I got it...:)

Thanks... I really appreciate your quick reponse on this 🙂 So, I think its safe that we explicitly put an alias on it so its backward compatible.

okay, thanks.