Phil Parkin (6/28/2016)

---

Eric M Russell (6/28/2016)

---

Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source...

Check your maintenance plan. Often times it will contain truncate job and backup history.

There is a function called object_definition() that accepts object_id and then returns the T-SQL of object like stored procedures, UDF, or views. When combined with sp_msforeachdb, you can leverage it...

While we're on the topic of organizations who leverage technology to automate "grunt work", this is a funny read.

How to Snare Millions of Men with Web Bots

http://gizmodo.com/ashley-madison-code-shows-more-women-and-more-bots-1727613924

Based on the error messages provided above, it doesn't appear to be related authentication or permissions. It sounds related to the status of the source database server.

- First confirm...

Many IT organizations (OK, probably more like most), even some of the largest organizations, just don't "get" database design. Oh, they know all about networking, SAN storage, hardware, and virtualization......

roger.plowman (6/24/2016)

---

Ah, clearly you are unfamiliar with the miracle...

Umm... no. :unsure:

Maybe we can startup a SCRUM team using folks from here at SQLServerCentral.

If the interviewer knows what he's talking about, and the whole point is to spark a conversation about how the candidate approaches DDL deployment, then it's a good question. If...

In many organizations (OK probably most) the application developers create the database; both the logical and physical model. The DBA discovers that this new database will soon exist in production...

Charmer (6/23/2016)

---

Hi Friends,

I had a question during my interview, as saying that What could be the reason when I am trying to drop all these tables , views, functions, SP's...

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...