Here's a handy little script for killing open connections to a database in SQL Server:
USE
[master]
GO
IF
EXISTS (SELECT [name] FROM sys.databases WHERE [name] = N'YOUR_DATABASE_NAME')
BEGIN
DECLARE @spidstr VARCHAR(8000)
DECLARE @ConnKilled SMALLINT
SET @ConnKilled = 0
SET @spidstr = ''
IF DB_ID('YOUR_DATABASE_NAME') < 4
BEGIN
PRINT 'Connections to system databases cannot be killed'
RETURN
END
SELECT @spidstr = COALESCE(@spidstr, ',') + 'kill ' + CONVERT(VARCHAR, spid) + '; ' FROM master..sysprocesses WHERE dbid = DB_ID('YOUR_DATABASE_NAME')
IF LEN(@spidstr) > 0
BEGIN
EXEC(@spidstr)
SELECT @ConnKilled = COUNT(1) FROM master..sysprocesses WHERE dbid = DB_ID('YOUR_DATABASE_NAME')
END
PRINT CONVERT(VARCHAR(10), @ConnKilled) + ' Connection(s) killed for DB YOUR_DATABASE_NAME'
END
GO
The UMPC is a new toy that we might start seeing around soon. Quick summary of what's packed:
- Windows XP Tablet PC Edition 2005 OS
- Approximately 7” diagonal display (or smaller)
- Minimum 800 x 480 resolution
- Approximately 2 pounds
- Integrated touch panel
- WiFi- and Bluetooth-enabled
The J# redistributable libraries, vjslib.dll, contains amongst others two areas of functionality that is very commonly looked for:
I often see people using third party tools just because no one knows about this - in fact, these are so often needed that I think it would make sense for Microsoft to include them in the .NET Framework.