Force shutdown of SQL Server Instance

I have a problem with an instance of SQL Server that refuses to
respond to a shutdown request. I've managed to shutdown the SQL
Manager and DTC services but the sqlservr.exe process is permanently
in a "Stopping" state.

I cannot logon to the instance to issue a SHUTDOWN WITH NOWAIT
command. Short of rebooting the entire server, is there a way I can
force the process to end?

TonyHi

You may want to try and stop the service in the services applet or issue
a NET STOP command.

If you do not shut down the server cleanly there may be problems when
you try to restart the service.

John

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||There will never be problems from killing the process, shutting down the
machine, etc. However, the restart may be slower as recovery will be
required before user connections are allowed. Of course, the reason for
the slow shutdown may also be the rollback of a very long running
transaction.

On Fri, 19 Sep 2003 12:32:13 +0000, John Bell wrote:

> Hi
> You may want to try and stop the service in the services applet or issue
> a NET STOP command.
> If you do not shut down the server cleanly there may be problems when
> you try to restart the service.
> John
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi Hal

The poster was thinking of a hardware re-boot, which could cause hardware
related problems and other non-sql server problems. Put server instead of
service as the last word of the last sentence.

John

"Hal Berenson" <haroldb@.truemountainconsulting.com> wrote in message
news:pan.2003.09.21.03.51.13.628241@.truemountainco nsulting.com...
> There will never be problems from killing the process, shutting down the
> machine, etc. However, the restart may be slower as recovery will be
> required before user connections are allowed. Of course, the reason for
> the slow shutdown may also be the rollback of a very long running
> transaction.
> On Fri, 19 Sep 2003 12:32:13 +0000, John Bell wrote:
> > Hi
> > You may want to try and stop the service in the services applet or issue
> > a NET STOP command.
> > If you do not shut down the server cleanly there may be problems when
> > you try to restart the service.
> > John
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!

Force list to stay in same place on repeat pages?

Is there some way to force a list (or table) to print in the same place
on repeat pages as it does on the first page?
Say for instance on the first page the list starts 2 inches from the
top, can I make it so on continuation pages the list always starts 2
inches from the top? Instead of starting from the top of the second
page?
What I really need is for the list to always print in a fixed
rectangle, say start 2 inches from the top, and stop 2 inches from the
bottom. Even on the continuation pages. Is this possible?
thanks-JimCan you just do this by adding page headers and footers to the report that
will regulate this? Or are there other complexities to your report that are
not mentioned?
--
Douglas McDowell douglas@.nospam.solidqualitylearning.com
"jim_slc" <jim_slc@.yahoo.com> wrote in message
news:1135899791.488352.157070@.g47g2000cwa.googlegroups.com...
> Is there some way to force a list (or table) to print in the same place
> on repeat pages as it does on the first page?
> Say for instance on the first page the list starts 2 inches from the
> top, can I make it so on continuation pages the list always starts 2
> inches from the top? Instead of starting from the top of the second
> page?
> What I really need is for the list to always print in a fixed
> rectangle, say start 2 inches from the top, and stop 2 inches from the
> bottom. Even on the continuation pages. Is this possible?
> thanks-Jim
>|||Thanks for the reply Douglas. Once I figured out that having the
header/body/trailer fill the whole page I got it close enough.

for instance: How do I get the quantity of the last Date for every Location ?

Hello,

How do I get the quantity of the last Date for every Location ?
See example given:

select
[Measures].[Quantity] on columns,
(
nonemptycrossjoin(
[Location].[Location].[Location]
, [Posting Date].[Posting Date]
, 2
)
)
on rows
from
[Logistics]

This query will give me the following result:

Locations

Date

Quantity

Location A

2006-01-01

5

Location A

2006-01-05

3

Location A

2006-01-07

7

Location B

2006-01-01

2

Location B

2006-02-05

3

Location C

2006-01-01

2

Location C

2006-01-01

2

Location C

2006-01-02

3

Location C

2006-01-03

3

This is what I want

Location A

2006-01-07

7

Location B

2006-02-05

3

Location C

2006-01-03

3

Kind regards.

You should take a look at LastNonEmpty aggregation function in AS2005. It does exactly what you need.

|||Let me refine this with another example:

Date	Location	Horz. Group	Horz. Code	Vert. Group	Vert. Code	Item	Quantity
2006-1-1	A	6	1	5	1	I10256	1
2006-1-2	A	6	1	5	1	I10256	2
2006-1-3	A	6	1	5	1	I10256	3
2006-1-1	B	6	1	5	1	I10256	4
2006-1-3	B	6	1	5	1	I10256	5
2006-1-1	B	6	1	5	2	I10256	6

The actual supply-result for the year 2006 = 3 + 5 + 6 = 14 (this is correct)
The LastNonEmpty-result in AS2005 = 3 + 5 = 8 (this is not correct, eg. is not sorted by date as you can see but doesn't matter :o)
I actually wanna have the LastNonEmpty grouped by [Date],[Location],[Horz etc],[Vert etc],[Item] ?
How can I force the LastNonEmpty to do that ? Not only Time-related !?
I wanna see the correct supplies in my time-dimension on the level year or month or day :o)
Kind regards.