Very Computer

by CG » Sat, 25 Nov 2000 04:00:00

Tibor, Thank you - the stored procedures located at that address are just
the job(sp_dbm_kill_users). However being new to SQL could you just help
with the syntax:
Do I enter the DB name like so: &dbname='test' sysname, etc?

Sorry for the ignorance!

--

----------------------------------------------------------------------------
------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
ICON.net Limited + 44 (0) 1452 - 305303

----------------------------------------------------------------------------
--------------------------------

by **Tibor Karasz** » Sat, 25 Nov 2000 04:00:00

Craig,

You have to create the proc first. Open the text in Query Analyzer, make sure that you
are in the master database and execute. You now have a pro names sp_dbm_kill_users.

Call it like:
EXEC sp_dbm_kill_users pubs

I.e, just the database name after the proc name. If you're on SQL Server 2000, btw,
you have remove the version check in the beginning of the proc code, or amend it.
Also, there's an optional parameter, the wait parameter. See the end of the proc
source code for how to use that.

--
Tibor Karaszi, SQL Server MVP
Neil's FAQ at: http://www.sqlserverfaq.com
Please reply to the newsgroup only, not by email.

> Tibor, Thank you - the stored procedures located at that address are just
> the job(sp_dbm_kill_users). However being new to SQL could you just help
> with the syntax:
> Do I enter the DB name like so: &dbname='test' sysname, etc?

> Sorry for the ignorance!

> --

> ----------------------------------------------------------------------------
> ------------------------------
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> ICON.net Limited + 44 (0) 1452 - 305303

> ----------------------------------------------------------------------------
> --------------------------------

Very Computer

SP KILL Re: KILL SPIDS

SP KILL Re: KILL SPIDS

SP KILL Re: KILL SPIDS