Yes it is, Ahmad. I'm using it for something very similar.

I can post the main stored procedures I use for this in their entirety, and fragments of other...

Thanks Chris,

I had to generate daily sales report and store as new file every day...Is it possible thru ur technik

Hi All,

what effect will i have on the performance if a table exceeds 8062 size?

Once I received an error which said that any update to the table will not take...

elaborate pls....

Thank you all

Thanks all ......

I've already started studying Database mail:)

Hi,

Can we have two identity columns on a single table?

If not then how can one insert an identity column in a table having an identity column?

Regards,

Ahmad

andrewkane17 (2/22/2008)

---

I am assuming you could have this in seconds, if so you could configure a SQL job to run and have that run N # of seconds to pick...

Hi,

Do I have any other option apart from trigger.

Regards,

Ahmad

Matt Miller (2/22/2008)

---

. I would schedule the e-mail process outside of the trigger (like - say - every 15 minutes).

NET SEND would be an unreliable solution, since you wouldn't get...

Hi Dipak,

Then try the next option......:)

Hi Dipak,

The problem is in excel it is considering it as an integer and thus is removing the preceding zeros.

>Change the cell format in excel to text before you...

Hi,

I think that if a table is repopulated with data it will be defragmented.

Regards,

Ahmad

Assalaam walekum Faheem

What I was looking for were some out of box tips on database design....as

I am new to this area of sql

Thanks for your prompt reply.....

Thank you All