SQL Server - SQLExpress 2005?

Asked By Arthur2009

27-Oct-09 04:07 PM

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,
--
Art2009

27-Oct-09 06:52 PM

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 would  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.

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

25-Jan-10 08:50 PM

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
--
Todd C
MCTS SQL Server 2005