From SSMS Object Explorer, you can also right clicks on a database and set the 'Restrict Access' propery from the default 'MULTI_USER' value 'RESTRICTED_USER', which will achieve the same result...

The following statement can be used to kill a specific connection:

KILL <SPID>

If what you're trying to do is terminate all connections on a specific database, while allowing a couple minutes...

LightVader (6/21/2016)

---

Eric M Russell (6/20/2016)

---

Jeff Moden (6/20/2016)

---

Eric M Russell (6/20/2016)

---

Jeff Moden (6/17/2016)

---

As a bit of a sidebar and like anything else in SQL Server, saying something like the use of...

Gene Roddenberry invented the floppy disk, just like invented the smart...

I'm sure that scribes in ancient Egypt saw papyrus as an innovation over clay tablets. However, today most of what we know about Egypt comes from the clay tablets as...

So this basically just T-SQL with additional extensions for sourcing from or outputting to flat files and also perhaps analytical functions?

It's easy to give away millions when you have billions; you just setup a charity, skim a small percentage of profit off the top, and appoint other people to muck...

chris 24158 (6/17/2016)

---

The latest series of posts you enjoy so much from Microsoft says:

I can’t emphasize this patch enough. There is a MSVC, runtime library patch needed by...

Jeff Moden (6/20/2016)

---

Eric M Russell (6/20/2016)

---

Jeff Moden (6/17/2016)

---

As a bit of a sidebar and like anything else in SQL Server, saying something like the use of SELECT * always being...

In addition to table scans, another common problem is hash match joins, which occur when SQL Server builds up an index on the fly, consuming time and tempdb storage, when...

Jeff Moden (6/17/2016)

---

As a bit of a sidebar and like anything else in SQL Server, saying something like the use of SELECT * always being bad is the wrong thing...

Jason A. Long (6/17/2016)

---

Eric M Russell (6/17/2016)

---

Using index operational stats, if you see an index where the total writes exceeds the total reads, then it probably useless. But generally speaking,...

Using index operational stats, if you see an index where the total writes exceeds the total reads, then it probably useless. But generally speaking, I'm comfortable with non-clustered indexes contributing...

Jeff Moden (6/16/2016)

---

HappyGeek (10/21/2015)

---

Not quite sure this is the right place for this, forgive me if I have it wrong. :blush:

To rapidly document a database I open Excel, start...

Steve Jones - SSC Editor (6/15/2016)

---

TheFault (6/15/2016)

---

Having worked at a company who are supposed 'industry experts' in data security, I can tell you it is no better behind closed doors...