How do you install sql-server 2000 books online to a server that does
not have sql-server installed at all. I want get access the
documentation via a link from our internal intranet. Any ideas!
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!I can answer the first question, you can download the most current version
from
http://www.microsoft.com/downloads/...DisplayLang=en,
and install it on the server, but I don't know how to make it work from
clients connected to that server.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Dave Brooks" <dbrooks@.neca.org> wrote in message
news:eqDdZAtAEHA.212@.TK2MSFTNGP12.phx.gbl...
> How do you install sql-server 2000 books online to a server that does
> not have sql-server installed at all. I want get access the
> documentation via a link from our internal intranet. Any ideas!
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Dave Brooks wrote:
> How do you install sql-server 2000 books online to a server that does
> not have sql-server installed at all. I want get access the
> documentation via a link from our internal intranet. Any ideas!
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
Doesn't it work?
1) Copy Program Files\Microsoft SQL Server\80\Tools\Books directory
2) Execute C:\WINDOWS\hh.exe
" THE_DIRECTORY_WITH_BOL_ON_YOUR_MACHINE\S
QL80.col"
sincerely,
--
Sebastian K. Zaklada
Skilled Software
http://www.skilledsoftware.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||in addition to the downloadable BOL link Stephen provided and the suggestion
from Sebastian, BOL is also available online on MSDN website at:
http://msdn.microsoft.com/library/d...
ap1.asp
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply only to the newsgroup.
"Dave Brooks" <dbrooks@.neca.org> wrote in message
news:eqDdZAtAEHA.212@.TK2MSFTNGP12.phx.gbl...
> How do you install sql-server 2000 books online to a server that does
> not have sql-server installed at all. I want get access the
> documentation via a link from our internal intranet. Any ideas!
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
Showing posts with label via. Show all posts
Showing posts with label via. Show all posts
Sunday, March 25, 2012
Sunday, March 11, 2012
blocking processes on scheduler
About once or twice a week, our SQL server stops responding. When this happens, we are not able to connect to it via EM or QA. The only solution at this point is to restart the SQL Service. The SQL errorlog always shows the following type of error after t
his happens:
Process ID 72:167 owns resources that are blocking processes on Scheduler 3.
I am finding it hard to troubleshoot this because there is essentially no way to find out what process is causing the blocking. I know what the SPID causing the blocking was, but due to the restart of SQLService, I don't know what it was actually doing.
Can anyone shed more light on this problem? The only potential solution I can think of is to run a trace and capture all the events before the block occurs so that we can identify the cause of the blocking...
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:A008E96F-84B5-4D89-935A-C6B0C6C7A113@.microsoft.com...
> About once or twice a week, our SQL server stops responding. When this
happens, we are not able to connect to it via EM or QA. The only solution at
this point is to restart the SQL Service. The SQL errorlog always shows the
following type of error after this happens:
> Process ID 72:167 owns resources that are blocking processes on Scheduler
3.
> I am finding it hard to troubleshoot this because there is essentially no
way to find out what process is causing the blocking. I know what the SPID
causing the blocking was, but due to the restart of SQLService, I don't know
what it was actually doing.
> Can anyone shed more light on this problem? The only potential solution I
can think of is to run a trace and capture all the events before the block
occurs so that we can identify the cause of the blocking...
>
I would suggest that you turn on the SQL Server Profiler and let it capture
the database activity. By doing so, you should be able to see what was
happening in the server when it finally locks up. That should give you
some direction to start in.
Rick Sawtell
MCT, MCSD, MCDBA
his happens:
Process ID 72:167 owns resources that are blocking processes on Scheduler 3.
I am finding it hard to troubleshoot this because there is essentially no way to find out what process is causing the blocking. I know what the SPID causing the blocking was, but due to the restart of SQLService, I don't know what it was actually doing.
Can anyone shed more light on this problem? The only potential solution I can think of is to run a trace and capture all the events before the block occurs so that we can identify the cause of the blocking...
"DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:A008E96F-84B5-4D89-935A-C6B0C6C7A113@.microsoft.com...
> About once or twice a week, our SQL server stops responding. When this
happens, we are not able to connect to it via EM or QA. The only solution at
this point is to restart the SQL Service. The SQL errorlog always shows the
following type of error after this happens:
> Process ID 72:167 owns resources that are blocking processes on Scheduler
3.
> I am finding it hard to troubleshoot this because there is essentially no
way to find out what process is causing the blocking. I know what the SPID
causing the blocking was, but due to the restart of SQLService, I don't know
what it was actually doing.
> Can anyone shed more light on this problem? The only potential solution I
can think of is to run a trace and capture all the events before the block
occurs so that we can identify the cause of the blocking...
>
I would suggest that you turn on the SQL Server Profiler and let it capture
the database activity. By doing so, you should be able to see what was
happening in the server when it finally locks up. That should give you
some direction to start in.
Rick Sawtell
MCT, MCSD, MCDBA
blocking processes on scheduler
About once or twice a week, our SQL server stops responding. When this happe
ns, we are not able to connect to it via EM or QA. The only solution at this
point is to restart the SQL Service. The SQL errorlog always shows the foll
owing type of error after t
his happens:
Process ID 72:167 owns resources that are blocking processes on Scheduler 3.
I am finding it hard to troubleshoot this because there is essentially no wa
y to find out what process is causing the blocking. I know what the SPID cau
sing the blocking was, but due to the restart of SQLService, I don't know wh
at it was actually doing.
Can anyone shed more light on this problem? The only potential solution I ca
n think of is to run a trace and capture all the events before the block occ
urs so that we can identify the cause of the blocking..."DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:A008E96F-84B5-4D89-935A-C6B0C6C7A113@.microsoft.com...
> About once or twice a week, our SQL server stops responding. When this
happens, we are not able to connect to it via EM or QA. The only solution at
this point is to restart the SQL Service. The SQL errorlog always shows the
following type of error after this happens:
> Process ID 72:167 owns resources that are blocking processes on Scheduler
3.
> I am finding it hard to troubleshoot this because there is essentially no
way to find out what process is causing the blocking. I know what the SPID
causing the blocking was, but due to the restart of SQLService, I don't know
what it was actually doing.
> Can anyone shed more light on this problem? The only potential solution I
can think of is to run a trace and capture all the events before the block
occurs so that we can identify the cause of the blocking...
>
I would suggest that you turn on the SQL Server Profiler and let it capture
the database activity. By doing so, you should be able to see what was
happening in the server when it finally locks up. That should give you
some direction to start in.
Rick Sawtell
MCT, MCSD, MCDBA
ns, we are not able to connect to it via EM or QA. The only solution at this
point is to restart the SQL Service. The SQL errorlog always shows the foll
owing type of error after t
his happens:
Process ID 72:167 owns resources that are blocking processes on Scheduler 3.
I am finding it hard to troubleshoot this because there is essentially no wa
y to find out what process is causing the blocking. I know what the SPID cau
sing the blocking was, but due to the restart of SQLService, I don't know wh
at it was actually doing.
Can anyone shed more light on this problem? The only potential solution I ca
n think of is to run a trace and capture all the events before the block occ
urs so that we can identify the cause of the blocking..."DBA72" <DBA72@.discussions.microsoft.com> wrote in message
news:A008E96F-84B5-4D89-935A-C6B0C6C7A113@.microsoft.com...
> About once or twice a week, our SQL server stops responding. When this
happens, we are not able to connect to it via EM or QA. The only solution at
this point is to restart the SQL Service. The SQL errorlog always shows the
following type of error after this happens:
> Process ID 72:167 owns resources that are blocking processes on Scheduler
3.
> I am finding it hard to troubleshoot this because there is essentially no
way to find out what process is causing the blocking. I know what the SPID
causing the blocking was, but due to the restart of SQLService, I don't know
what it was actually doing.
> Can anyone shed more light on this problem? The only potential solution I
can think of is to run a trace and capture all the events before the block
occurs so that we can identify the cause of the blocking...
>
I would suggest that you turn on the SQL Server Profiler and let it capture
the database activity. By doing so, you should be able to see what was
happening in the server when it finally locks up. That should give you
some direction to start in.
Rick Sawtell
MCT, MCSD, MCDBA
Wednesday, March 7, 2012
Block a truncate command
Is there any way to block a truncate command on a table via a trigger or
something else in MS SQL Server 2000?
Thanks,
--
JasonHere's a quote from Books Online:
"TRUNCATE TABLE permissions default to the table owner, members of the
sy
min fixed server role, and the db_owner and db_ddladmin fixed database
roles, and are not transferable."
Are you worried about the above users executing a TRUNCATE TABLE command?
Also note that this command cannot be run against a table that is referenced
by foreign key.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:9E2D92A7-C397-4538-9574-1133F9B37B33@.microsoft.com...
> Is there any way to block a truncate command on a table via a trigger or
> something else in MS SQL Server 2000?
> Thanks,
> --
> Jason|||If you don't want the table truncated, then don't issue the truncte in the
first place.
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:9E2D92A7-C397-4538-9574-1133F9B37B33@.microsoft.com...
> Is there any way to block a truncate command on a table via a trigger or
> something else in MS SQL Server 2000?
> Thanks,
> --
> Jason|||No.
Try better user/permissions management.
Do you have people that have been given sy
min or dbo privileges and are
going to go in and issue unauthorized TRUNCATE commands? I think you need
to fix that problem instead of trying to patch the symptom...
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:9E2D92A7-C397-4538-9574-1133F9B37B33@.microsoft.com...
> Is there any way to block a truncate command on a table via a trigger or
> something else in MS SQL Server 2000?
> Thanks,
> --
> Jason|||I want them to be able to truncate some tables, but not others.
--
Jason
"Aaron Bertrand [SQL Server MVP]" wrote:
> No.
> Try better user/permissions management.
> Do you have people that have been given sy
min or dbo privileges and are
> going to go in and issue unauthorized TRUNCATE commands? I think you need
> to fix that problem instead of trying to patch the symptom...
>
>
> "JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
> news:9E2D92A7-C397-4538-9574-1133F9B37B33@.microsoft.com...
>
>|||But only the table owner can truncate anyhow. Are you saying that these user
s act as dbo, the object
owner, db_owner or sy
min in your system?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:76E0D204-6026-4BDB-8B54-F384FF67556A@.microsoft.com...
>I want them to be able to truncate some tables, but not others.
> --
> Jason
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
something else in MS SQL Server 2000?
Thanks,
--
JasonHere's a quote from Books Online:
"TRUNCATE TABLE permissions default to the table owner, members of the
sy
roles, and are not transferable."
Are you worried about the above users executing a TRUNCATE TABLE command?
Also note that this command cannot be run against a table that is referenced
by foreign key.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:9E2D92A7-C397-4538-9574-1133F9B37B33@.microsoft.com...
> Is there any way to block a truncate command on a table via a trigger or
> something else in MS SQL Server 2000?
> Thanks,
> --
> Jason|||If you don't want the table truncated, then don't issue the truncte in the
first place.
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:9E2D92A7-C397-4538-9574-1133F9B37B33@.microsoft.com...
> Is there any way to block a truncate command on a table via a trigger or
> something else in MS SQL Server 2000?
> Thanks,
> --
> Jason|||No.
Try better user/permissions management.
Do you have people that have been given sy
going to go in and issue unauthorized TRUNCATE commands? I think you need
to fix that problem instead of trying to patch the symptom...
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:9E2D92A7-C397-4538-9574-1133F9B37B33@.microsoft.com...
> Is there any way to block a truncate command on a table via a trigger or
> something else in MS SQL Server 2000?
> Thanks,
> --
> Jason|||I want them to be able to truncate some tables, but not others.
--
Jason
"Aaron Bertrand [SQL Server MVP]" wrote:
> No.
> Try better user/permissions management.
> Do you have people that have been given sy
> going to go in and issue unauthorized TRUNCATE commands? I think you need
> to fix that problem instead of trying to patch the symptom...
>
>
> "JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
> news:9E2D92A7-C397-4538-9574-1133F9B37B33@.microsoft.com...
>
>|||But only the table owner can truncate anyhow. Are you saying that these user
s act as dbo, the object
owner, db_owner or sy
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"JasonDWilson" <JasonDWilson@.discussions.microsoft.com> wrote in message
news:76E0D204-6026-4BDB-8B54-F384FF67556A@.microsoft.com...
>I want them to be able to truncate some tables, but not others.
> --
> Jason
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
Sunday, February 19, 2012
Blank space in Folder Name causes web service error
Hello,
When I try to pull a report via the RS web service from a folder
with a space in the name (i.e. "My Folder"), an error stating the
report cannot be found is thrown. If I rename the folder to "MyFolder"
then it works fine. I tried using %20 instead of the space in the path
setting but this does not work. Is there a way to allow having a space
in the folder name? We have many folders and need the ability to name
them with multiple words seperated by spaces.
Thank youTry using a '+' in place of spaces
ie. My+Folder
On Aug 22, 11:19 am, daves...@.hotmail.com wrote:
> Hello,
> When I try to pull a report via the RS web service from a folder
> with a space in the name (i.e. "My Folder"), an error stating the
> report cannot be found is thrown. If I rename the folder to "MyFolder"
> then it works fine. I tried using %20 instead of the space in the path
> setting but this does not work. Is there a way to allow having a space
> in the folder name? We have many folders and need the ability to name
> them with multiple words seperated by spaces.
> Thank you|||On Aug 23, 10:01 am, Jen <jlan...@.gmail.com> wrote:
> Try using a '+' in place of spaces
> ie. My+Folder
> On Aug 22, 11:19 am, daves...@.hotmail.com wrote:
>
> > Hello,
> > When I try to pull a report via the RS web service from a folder
> > with a space in the name (i.e. "My Folder"), an error stating the
> > report cannot be found is thrown. If I rename the folder to "MyFolder"
> > then it works fine. I tried using %20 instead of the space in the path
> > setting but this does not work. Is there a way to allow having a space
> > in the folder name? We have many folders and need the ability to name
> > them with multiple words seperated by spaces.
> > Thank you- Hide quoted text -
> - Show quoted text -
We tried using a + instead of space but still no joy.
When I try to pull a report via the RS web service from a folder
with a space in the name (i.e. "My Folder"), an error stating the
report cannot be found is thrown. If I rename the folder to "MyFolder"
then it works fine. I tried using %20 instead of the space in the path
setting but this does not work. Is there a way to allow having a space
in the folder name? We have many folders and need the ability to name
them with multiple words seperated by spaces.
Thank youTry using a '+' in place of spaces
ie. My+Folder
On Aug 22, 11:19 am, daves...@.hotmail.com wrote:
> Hello,
> When I try to pull a report via the RS web service from a folder
> with a space in the name (i.e. "My Folder"), an error stating the
> report cannot be found is thrown. If I rename the folder to "MyFolder"
> then it works fine. I tried using %20 instead of the space in the path
> setting but this does not work. Is there a way to allow having a space
> in the folder name? We have many folders and need the ability to name
> them with multiple words seperated by spaces.
> Thank you|||On Aug 23, 10:01 am, Jen <jlan...@.gmail.com> wrote:
> Try using a '+' in place of spaces
> ie. My+Folder
> On Aug 22, 11:19 am, daves...@.hotmail.com wrote:
>
> > Hello,
> > When I try to pull a report via the RS web service from a folder
> > with a space in the name (i.e. "My Folder"), an error stating the
> > report cannot be found is thrown. If I rename the folder to "MyFolder"
> > then it works fine. I tried using %20 instead of the space in the path
> > setting but this does not work. Is there a way to allow having a space
> > in the folder name? We have many folders and need the ability to name
> > them with multiple words seperated by spaces.
> > Thank you- Hide quoted text -
> - Show quoted text -
We tried using a + instead of space but still no joy.
Tuesday, February 14, 2012
Blackberry Server MSDE and active directory authentication
To all, thanks in advance,
I have blackberry server running sql msde 2000 (sp4), which is
authenticated via windows integrated with an active directory user
account. When I changed the password on said user account, restart the
mssqlserver service, it fails to start with a 560 error. I had to
changed said user account back to the old password in order for the
mssqlserver service to start. I wanted know where in ms sql msde 2000,
I needed to make the change in order for this service to start. I also
tried starting the service using local system account and it would not
start either. All help with this is greatly appreciated.
JB
Hi
Control Panel > Services. The Service can be stopped and started from there,
and the account password can be changed there for the service.
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/
<jon.jefferson@.gmail.com> wrote in message
news:1131849352.800496.311170@.g47g2000cwa.googlegr oups.com...
> To all, thanks in advance,
> I have blackberry server running sql msde 2000 (sp4), which is
> authenticated via windows integrated with an active directory user
> account. When I changed the password on said user account, restart the
> mssqlserver service, it fails to start with a 560 error. I had to
> changed said user account back to the old password in order for the
> mssqlserver service to start. I wanted know where in ms sql msde 2000,
> I needed to make the change in order for this service to start. I also
> tried starting the service using local system account and it would not
> start either. All help with this is greatly appreciated.
> JB
>
|||Mike
Thanks for your response, but I did that and the service would not
start under with the new password. The only idea I did not try was to
restart the Server.
Thanks,
JB
|||Mike,
Also, there are other services that start with this same service
account (i.e. all the blackberry services,) and those start fine,
except for errors in the Apps event log because the msssqlserver
service would not start with the same user account change for some
strange reason. I am changing passwords to in AD because I am taking
over duties after someone has left and need to change passwords for
security purposes. This is my only hold up.
JB
I have blackberry server running sql msde 2000 (sp4), which is
authenticated via windows integrated with an active directory user
account. When I changed the password on said user account, restart the
mssqlserver service, it fails to start with a 560 error. I had to
changed said user account back to the old password in order for the
mssqlserver service to start. I wanted know where in ms sql msde 2000,
I needed to make the change in order for this service to start. I also
tried starting the service using local system account and it would not
start either. All help with this is greatly appreciated.
JB
Hi
Control Panel > Services. The Service can be stopped and started from there,
and the account password can be changed there for the service.
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/
<jon.jefferson@.gmail.com> wrote in message
news:1131849352.800496.311170@.g47g2000cwa.googlegr oups.com...
> To all, thanks in advance,
> I have blackberry server running sql msde 2000 (sp4), which is
> authenticated via windows integrated with an active directory user
> account. When I changed the password on said user account, restart the
> mssqlserver service, it fails to start with a 560 error. I had to
> changed said user account back to the old password in order for the
> mssqlserver service to start. I wanted know where in ms sql msde 2000,
> I needed to make the change in order for this service to start. I also
> tried starting the service using local system account and it would not
> start either. All help with this is greatly appreciated.
> JB
>
|||Mike
Thanks for your response, but I did that and the service would not
start under with the new password. The only idea I did not try was to
restart the Server.
Thanks,
JB
|||Mike,
Also, there are other services that start with this same service
account (i.e. all the blackberry services,) and those start fine,
except for errors in the Apps event log because the msssqlserver
service would not start with the same user account change for some
strange reason. I am changing passwords to in AD because I am taking
over duties after someone has left and need to change passwords for
security purposes. This is my only hold up.
JB
Labels:
active,
advance,
authentication,
blackberry,
database,
directory,
integrated,
isauthenticated,
microsoft,
msde,
mysql,
oracle,
running,
server,
sp4,
sql,
via,
windows
Subscribe to:
Posts (Atom)