SQLExpress 2005?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arthur2009 - 27 Oct 2009 21:07 GMT

Greeting All,

I really need some help. I have 400+ Vista workstations running SQLExpress
2005. Due to a recent change in business; I need to modify a single stored
procedure on each unit. Is it possible to script this change; if yes, how?

Thanks in advance,

Signature

Art2009

Reply to this Message

Hugo Kornelis - 27 Oct 2009 23:52 GMT

>Greeting All,
>
[quoted text clipped - 3 lines]
>
>Thanks in advance,

Hi Arthur,

The script would go like

ALTER PROC Schema.Procedurename
@Param1 int = 0,
@Param2 varchar(200),
@RC in OUT
AS
/* First statement of modified procedure */
(...)
/* Last statement of modified procedure */
go

And then, you'd have ot run that script against each workstation. If
they are connected on a single network, you can probably use some
network management tools to automate that part, but that is beyond my
knowledge.

Signature

Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Reply to this Message

Todd C - 26 Jan 2010 01:50 GMT

Arthur:
Assuming you have the following:
* A list of the machine names
* Administrator priviledges via you Windows Domain:

You could create a script that does the following:
1) create a linked server connection to the first machine in the list
2) Execute the stored procedure on the linked server
3) record the fact that that particular Server was done.

HTH

Signature

Todd C
MCTS SQL Server 2005

> >Greeting All,
> >
[quoted text clipped - 22 lines]
> network management tools to automate that part, but that is beyond my
> knowledge.

Reply to this Message