sqll2000 dtspackge should be copied to sqll2005.?

i click the cluster administarator ,in that i am not getting drive information.

i am not getting how to findout, can u pls give the steps.

thanks..........

i want to get the list of permissions of a db.

can u pls provide the script.......

yes its connect with oracle db.

thanks...........

ok thanks........

the db is sql2000 db.

so how to take the backup of user permissions.

correct........

i want to find out this package have dts features or ssis features.

i want to restore a sql2000db to sql2005.

should take any prerequisites?

thanks...........

thanks.........

hi umar.........pls help...........its urgent...........

i used command below

ALTER DATABASE ABC SET SINGLE_USER WITH Rollback Immediate

i am getting error below

Msg 5061, Level 16, State 1, Line 1

ALTER DATABASE failed because a lock could not...

i used "ALTER DATABASE ABC SET SINGLE_USER WITH Rollback Immediate"

i am getting error as

Msg 5061, Level 16, State 1, Line 1

ALTER DATABASE failed because a lock could not be...

ALTER DATABASE SET SINGLE_USER WITH Rollback Immediate

i'm getting this error when trying to put the single user mode with immidiate.

" ALTER DATABASE failed because a lock could not be placed on database 'ABC'. Try again later."