Right-click anywhere on the design surface in your control flow in BIDS, and choose Package Configurations. Then follow the instructions I gave before.

John

Bhavika

Yes, you can use a package configuration in the child package. Choose Parent package variable from the Configuration type drop-down, and type in the name of the variable.

John

For the first problem, a DDL trigger should be what you need.

For the second problem, look up the syntax for ALTER LOGIN. You'll also need to use that in...

Clustered index and non clustered indexes? On what? Please post table and index DDL so that we can help you. Is this update a one-off, or something...

Timestamp, despite its name, is for row versioning and not for recording times of action. Create your column with datetime data type, and insert GETDATE() into it.

John

You need to do your update in two passes:

;WITH t1 AS (SELECT id,price,relatedid FROM trans)

UPDATE trans

SET price=(

SELECT AVG(price)

FROM t1

WHERE t1.id<=trans.id

)

WHERE relatedid IS NULL

;WITH t1 AS (SELECT id,price,relatedid FROM trans)

UPDATE trans

SET...

Please will you post your actual update statement, since the one you posted has two syntax errors in it.

Thanks

John

Sachin

It doesn't work like that. Gail, like me, does not get paid for providing answers on this forum, and she is just as likely as me to want to...

Sorry, but are you the original poster logging in under a different name? If you're not, please start a new thread. If you are, you've confused me, because...

Right. I'm not doing all your work for you. Have you searched for that error message? What else do you have installed on your server?

John

Sachin

I would concentrate on that line you mentioned in your original post. Have you searched the internet for it? What have you got installed on your T drive?

John

Sachin

That's the errorlog file, isn't it? I need SQLAGENT.OUT.

Thanks

John

Sachin

Please will you post the contents of your latest SQLAGENT.OUT file?

Thanks

John

If it's only the user database that you're going to backup and restore, then you will need to script out logins, jobs, mail profiles and so on, and create them...

You should be able to get all the information you need from the sys.database_permissions system view.

John