J-F Bergeron (2/9/2010)

---

Ehh, I wish I would've seen that comment before I posted the solution,

Why be so rude...

I guess it's time for me to start a personal black-list

You're right, we are. And we also can decide who we will help and who we won't.

Bye.

I'm sorry, but this comment was totally unnecessary as well as unprofessional.

Personally, I think you owe Roy and the SSC community an apology.

Found some additional documentation in the Windows Server 2003 Resource Kit Tools download.

I have configured a scheduled task on a Windows Server 2008 Server that will start when the server...

Nicholas Cain (2/9/2010)

---

I've not seen much beyond the command line options myself, that being said I use robocopy pretty much exclusively when performing file transfers across the network. The ability...

Tushar-355587 (2/9/2010)

---

Hi Gail/Bru

Thanks For the nice reply....

Very first even I have suggested customer to go for mirroring but customer can't afford 3rd server (which we can use as a witness)...

Good question. Easy if you understand recovery models and backup/restore processes.

Any particular version of SQL Server?

Looks to me that SQL Server 2008 is doing it correctly. Your date is declared as CHAR(10), and the period is being appended at the end of the 10...

Soccer! :Wow:

Yes, soccer season is fast approaching, and I already have 10 games scheduled on the weekend of 2/27 and 2/28, Sunbelt Tournament in Pueblo, CO.

First, although I would be honored if I were selected as a SQL Server MVP, I don't really see that happening in the near future.

I have chosen to participate in...

impact

CirquedeSQLeil (2/5/2010)

---

Chad Crawford (2/5/2010)

---

Maybe we could turn this into an April Fool question of the day.

Which of these methods can be used to restore a damaged database to the...

select 'ALL' as Department

union all

SELECT distinct Department FROM dbo.tblReportData