I ran into this error recently while trying to clone a production database:
Msg 2601, Level 14, State 1, LineNumber
Cannot insert duplicate...
2018-11-02 (first published: 2018-10-24)
3,516 reads
Are you a prefixer? And by that I mean a developer – or DBA – who uses prefixes on object names? [DISCLAIMER:...
2018-09-24
252 reads
We ran into a funny problem not long ago, revolving around a stored procedure that was building up a dynamic...
2018-09-24 (first published: 2018-09-13)
3,194 reads
“Moneyball” has been a thing for a while now. It’s shorthand for the application of quantitative data analysis to the...
2018-09-05 (first published: 2018-08-17)
3,034 reads
Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper,...
2018-08-24 (first published: 2018-08-12)
2,008 reads
Foreign key constraints put the “relation” into relational databases. They enforce integrity by requiring that a key value referencing another...
2018-03-05
452 reads
It’s that time of year again: time to make resolutions, then try to stick to them. Sure, we could start...
2018-01-09
422 reads
The obesity epidemic is much in the news these days. The list of health issues related to being overweight is...
2017-12-27 (first published: 2017-12-13)
1,753 reads
I remember being thoroughly baffled in grade school by word problems. How in the world was I supposed to translate...
2017-12-18
347 reads
Security is very much on our minds these days. Scarcely a day goes by without hearing of a yet another...
2017-12-06 (first published: 2017-11-27)
1,572 reads
By Brian Kelley
I thought it would be good to put my thoughts down on how to...
You want the short answer? Well, the only antidote to knowledge stagnation is probably...
By Chris Yates
It always starts the same way. You open your laptop on a Monday morning,...
At the Fare facility, a NABL-approved environment pollution testing facility in India, our highly...
Comments posted to this topic are about the item Guidelines and Requirements
Comments posted to this topic are about the item Copying Production Schema
If I use DBCC CLONEDATABASE, can I remove some of the information from the copy?
See possible answers