• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

SQL 2008

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
DBA2010
Asked:
DBA2010
1 Solution
 
strickddCommented:
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
 
derekkrommCommented:
0
 
DBA2010Author Commented:
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
 
anushahannaCommented:
>>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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now