mssql 2000 kill all user connection for restore

i need a sql statment or procedure to kill all user connection to one database.
And Deny new connection for a little time.
So i can a restore this database from a dump.

I can this do only in exclusiv modus. without any other connection.

Can anybody help me??

thanks and best regards from Berlin, Germanydeclare @.l_spid varchar(4)
,@.l_hostname varchar(20)
,@.dbname varchar(256)

select @.dbname = 'YOUR DATABASE NAME HERE'
declare kill_cursor scroll cursor
for
select convert(varchar(4), spid), hostname from master..sysprocesses with (nolock)
where db_name(dbid) = @.dbname

open kill_cursor
select @.@.cursor_rows

fetch next from kill_cursor into
@.l_spid
,@.l_hostname
while (@.@.fetch_status = 0 )
begin
select @.l_hostname Killed
exec ( 'kill ' + @.l_spid)
fetch next from kill_cursor into
@.l_spid
,@.l_hostname
end
close kill_cursor
deallocate kill_cursor
RESTORE STATEMENT HERE|||thanks i can use the code in my procedure.

Cu ... trapezz|||alter database DBName
set SINGLE_USER with rollback immediate|||I prefer

ALTER DATABASE dbName SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Mssearch.exe consuming High CPU over extended time period

Hello,
We are running SQL 2000 sp4 with full text search, recently we are
getting 100% CPU over extended period of time and the only way to
resolve this is by killing the Mssearch.exe process. (we tried to
restart the service but it hang) the Microsoft search service is
running under local system account.
our system topology is active/passive cluster with NAS disks, 4GB RAM
and 4 CPU for each server.
May be some one can help me?
The issue happen randomly with no specific job running at that time or
any thing, and when it happen the SQL queries are running very very
slow.
Thank you

No solution to your particular problem, except looking at a prioir post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=93706&SiteID=1

In your particular case, when did the problem start? After upgrade, some configuration change, resource change, database size change?

This may help understand the problem.

Thanks,
Boris.|||I asked our dev team and there are no known problems of this kind. I would recommend contacting product support services and have them look at your particular configuration. Most likely the problem you are seeing is caused by the content being indexed.|||Hi,
We appear to be experiencing the same thing. There is no disk activity - just mssearch running at 100% utilization.
Have you found an answer yet?|||We used Microsoft support and nothing found we tried rebuild all catalogs , Fix some snapshot problem on the NAS and still we got the same problem finally we changed the affinity mask of the Mssearch and the SQL (SQL use CPU 1 and 2 and Mssearch the rest) we are still waiting to see if it help to solve the problem for now (4 days) it look fine even though the Mssearch took 100% the SQL continue to give services and the CPU drop back to normal with out human interference. So I will have more clear answer with in a week.

Mssearch.exe consuming High CPU over extended time period

Hello,
We are running SQL 2000 sp4 with full text search, recently we are
getting 100% CPU over extended period of time and the only way to
resolve this is by killing the Mssearch.exe process. (we tried to
restart the service but it hang) the Microsoft search service is
running under local system account.
our system topology is active/passive cluster with NAS disks, 4GB RAM
and 4 CPU for each server.
May be some one can help me?
The issue happen randomly with no specific job running at that time or
any thing, and when it happen the SQL queries are running very very
slow.
Thank you

No solution to your particular problem, except looking at a prioir post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=93706&SiteID=1

In your particular case, when did the problem start? After upgrade, some configuration change, resource change, database size change?

This may help understand the problem.

Thanks,
Boris.|||I asked our dev team and there are no known problems of this kind. I would recommend contacting product support services and have them look at your particular configuration. Most likely the problem you are seeing is caused by the content being indexed.|||Hi,
We appear to be experiencing the same thing. There is no disk activity - just mssearch running at 100% utilization.
Have you found an answer yet?
|||We used Microsoft support and nothing found we tried rebuild all catalogs , Fix some snapshot problem on the NAS and still we got the same problem finally we changed the affinity mask of the Mssearch and the SQL (SQL use CPU 1 and 2 and Mssearch the rest) we are still waiting to see if it help to solve the problem for now (4 days) it look fine even though the Mssearch took 100% the SQL continue to give services and the CPU drop back to normal with out human interference. So I will have more clear answer with in a week.

Msg 7619, Level 16, State 1, Line 1

i have a C# program which connect to sql 2k
each time i use any arabic word in search i got the following error
Msg 7619, Level 16, State 1, Line 1
*** Sent via Developersdex http://www.codecomments.com ***
what are your globalization settings in your web.config file? Try something
like.
<globalization requestEncoding="utf-8" responseEncoding="utf-8"
culture="ar-SA" uiCulture= "ar" />
Also is your page template directive setting the following?
<%@. Page ResponseEncoding="UTF-8" RequestEncoding="UTF-8" Culure="ar-SA"
uiCulture="ar" %>
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Amaal Ali" <eng_moli@.hotmail.com> wrote in message
news:uc4R3cHGGHA.3952@.TK2MSFTNGP10.phx.gbl...
> i have a C# program which connect to sql 2k
> each time i use any arabic word in search i got the following error
> Msg 7619, Level 16, State 1, Line 1
>
> *** Sent via Developersdex http://www.codecomments.com ***
|||Thanks Alot Mr Hilary Cotter about ur concerning
but i got this msg through Query Analyzr not program only
finally i got the soluation
as
i have to set the "language for word breaker " to Neutral option
when i add the required column to My index Catalog
Thanks Again
*** Sent via Developersdex http://www.codecomments.com ***
|||Thanks Alot Mr Hilary Cotter about ur concerning
but i got this msg through Query Analyzr not program only
finally i got the soluation
as
i have to set the "language for word breaker " to Neutral option
when i add the required column to My index Catalog
Thanks Again
*** Sent via Developersdex http://www.codecomments.com ***

MSDTC on Windows Server 2003

I am running a sql server 2000 cluster on a windows server 2003
machine. Every time I try to install MSDTC it fails and this is what
is in the Event Viewer:
MS DTC setup failed to populate the shared cluster registry. The DTC
resource will not be able to come online.Error Specifics:
d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphel per.cpp:120,
CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 880 -m 884 -p 1204, Pid:
2524
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
The Event ID is 4389. The Source is MS DTC Client.
I've clicked on the link and Microsoft "does not have any more
information at this time."
Can anyone tell me what the problem is?
Thanks
JF
Sorry, but you need to install DTC (to W2K3) and MSDTC before installing SQL2K
on a W2K3 Cluster.
Try articles 817064 and 301600.
Gone are the nice days of running comclust.exe (as in W2K) !
Cheers
LM
On 06/05/2004 jf@.uk.com wrote:
>I am running a sql server 2000 cluster on a windows server 2003
>machine. Every time I try to install MSDTC it fails and this is what
>is in the Event Viewer:
>
>MS DTC setup failed to populate the shared cluster registry. The DTC
>resource will not be able to come online.Error Specifics:
>d:\nt\com\complus\dtc\shared\mtxclu\mtxclusetuphe lper.cpp:120,
>CmdLine: "C:\WINDOWS\cluster\resrcmon.exe" -e 880 -m 884 -p 1204, Pid:
>2524
>For more information, see Help and Support Center at
>http://go.microsoft.com/fwlink/events.asp.
>
>The Event ID is 4389. The Source is MS DTC Client.
>I've clicked on the link and Microsoft "does not have any more
>information at this time."
>Can anyone tell me what the problem is?
>
>Thanks
>JF
Cheers
LM

msdtc is down

The resource msdtc is down. Every time, it works pretty well , after we restart the servers(node1 and node2). But, about half a hour later, the problem is there. We reintalled msdtc. It didn't work out too. msdtc and sql server is on a cluster. Can anyone help me out?

What has this got to do with SSIS, the title of this forum?

Have you looked at any MS DTC troubleshooting resources?

Have you looked in the event log?

MSDTC in Active/Active MSCS cluster

How do I install MSDTC in an active/active MSCS cluster environment?
If I run comclust.exe, I can only activate MSDTC on one of the nodes at a time.
I need DTC on both nodes.
(Opsys is W2K with SQL 2000)
//Mange :)DTC is a shared service and needs to run from a shared disk. It can't have multiple instances.|||What Do you mean with multiple instances? On the same disk?

There are 2 servers in the MSCS cluster.
On each physical server, there is a virtual SQL server that has it's own shared disk.

Is it possible to start DTC on both nodes at the same time in this
configuration?

Regards
Mange :)