Solved

SQL 2008

Posted on 2011-02-28
4
284 Views
Last Modified: 2012-05-11
I have about 200 Sp and 300 View and I ned to change the schema to dbo.
I tried to work on the Generate code but it keep give me too many errors because the Dependence. I cant sort on create date and I cant pick the first create is there any other way to generate the code for these views and SP?

Thanks
0
Comment
Question by:DBA2010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 28

Expert Comment

by:strickdd
ID: 35000748
Right click on the database, select Tasks, Click "Generate Scripts"

Make sure to enable the scripting of Object Level Permissions

Click Finish and change the schema to the dbo schema and run the script for those creations.
0
 
LVL 15

Expert Comment

by:derekkromm
ID: 35000765
0
 

Author Comment

by:DBA2010
ID: 35001411
why Object Level Permission? What does that mean?
and what about Generate script for Dependent Objects? False or tru? the default is False??

Thanks
0
 
LVL 6

Accepted Solution

by:
anushahanna earned 500 total points
ID: 35003684
>>why Object Level Permission? What does that mean?
SP, Views are considered objects, so are functions, tables etc

>>and what about Generate script for Dependent Objects? False or tru? the default is False??

Say no. Otherwise, it brings in more objects than the SP, Views you want- you will have lot more CREATE Statement. In the destination database, do you have all the dependent objects, if not, say Yes, to make sure to bring together all the dependencies.
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question