Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is this valid script to attach a database?
Message
 
 
À
02/12/2011 09:35:33
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01530166
Message ID:
01530176
Vues:
44
>>Yes, I tried to execute this script but something does not work. Most likely the problem is with roles and/or permissions, since I am attaching this database to the customer SQL Server and doing it via VPN connection. What happened is the database appears in the list of the databases in the customer SQL Server. So it seems as it should work. But I can't get down to any tables; getting error.
>>Thank you.
>
>Can you post the error message?

I will a little later when I have a chance to connect. Although I asked the customer (yesterday) if he could detach the database so that I can attach it again.

He wrote to me the following prior to me attaching the database:

"The one caveat though is that, before you detach the database in your dev environment to transfer to us, you need to create the user ‘dlitvak’ and assign it the ‘db_owner’ role in the database so that when you attach it to our server the accounts will match up and it will give your account access to it."

I thought I did exactly what he asked (above) but still having issue.

Thanks.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform