Hi Jay Bee,

What exactly are you trying to do?

Thanks,

Phillip Cox

The standard quote "If its not broke, don't fix it" is similar to deciding whether to upgrade or not. Just because something works fine shouldn't play 100% into the...

Glad I can help!

Thanks,

Phillip Cox

bodhilove (10/7/2008)

---

Hi Folks,

are you able to restore a master database on a different sql server or instance. I am doing this for replay.

It seems I can restore the master if...

Hey,

Thanks for update and I'll keep an eye out for exam.

Cheers,

Phillip Cox

abhijeetv (10/6/2008)

---

a few Qs:

What is the commented part in your SQL? If uncommented then both the variables have the same date value.

Can you make this a dynamic SQL to try...

Hey,

You'll need to build a query driven email and format as HTML. The following stored procedure will help you and BOL has more details:

sp_send_dbmail [ [ @profile_name = ]...

arjun.tewari (10/6/2008)

---

Hi Guys,

Does any body have any idea about the below error:

The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the...

Nassim (9/18/2008)

---

Hi ,

I have ETL running everyday ,sometimes it hangs on one of the pakages .if I stop it and rerun again it will not work , I copy...

sandhyarao49 (9/17/2008)

---

Hi to all,

For normal application errors we check in the event viewer application logs .

I have small doubt in the event properties what exactly the source is

whether it...

reportmaker (9/16/2008)

---

Hi All,

I work primarily on SSRS & SSIS on the SQL server 2005 platform. I am looking for Data warehousing projects( ETL, OLAP or reports building) on the SQL...

madhu.arda (9/16/2008)

---

Thank you..

This is the error I can see in the error log:

2008-09-16 03:21:20.86 spid59 BackupMedium::ReportIoError: write failure on backup device '\\advfuji\d$\Backup\AQSSQL2\CFQUTN01\CFQUTN01_09-16-2008.bak'. Operating system error 112(There is...

Hey,

Ok, had a look at backup script and its one I wouldn't put into my production environment. I would strongly suggest you rewrite your script and test it before...

madhu.arda (9/16/2008)

---

To give exact picture.. There is a job running this stored procedure at every one hour between 2AM to 8PM. And initially I thought logbackup is failing but going...

hey,

As Lynn has already mentioned, sounds like a network blip. When was last successful full backup and where was this stored? Have you tried re-running backup and if...