Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is this valid script to attach a database?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01530166
Message ID:
01530176
Views:
45
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform