Thanks for respond...

Created SQL Login

1.I have provide "Public" & "Securityadmin" at server level privileges.

2.I have provide “db_accessadmin” & “db_datareader” & “db_securityadmin” & “public” at database level privileges.

3.Then go with “SQL...

Thanks for respond,

Now i got clear my doubt. yes i have done two copies for instances....

Thanks John, i doubt has cleared....

Thanks for respond.....

But here build version is different one is "RTM" and another one is "SP3". In this case also SQL treat same versions…? Is it sure..?

Pls provide your...

You can't attach a single database to two instances. A database can only be attached to a single instance.

_______________________________________________________________________________________________

Hi Mr. Gail,

Thanks for respond on my post.....

Pls find attached snapshot for...

Thanks for your reply....

i got solve my problem by using SSMS only.... i have no idea about "Power shell & sqlcmd"...