After server rename, xp_cmdshell problem

I have a job which runs a SP containing a xp_cmdshell call to
wzunzip.exe to unzip a file. This has worked for over a year without
a glitch. I recently renamed the server, following the proper steps I
think, and now this SP hangs at the unzip command. I can't even
cancel the job, when I try I see that the server is doing a rollback,
but it never finishes, and I have no idea what it would be rolling
back. I end up stopping the agent and restarting. I am probably
missing something easy but I can't figure it out. This same script
has always worked and continues to work on other servers, the only
change being the server rename. Any ideas on what I am missing?
Thanks,
Charles
Are you using the command-line versions of winzip (separate download)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408140754.3047b6a@.posting.google.co m...
> I have a job which runs a SP containing a xp_cmdshell call to
> wzunzip.exe to unzip a file. This has worked for over a year without
> a glitch. I recently renamed the server, following the proper steps I
> think, and now this SP hangs at the unzip command. I can't even
> cancel the job, when I try I see that the server is doing a rollback,
> but it never finishes, and I have no idea what it would be rolling
> back. I end up stopping the agent and restarting. I am probably
> missing something easy but I can't figure it out. This same script
> has always worked and continues to work on other servers, the only
> change being the server rename. Any ideas on what I am missing?
> Thanks,
> Charles
|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<O2t6qnigEHA.2928@.TK2MSFTNGP10.phx.gbl>...
> Are you using the command-line versions of winzip (separate download)?
Yes I am using the command-line version. I just uninstalled and
reinstalled winzip and the command-line add-on. It is working fine
from the command line. But when I try to run it from QA it just
hangs, no indication of anything. I can see from taskmanager that
wzunzip.exe is running, but nothing happens.
[vbcol=seagreen]
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408140754.3047b6a@.posting.google.co m...
|||Perhaps it is waiting form some type of input? I believe that there are silent switches and stuff for the
command-line versions. Might be worth trying out? I haven't unzipped from xp_cmdshell, but I have zipped...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408151256.29d1aded@.posting.google.c om...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:<O2t6qnigEHA.2928@.TK2MSFTNGP10.phx.gbl>...[vbcol=seagreen]
> Yes I am using the command-line version. I just uninstalled and
> reinstalled winzip and the command-line add-on. It is working fine
> from the command line. But when I try to run it from QA it just
> hangs, no indication of anything. I can see from taskmanager that
> wzunzip.exe is running, but nothing happens.
>

After server rename, xp_cmdshell problem

I have a job which runs a SP containing a xp_cmdshell call to
wzunzip.exe to unzip a file. This has worked for over a year without
a glitch. I recently renamed the server, following the proper steps I
think, and now this SP hangs at the unzip command. I can't even
cancel the job, when I try I see that the server is doing a rollback,
but it never finishes, and I have no idea what it would be rolling
back. I end up stopping the agent and restarting. I am probably
missing something easy but I can't figure it out. This same script
has always worked and continues to work on other servers, the only
change being the server rename. Any ideas on what I am missing?
Thanks,
CharlesAre you using the command-line versions of winzip (separate download)?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408140754.3047b6a@.posting.
google.com...
> I have a job which runs a SP containing a xp_cmdshell call to
> wzunzip.exe to unzip a file. This has worked for over a year without
> a glitch. I recently renamed the server, following the proper steps I
> think, and now this SP hangs at the unzip command. I can't even
> cancel the job, when I try I see that the server is doing a rollback,
> but it never finishes, and I have no idea what it would be rolling
> back. I end up stopping the agent and restarting. I am probably
> missing something easy but I can't figure it out. This same script
> has always worked and continues to work on other servers, the only
> change being the server rename. Any ideas on what I am missing?
> Thanks,
> Charles|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<O2
t6qnigEHA.2928@.TK2MSFTNGP10.phx.gbl>...
> Are you using the command-line versions of winzip (separate download)?
Yes I am using the command-line version. I just uninstalled and
reinstalled winzip and the command-line add-on. It is working fine
from the command line. But when I try to run it from QA it just
hangs, no indication of anything. I can see from taskmanager that
wzunzip.exe is running, but nothing happens.
[vbcol=seagreen]
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.040814075
4.3047b6a@.posting.google.com...|||Perhaps it is waiting form some type of input? I believe that there are sile
nt switches and stuff for the
command-line versions. Might be worth trying out? I haven't unzipped from xp
_cmdshell, but I have zipped...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408151256.29d1aded@.posting
.google.com...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in messag
e
news:<O2t6qnigEHA.2928@.TK2MSFTNGP10.phx.gbl>...[vbcol=seagreen]
> Yes I am using the command-line version. I just uninstalled and
> reinstalled winzip and the command-line add-on. It is working fine
> from the command line. But when I try to run it from QA it just
> hangs, no indication of anything. I can see from taskmanager that
> wzunzip.exe is running, but nothing happens.
>

After server rename, xp_cmdshell problem

I have a job which runs a SP containing a xp_cmdshell call to
wzunzip.exe to unzip a file. This has worked for over a year without
a glitch. I recently renamed the server, following the proper steps I
think, and now this SP hangs at the unzip command. I can't even
cancel the job, when I try I see that the server is doing a rollback,
but it never finishes, and I have no idea what it would be rolling
back. I end up stopping the agent and restarting. I am probably
missing something easy but I can't figure it out. This same script
has always worked and continues to work on other servers, the only
change being the server rename. Any ideas on what I am missing?
Thanks,
CharlesAre you using the command-line versions of winzip (separate download)?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408140754.3047b6a@.posting.google.com...
> I have a job which runs a SP containing a xp_cmdshell call to
> wzunzip.exe to unzip a file. This has worked for over a year without
> a glitch. I recently renamed the server, following the proper steps I
> think, and now this SP hangs at the unzip command. I can't even
> cancel the job, when I try I see that the server is doing a rollback,
> but it never finishes, and I have no idea what it would be rolling
> back. I end up stopping the agent and restarting. I am probably
> missing something easy but I can't figure it out. This same script
> has always worked and continues to work on other servers, the only
> change being the server rename. Any ideas on what I am missing?
> Thanks,
> Charles|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message news:<O2t6qnigEHA.2928@.TK2MSFTNGP10.phx.gbl>...
> Are you using the command-line versions of winzip (separate download)?
Yes I am using the command-line version. I just uninstalled and
reinstalled winzip and the command-line add-on. It is working fine
from the command line. But when I try to run it from QA it just
hangs, no indication of anything. I can see from taskmanager that
wzunzip.exe is running, but nothing happens.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408140754.3047b6a@.posting.google.com...
> > I have a job which runs a SP containing a xp_cmdshell call to
> > wzunzip.exe to unzip a file. This has worked for over a year without
> > a glitch. I recently renamed the server, following the proper steps I
> > think, and now this SP hangs at the unzip command. I can't even
> > cancel the job, when I try I see that the server is doing a rollback,
> > but it never finishes, and I have no idea what it would be rolling
> > back. I end up stopping the agent and restarting. I am probably
> > missing something easy but I can't figure it out. This same script
> > has always worked and continues to work on other servers, the only
> > change being the server rename. Any ideas on what I am missing?
> >
> > Thanks,
> > Charles|||Perhaps it is waiting form some type of input? I believe that there are silent switches and stuff for the
command-line versions. Might be worth trying out? I haven't unzipped from xp_cmdshell, but I have zipped...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408151256.29d1aded@.posting.google.com...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
news:<O2t6qnigEHA.2928@.TK2MSFTNGP10.phx.gbl>...
> > Are you using the command-line versions of winzip (separate download)?
> Yes I am using the command-line version. I just uninstalled and
> reinstalled winzip and the command-line add-on. It is working fine
> from the command line. But when I try to run it from QA it just
> hangs, no indication of anything. I can see from taskmanager that
> wzunzip.exe is running, but nothing happens.
>
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Charles Sands" <z666z@.yahoo.com> wrote in message news:1f9df651.0408140754.3047b6a@.posting.google.com...
> > > I have a job which runs a SP containing a xp_cmdshell call to
> > > wzunzip.exe to unzip a file. This has worked for over a year without
> > > a glitch. I recently renamed the server, following the proper steps I
> > > think, and now this SP hangs at the unzip command. I can't even
> > > cancel the job, when I try I see that the server is doing a rollback,
> > > but it never finishes, and I have no idea what it would be rolling
> > > back. I end up stopping the agent and restarting. I am probably
> > > missing something easy but I can't figure it out. This same script
> > > has always worked and continues to work on other servers, the only
> > > change being the server rename. Any ideas on what I am missing?
> > >
> > > Thanks,
> > > Charles

After rename the computer

Hi,
I have rename my WindowsXP after I installing the SqlServer 2005 express.
Can the SqlServer run well in the WindowsXP after renaming?you want to drop the old sqlserver name and add the new one.
exec sp_dropserver 'oldcomputername\sqlexpress'
go
exec sp_addserver 'newcomputername\sqlexpress','local'
go
restart sqlserver service to take effect.
-oj
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have rename my WindowsXP after I installing the SqlServer 2005 express.
> Can the SqlServer run well in the WindowsXP after renaming?
>|||i think we need to update originating_server in sysjobs after change server
name?
else the job won't run..
DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
"oj" wrote:

> you want to drop the old sqlserver name and add the new one.
> exec sp_dropserver 'oldcomputername\sqlexpress'
> go
> exec sp_addserver 'newcomputername\sqlexpress','local'
> go
> restart sqlserver service to take effect.
> --
> -oj
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
>
>|||you want to drop the old sqlserver name and add the new one.
exec sp_dropserver 'oldcomputername\sqlexpress'
go
exec sp_addserver 'newcomputername\sqlexpress','local'
go
restart sqlserver service to take effect.
-oj
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have rename my WindowsXP after I installing the SqlServer 2005 express.
> Can the SqlServer run well in the WindowsXP after renaming?
>|||i think we need to update originating_server in sysjobs after change server
name?
else the job won't run..
DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
"oj" wrote:

> you want to drop the old sqlserver name and add the new one.
> exec sp_dropserver 'oldcomputername\sqlexpress'
> go
> exec sp_addserver 'newcomputername\sqlexpress','local'
> go
> restart sqlserver service to take effect.
> --
> -oj
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
>
>|||indeed. also, you will not be able to drop the old name (unless you hack the
sysservers table) if you have replication, loopback linked server setup.
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:096BBAB9-19AC-44B8-9E5E-1924FA71F61C@.microsoft.com...[vbcol=seagreen]
>i think we need to update originating_server in sysjobs after change
>server
> name?
> else the job won't run..
> DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS
> sysname)
> UPDATE sysjobs SET originating_server = @.srv
>
> "oj" wrote:
>|||indeed. also, you will not be able to drop the old name (unless you hack the
sysservers table) if you have replication, loopback linked server setup.
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:096BBAB9-19AC-44B8-9E5E-1924FA71F61C@.microsoft.com...[vbcol=seagreen]
>i think we need to update originating_server in sysjobs after change
>server
> name?
> else the job won't run..
> DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS
> sysname)
> UPDATE sysjobs SET originating_server = @.srv
>
> "oj" wrote:
>

After rename the computer

Hi,
I have rename my WindowsXP after I installing the SqlServer 2005 express.
Can the SqlServer run well in the WindowsXP after renaming?you want to drop the old sqlserver name and add the new one.
exec sp_dropserver 'oldcomputername\sqlexpress'
go
exec sp_addserver 'newcomputername\sqlexpress','local'
go
restart sqlserver service to take effect.
--
-oj
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have rename my WindowsXP after I installing the SqlServer 2005 express.
> Can the SqlServer run well in the WindowsXP after renaming?
>|||i think we need to update originating_server in sysjobs after change server
name?
else the job won't run..
DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
"oj" wrote:
> you want to drop the old sqlserver name and add the new one.
> exec sp_dropserver 'oldcomputername\sqlexpress'
> go
> exec sp_addserver 'newcomputername\sqlexpress','local'
> go
> restart sqlserver service to take effect.
> --
> -oj
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> > Hi,
> >
> > I have rename my WindowsXP after I installing the SqlServer 2005 express.
> >
> > Can the SqlServer run well in the WindowsXP after renaming?
> >
> >
>
>|||indeed. also, you will not be able to drop the old name (unless you hack the
sysservers table) if you have replication, loopback linked server setup.
--
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:096BBAB9-19AC-44B8-9E5E-1924FA71F61C@.microsoft.com...
>i think we need to update originating_server in sysjobs after change
>server
> name?
> else the job won't run..
> DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS
> sysname)
> UPDATE sysjobs SET originating_server = @.srv
>
> "oj" wrote:
>> you want to drop the old sqlserver name and add the new one.
>> exec sp_dropserver 'oldcomputername\sqlexpress'
>> go
>> exec sp_addserver 'newcomputername\sqlexpress','local'
>> go
>> restart sqlserver service to take effect.
>> --
>> -oj
>>
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
>> > Hi,
>> >
>> > I have rename my WindowsXP after I installing the SqlServer 2005
>> > express.
>> >
>> > Can the SqlServer run well in the WindowsXP after renaming?
>> >
>> >
>>