Geek Answers Handbook

Import objects into a Visual Studio 2010 Server project

I am trying to rebuild my database using the SQL Server wizard in the VS2010 database project template. I can execute RE my database, but this is not enough, because in order for my sprocs to compile without errors and warnings, I need my linked servers and their logins to be turned on. However, my database administrator cannot grant me the required VIEW ALL DEFINITION permission on SQL Server to run this wizard at the server level. They do not want to do this for me in VS2010, so I am stuck. Has anyone managed to compile or find work to use a database-level database project and use related servers and other server-level objects?

+5
source share
1 answer

Developers can create an empty server project. You can then populate it with DBAs using the Import Databases and Objects command. They just need to right-click the server project and they will see this as the top command.

In this database project, you should add a link to this server project, and everything should be installed.

Microsoft , DBA . , SQL Server 2008, " ", . , ! , DBA .

, , , Microsoft , .

+1

More articles:


All Articles