Hi there !
I need to find the Hotfix as stated in this artickel Knowledge Base-article - 829386
(You Cannot Install MSDE 2000 if the Server Service Is Not Running)
http://support.microsoft.com/default...b;en-us;829386
anyone know where to find it ?
You need to call Microsoft to get this hotfix, they do not generally post these fixes on web as they say these are not tested a lot. So when you call em they will email you the file along with the instructions. The kb article has the link to Microsoft'
s phone numbers.
good luck
dev
|||Yes, did you read the article? Since the hotfix is not fully regression
tested, you need to open a specific case with Microsoft in order to receive
the fix.
<snip>
To resolve this problem immediately, contact Microsoft Product Support
Services to obtain the hotfix. For a complete list of Microsoft Product
Support Services phone numbers and information about support costs, visit
the following Microsoft Web site:
http://support.microsoft.com/default.aspx?scid=fh;[LN];CNTACTMS
</snip>
Usually you will not be charged for the call, since the issue has been
confirmed by Microsoft to be a bug. However I would make sure that you
can't work around the problem in other ways (e.g. maybe starting the Server
service?).
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Troels Majlandt" <tm@.dfif.dk> wrote in message
news:36A784EB-2F40-4329-A719-0EFF53FF3929@.microsoft.com...
> Hi there !
> I need to find the Hotfix as stated in this artickel Knowledge
> Base-article - 829386
> (You Cannot Install MSDE 2000 if the Server Service Is Not Running)
> http://support.microsoft.com/default...b;en-us;829386
> anyone know where to find it ?
Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts
Friday, March 30, 2012
Wednesday, March 21, 2012
Kill a SQL process
Hi, I hope someone can help.
We are using SQL MSDE on a SBS2003 server for monitoring purposes. There is
a small problem with one of the SQL processes leaking memory. I need to be
able search for and kill a connection from the Firewall service to the maste
r
table.
I am doing this as a scheduled job within SQL Enterprise Manager. I can
successfully track down the SPID of the connection that I want to kill. I
just don't know how to go about killing it.
Here is the code I already have;
USE master;
SELECT spid
FROM sysprocesses
WHERE memusage>40000
AND dbid=1
Could someone tell me please how to kill this connection now that i have the
SPID?
My thanks in advance.
Chris.run a cursor on the select that u have written.
get the result into a variable say @.spid
and just use the command
KILL @.spid|||give the command
kill 123
where 123 is the spid|||sorry about that outburst :)
try this
USE master;
declare @.rowcount int
,@.spid int
while (@.rowcount >0)
begin
SELECT top 1 @.spid = spid
FROM sysprocesses
WHERE
memusage>40000 AND
dbid=1
set @.rowcount = @.@.rowcount
exec('kill ' + @.spid)
end
let me know if it helps|||Thanks, i appreciate your quick reply
Please excuse my ignorance but I do not know how to do this. I have never
used SQL before so I am not familiar with commands and syntax.
How do I get the result into the variable?
Do I have to declare the variable first, if so how?
What do you mean, run a cursor?
"Arumugam" wrote:
> run a cursor on the select that u have written.
> get the result into a variable say @.spid
> and just use the command
> KILL @.spid
>|||declare @.spid int,
@.qry varchar(20)
declare c1 cursor for
SELECT spid
FROM sysprocesses
WHERE memusage>40000
AND dbid=1
open c1
fetch next from c1 into @.spid
while @.@.fetch_status = 0
begin
select @.qry = 'KILL ' + cast (@.spid as varchar(10))
exec(@.qry)
fetch next from c1 into @.spid
end
close c1
deallocate c1|||Thanks for the code. Don't worry about the 'outburst' it wasn't as harsh as
I
was expecting. I tried it but it doesn't kill the process.
I'm nearly at the point of understanding the code below, I just don't get
why the @.rowcount is in there. What would it's initial value be? and where
does that come from? Is this the reason it doesn't work?
Sorry if I sound daft. I'm not. Just really new to SQL.
"Omnibuzz" wrote:
> sorry about that outburst :)
> try this
> USE master;
> declare @.rowcount int
> ,@.spid int
> while (@.rowcount >0)
> begin
> SELECT top 1 @.spid = spid
> FROM sysprocesses
> WHERE
> memusage>40000 AND
> dbid=1
> set @.rowcount = @.@.rowcount
> exec('kill ' + @.spid)
> end
> let me know if it helps|||It should read @.@.rowcount. It's a system global variable containing the
number of rows affected by the last DML statement.
ML
http://milambda.blogspot.com/|||Which instance of @.rowcount should be @.@.rowcount?|||Thanks for the help you three.
I got it working now. No need for the WHILE statement in there. Unless I've
missunderstood?
Cheers,
Chris.
"Chris ONeill" wrote:
> Thanks for the code. Don't worry about the 'outburst' it wasn't as harsh a
s I
> was expecting. I tried it but it doesn't kill the process.
> I'm nearly at the point of understanding the code below, I just don't get
> why the @.rowcount is in there. What would it's initial value be? and where
> does that come from? Is this the reason it doesn't work?
> Sorry if I sound daft. I'm not. Just really new to SQL.
> "Omnibuzz" wrote:
>
We are using SQL MSDE on a SBS2003 server for monitoring purposes. There is
a small problem with one of the SQL processes leaking memory. I need to be
able search for and kill a connection from the Firewall service to the maste
r
table.
I am doing this as a scheduled job within SQL Enterprise Manager. I can
successfully track down the SPID of the connection that I want to kill. I
just don't know how to go about killing it.
Here is the code I already have;
USE master;
SELECT spid
FROM sysprocesses
WHERE memusage>40000
AND dbid=1
Could someone tell me please how to kill this connection now that i have the
SPID?
My thanks in advance.
Chris.run a cursor on the select that u have written.
get the result into a variable say @.spid
and just use the command
KILL @.spid|||give the command
kill 123
where 123 is the spid|||sorry about that outburst :)
try this
USE master;
declare @.rowcount int
,@.spid int
while (@.rowcount >0)
begin
SELECT top 1 @.spid = spid
FROM sysprocesses
WHERE
memusage>40000 AND
dbid=1
set @.rowcount = @.@.rowcount
exec('kill ' + @.spid)
end
let me know if it helps|||Thanks, i appreciate your quick reply
Please excuse my ignorance but I do not know how to do this. I have never
used SQL before so I am not familiar with commands and syntax.
How do I get the result into the variable?
Do I have to declare the variable first, if so how?
What do you mean, run a cursor?
"Arumugam" wrote:
> run a cursor on the select that u have written.
> get the result into a variable say @.spid
> and just use the command
> KILL @.spid
>|||declare @.spid int,
@.qry varchar(20)
declare c1 cursor for
SELECT spid
FROM sysprocesses
WHERE memusage>40000
AND dbid=1
open c1
fetch next from c1 into @.spid
while @.@.fetch_status = 0
begin
select @.qry = 'KILL ' + cast (@.spid as varchar(10))
exec(@.qry)
fetch next from c1 into @.spid
end
close c1
deallocate c1|||Thanks for the code. Don't worry about the 'outburst' it wasn't as harsh as
I
was expecting. I tried it but it doesn't kill the process.
I'm nearly at the point of understanding the code below, I just don't get
why the @.rowcount is in there. What would it's initial value be? and where
does that come from? Is this the reason it doesn't work?
Sorry if I sound daft. I'm not. Just really new to SQL.
"Omnibuzz" wrote:
> sorry about that outburst :)
> try this
> USE master;
> declare @.rowcount int
> ,@.spid int
> while (@.rowcount >0)
> begin
> SELECT top 1 @.spid = spid
> FROM sysprocesses
> WHERE
> memusage>40000 AND
> dbid=1
> set @.rowcount = @.@.rowcount
> exec('kill ' + @.spid)
> end
> let me know if it helps|||It should read @.@.rowcount. It's a system global variable containing the
number of rows affected by the last DML statement.
ML
http://milambda.blogspot.com/|||Which instance of @.rowcount should be @.@.rowcount?|||Thanks for the help you three.
I got it working now. No need for the WHILE statement in there. Unless I've
missunderstood?
Cheers,
Chris.
"Chris ONeill" wrote:
> Thanks for the code. Don't worry about the 'outburst' it wasn't as harsh a
s I
> was expecting. I tried it but it doesn't kill the process.
> I'm nearly at the point of understanding the code below, I just don't get
> why the @.rowcount is in there. What would it's initial value be? and where
> does that come from? Is this the reason it doesn't work?
> Sorry if I sound daft. I'm not. Just really new to SQL.
> "Omnibuzz" wrote:
>
Kicking off replication agents with Script
Hi all,
I have 5 laptops, 1 laptop with SQL Server 2000 and the other 4 with SQL Server MSDE Rel A. I had a "Merge Replication" scheme that I had to set up. The laptop with 2000 will be the main Publisher/distributor and publishes/merges to two of the MSDE laptops(these laptops have pull subscriptions that pull from the 2000 laptop). These 2 MSDE laptops in turn Re-publish their data to the last 2 laptops and my scheme ends there. I have succesfully been able to Script this entire "Merge Replication" scheme, and I ran it. It creates all Components needed for my scheme to work.
1 issue though. It doesnt kick start the agents :eek: , so the replication scheme is just dormant.
Does anyone have any examples of scripts that I could use to kick off all the agents (snapshot,merge agents etc) and maybe to stop them too. I seriously need this, because we will need to have the entire process scripted.
Thanks
'Wale
p.s.
Also does anyone have sample scripts to alter settings for the SQL SERVER AGENT, for example altering its "Log On" parameter to allow a particular user with Admin privileges and also to switch its start mode to "Automatic"Has anyone used the "sp_startpublication_snapshot" procedure. When the Snapshot Agent is started, does this mean all other Agents automatically start - up?
I have 5 laptops, 1 laptop with SQL Server 2000 and the other 4 with SQL Server MSDE Rel A. I had a "Merge Replication" scheme that I had to set up. The laptop with 2000 will be the main Publisher/distributor and publishes/merges to two of the MSDE laptops(these laptops have pull subscriptions that pull from the 2000 laptop). These 2 MSDE laptops in turn Re-publish their data to the last 2 laptops and my scheme ends there. I have succesfully been able to Script this entire "Merge Replication" scheme, and I ran it. It creates all Components needed for my scheme to work.
1 issue though. It doesnt kick start the agents :eek: , so the replication scheme is just dormant.
Does anyone have any examples of scripts that I could use to kick off all the agents (snapshot,merge agents etc) and maybe to stop them too. I seriously need this, because we will need to have the entire process scripted.
Thanks
'Wale
p.s.
Also does anyone have sample scripts to alter settings for the SQL SERVER AGENT, for example altering its "Log On" parameter to allow a particular user with Admin privileges and also to switch its start mode to "Automatic"Has anyone used the "sp_startpublication_snapshot" procedure. When the Snapshot Agent is started, does this mean all other Agents automatically start - up?
Subscribe to:
Posts (Atom)