ok, Thanks! I see the Integration Services installed along with the original installation itself. but not the BIDS i guess.

I managed to find the installation cds for Sql Server 2008...

Thanks Phil! this worked perfect!

I added domain user and granted user permissions on the folder, and the report item. using the report link directly user is able to access and exectue the report. but...

for connectiong to the SSMS i'm using the common connection that i have in the shared datasource.

so the user for the reports folder is differnt from the user used in...

Thanks to you all for the responses!

oh, ok Steve. so , if i don't have the previous file in the exisiting the folder, since there's no file exists my next backup will create the new...

Thanks Steve

what is Append to existing mode means in the maintenance plan?

I am moving the .BAK file everyday into the archive folder. so the folder is empty when the...

we just went live with our new database.i created the plan using the defualt setting from the wizard.

attached is my full db backup maintenance plan screen.

Thank you so much Adi and Dan! thanks for the clear explain and example.

so what is the Append mode in the maintenance plans means?

Thank you! i need to answer this to my IT admin, would be nice if i can show him the reason why it doesn't add up. atleast if i can...

Hi, need help again with the code. after i got this built and showed to the user. the user said the Dates are not always 5 dates. there will be...

Thanks!!! yes, i tried it and i got the exception error, and dbcreator cannot change the sa password. that's good!

Thanks a lot!

this user is a brand new user that i created on the sql server and is not the windows user. I created a brand new sql user on the server,...

ok, got it! Thanks Dev and Roy!

Thanks a lot Cad !!!

you are super good!! i slowely re-read the part2 article and stepped thru each step that you explained in the above code. finally now i...