Technical Article

Easily Kill All Users In A Database

This simple script (ran from the master database) in Query Analyser removes all the requirements of collating currently connected spids to a database and the need to systematically open a cursor to kill each spid individually by simply placing the database offline, then immediately online.

2 (1)

You rated this post out of 5. Change rating

2007-03-16 (first published: )

364 reads

Blogs

A New Word: Proluctance

By

proluctance – n. the paradoxical urge to avoid doing something you’ve been looking forward...

10 reasons why IT certifications are still important

By

As someone who has spent over 20 years in the Software/Data Engineering area and...

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Read the latest Blogs

Forums

Meet Claude, the new AI

By Daniel Calbimonte

Comments posted to this topic are about the item Meet Claude, the new AI

Updatable Views II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Updatable Views II

The Dangers of Not Upgrading

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Dangers of Not Upgrading

Visit the forum

Question of the Day

Updatable Views II

I have this view:

CREATE OR ALTER VIEW dbo.City 
AS
SELECT TOP 10 
 cn.CityNameID, cn.CityName
 FROM dbo.CityName AS cn
 WITH CHECK OPTION
GO
How can I modify the view to make it is updatable with this code?
INSERT City (CityName) VALUES ('Dillon')

See possible answers