yes, that is what I needed - thanks folks

thanks folks but it doesn't quite answer my question
do I  create a full backup to a device - and set the device through T-SQL so the file name has...

It's all on disks - I'll try and see what the name of the file created with a device backup is
sadly, the server can access the  development machine -...

I created a logical device on the database server

hey guys
I found my problem
earlier versions ask if you want mixed mode
SQL Server 2017 just defaults to Windows Authentication so I had to manually fiddle with settings,...

I'll have to check with the previous developer - it may be necessary for some reason - I think I recall seeing it explicitly turned on
but thanks for the...

I did - it only took half a minute but what a difference it made

I'll try that - thanks bunches

thanks

I suspect it's going to be a while before it gets upgraded from 2008 R2 and I will have long since retired by then

for now it's a 20 minute process...

on more practical matters - several critical stored procedures for my client, the largest employer in our county - rely on the quirky method to load daily tables - it's...

a while back you posted a method of adding a running total to a temp table / table variable to get around having to read each record one at a...

on behalf of my client - thanks all

the process already makes most of its updates to a staging table - and only at the very end copies the data back...

go with a tool

you can get something like DBDiff free - or spend a little money and get DBGhost, which not only will give you the differences but the script...

thank you everyone (especially Ms Shaw) for what was a really basic question - and not mocking me for it

the answer was that a change was made to the...

can't - it's considered intellectual property and my client company is very sensitive about that, even though we're hardly state of the art in the area I work in

the snippet...