Please let me know any online material links on Transacation management and lock management, I was so confused with other databases and with SQL Server? I will refresh my knowledge...

Hi,

Any other Ideas on this discussion from any one?

venki (12/9/2008)

---

I...

Thanks to one and all for your valuable sugesstions.

Yes, I do agree with your discussion that it is not good to change the total records form local time to UTC...

I have...

Chris Harshman (12/5/2008)

---

SELECT @body = @body + s.name + '.' + t.name + CHAR(9) + CAST(SUM(ps.row_count) AS varchar(9)) + CHAR(13)

FROM sys.tables t

INNER JOIN sys.schemas...

The problem...

Thanks Chris. It is working fine and able to send the mails with the table counts

Chris Harshman (12/5/2008)

---

If you're using some other custom built procedure to send the e-mail, then we probably can't help you without knowing how that stored procedure works and what its...

venki (12/5/2008)

---

Thanks to all of you for your better suggestions

I need SP because I need to send the mail with the table counts for selected tables in a database. This...

Thanks to all of you for your better suggestions

I need SP because I need to send the mail with the table counts for selected tables in a database. This SP...

dhandasyde (11/20/2008)

---

I'm sorry if I'm oversimplifying things here...

If you select EDIT on the OLE DB Destination task, you can redirect the records that fail on the insert by going into...

dhandasyde (11/19/2008)

---

Are your recipients internal customers/users that would have access to a network share? Could you send a link to the appropriate flat file as part of the body...

Lowell (11/18/2008)

---

yeah it depends on how accurate your data needs to be; a developer might just need to know whether some table has a lot of rows or not, but...

Thanks a lot to all of you for your suggestions.

I know how to create new databases. But I was first affraid when I got this requirement that I have to...