MS SQL Server New Users - make changes with scripts

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

make changes with scripts

Sam

2005-12-14, 7:23 am

i have some changes to make in user's database
for this i have scripts with "alter view/alter proc ...."
how i can make those changes without opening each script, but by taking all
of them in some automatic way?

sam

Sue Hoegemeier

2005-12-19, 8:25 pm

By running a single script that has all of your changes -
i.e.
Alter procedure YourProcedure
as
<whatever>

go

Alter view YourView
as
<whatever>

go

Alter view YourOtherView
as
<your view.....>

-Sue
On Wed, 14 Dec 2005 12:55:28 +0200, "Sam"
<focus10@zahav.net.il> wrote:

>i have some changes to make in user's database
>for this i have scripts with "alter view/alter proc ...."
>how i can make those changes without opening each script, but by taking all
>of them in some automatic way?
>
>sam
>

Sponsored Links