We can change the daatabase owner using sp_changedbowner or using ALTER AUTHORIZATION.

http://k2schools.com/how-to-change-the-database-owner-in-sql-server/

Thank you

Thank you so much Chris

With your answer my problem was solved

Hi Ananth,

Might be responding after long time.

Simply Set 'PrecompileScriptIntoBinaryCode' property to False in Script Task Editor.

Hi,

At the following link Cascading Parameters creation explained step by step.Download(free) it.

http://www.4shared.com/video/T65M5ITS/sql_server_2005_reporting_serv.htm

extension of second question

What type problems i will get after deletion of those two databases?

ChiragNS (5/3/2010)

My solution is based on the assumption that you have only a single "\" in your string. i.e. the variable will not contain a value like 'C\test\test"....

Thanks a lot.

Your suggestion helped me a lot

Thanks for reply.

Here i am attaching screen shots of error and deployment properties.Please look at them and suggest me

It is not for one shot.I want to do everyday using a job

Thank you all.

Following code working fine for me

FileDate = "-" + strDay + strMonth + strYear

Hi,

Can you please tell me in which cases we will go for tabular and matrix types.

Thanks in advance

Thanks a lot.

First you need to create a user defiend variable.Here I was created an expression with connection string like

@[User::directory] +RIGHT("0"+ (DT_STR, 2, 1252) DAY( GETDATE() ),2 )+ RIGHT("0"+ (DT_STR, 2,...

thanks to all who looked into my problem.I got solution for this problem.