I tried and it worked.

Thank you for sharing.

Is there a way to tell where the SQL Agents backup jobs back up the data to without manually looking into the job themselves?

I ran this script on SQL 2005. I kept getting the error on 'while 1=1' with the message "The query uses non-ANSI outer join operators ("*=" or "=*")". It suggested...

I ran into a similar problem yesterday. My Sr. DBA pointed out that I did not have proper SP installed. I installed the latest SP. I was able to edit...

You have correctly identified the problem. I defined a shared datasource instead of local. Thank you for pointing it out.

Since it's not a shared datasource, I ran into another challenge....

I cut and pasted the scripts from your article, and it is: ="Data Source=" & Parameters!ServerName.Value & ";Initial Catalog=master"

One thing I notice from my data source designer screen is...

Hello Carolyn, this is a great article. It is exactly what I was looking for in my new job assignment.

One problem I have is I could not set the...