narendra.babu57 (7/26/2012)

---

Hi All,

In My Table A , Eid 101 having status all are "cp" then i need latest Edate, but in case 102 it is having different status...

Ensure that EmployeeId is unique in every table. If it is not unique you are bound to get the duplicate records.

You have following backup files with you:

dakshinamurthy-655138 (7/26/2012)

---

1) Full DB backup at 12 AM tonight,

2) Diff Backup at...

dakshinamurthy-655138 (7/26/2012)

---

Hi

I have a scenario,

I have the following backups with me

1) Full DB backup at 12 AM tonight,

2) Diff Backup at 6 AM morning

3) Tlog Bacup at 8 AM, 10...

Little Nick (7/26/2012)

---

I've Maintenance Plans as follows,

Job Schedule Properties as follows,

At this level, my Jobs as follow,

This is the scenario,

1. my machine current Date and Time is 26 July...

avdhut.k (7/25/2012)

---

Hi,

I am not able to trace the error.

But,Sending mail to Same domain is working and to other is not.

Why ?

Can any one try a sample project like this,and tell...

Thanks for sharing your thoughts Basit!

However, I would say I am not impressed with the solution provided to shrink the log file. As the article stats to gracefully shrink the...

Thanks for easy back-to-basics question!

IgorMi (7/20/2012)

---

Hi Gail

I want to thank you for your effort on indexes.

I'll use this opportunity to ask a question.

Example: There is a Table with one clustered index and some non-clustered....

1. Have you checked the scheduled tasks also ?

2. If scheduled task is also not configured to take the backup, most probably this backup is being taken by some...

No. You don't need any separate service pack for analysis or reporting services.

Not applicable. Reverting the suggestion.

Gazareth (7/13/2012)

---

BrainDonor (7/13/2012)

---

This is a bit of a simplification - but basically a view that does not have SCHEMABINDING is just stored as a definition. When you reference the view...

vinod.saraswat (7/12/2012)

---

Hi Divine flame,

Please correct me if I am wrong, I am not able to connect to Production box so for this do I need to make entry in Production...

vinod.saraswat (7/12/2012)

---

How it will help if I put entry in the host file which on dev?

My question is We are not able to connect to xxx-xxxx-PROD\SQL2008P instance through SSMS to...