All you've done is change TRUNCATE to DELETE, right?  That's going to run slower and use more log space, and mean you have to do the extra step of...

I had a Mini 850cc then a porche 924 (both utterly useless if you like your spine intact)

so I switched to bikes - I have a Harley 883 iron, Kawasaki...

Yeah, I've trialed it...

Well, I'm finally getting one of my wishes at work and I'm simultaneously happy and worried...

I'm getting complete control over my database backups.  We're cloudifying (well, they're calling it...

I've been through this and NOCHECK is the issue - I took this out and couldn't put my child data back

so I created the child data without the foreign keys...

I use a very archaic method -

select 'delete from '+name from sys.tables where type='u' and  name <>'sysdiagrams' and name not in (lookuptable1','lookuptable2'..... etc)

copy the results into excel and put them...

Not sure that's...

there aer definatly 2 or 3 articles on here about it

I Turned TLS1.0 off and just kept plugging away - took me most of a day, but i'm sorry ,...

just keep googling - it was definatly a registry key for me

but....you tested dropping those columns in UAT somewhere and had the devs sign off on what to change and whether it worked correctly, right? Or you'll do that for...

we all know stormtroopers cant hit anything with a blaster - ell...

Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks.  I'm just a little gob-smacked...

I've been through this before, but I've been to sleep since then

I did a quick google based on my issue at the time and there are a few registry settings...

The better you get at communication, the better an employee you'll be. The better you get at communication, the more likely you'll get hired. Yes, if you communicate a...

don't forget LinkedIn - the more you raise your profile and have a great CV on there, the more people will approach you