Can I republish a web site from within a DTS package

I have a DTS package that updates information in a database for one of our clients. This information then needs to be republished to the websites which is done by going to a URL

Example: http://webrepub.DomainName.com/apps/publish.cfm?temp=1&ID=1101.

Is there a way from within the DTS package to execute/call the URL that performs the republishing of the websites with out opening a browser on the server.

TIAWrite a script to do your thing and call that by an 'OS command' from the DTS. That's probably the quickest and most robust sollution.

Gr,
Yveau

Can I rename a server with SQL Server on it?

Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon
SQL2000 - assuming you have the services setup to use the new logon
credentials (if you are not using local system) then all you need to do
is drop and re-add the server to sysservers using the follwowing
sp_dropserver <old_name>
go
sp_addserver <new_name>, local
go
Immy
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I need to move an SQL Server machine to a client's site and we need to
> change the computer name and attach it to the companies domain.
> Can anyone tell me if renaming the machine will upset SQL Server or is it
> "name agnostic"?
> Many thanks
> Simon
|||Check out:
http://msdn2.microsoft.com/en-us/library/ms178083.aspx
http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"Simon Harvey" <nothanks@.hotmail.com> wrote in message
news:OiZIPzlYHHA.408@.TK2MSFTNGP04.phx.gbl...
Hi all,
I need to move an SQL Server machine to a client's site and we need to
change the computer name and attach it to the companies domain.
Can anyone tell me if renaming the machine will upset SQL Server or is
it "name agnostic"?
Many thanks
Simon