Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Catja
Starting Member
2 Posts |
 Posted - 2009-04-15 : 05:28:55
|
| Hi, I need to do a local copy of a production database to be able to continue working. I had used Visual Studio 2008 to copy user, tables, views etc to the local copy in SQL server 2005. 1. The User on he procuction database is copied as a Role and not as a User in the local database, do anyone now why?2. When trying to run a stored procedure created by that User on the local database, I got an error message, "Could not find the stored procedure". All help is appreciated.Thanks in advance! |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2009-04-15 : 07:52:48
|
| You might find this link useful. http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546 |
 |
|
|
Catja
Starting Member
2 Posts |
Posted - 2009-04-15 : 08:51:15
|
| Hi,Thanks for the link!I now managed to run the stored procedure by adding the owner when calling the stored procedure in the local copy of the database, i.e. ownername.getProjects. When running the same procedure on the production database this isn't necessary. Does anyone now why? |
|
|
|
|
|
|
Local copy permissions