I feel for you

you can script out your publications and subscriptions nice and easily

depending on whether you can knock...

select N'\\ABCD\EFGH\IJKL\MNSP\'+ @@servername+'\AL.txt'

unfortunately transactional replication is "distributor led" - you will need to move distribution to the 2016 instance (highest version wins) - which means you will need to rebuild the publications,...

it is...

We don't ever allow our Devs access to Production. What we do for them, however, is create a "production copy" database on a daily basis down to a non-prod...

also check out "attach single file db" - but don't forget to clean up the old ldf files if you do use this

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-attach-single-file-db-transact-sql?view=sql-server-ver15

ok - so why not script the attach

EXEC sp_attach_db @dbname = N'mydatabase',   
    @filename1 =   
N'C:\mydatabase_Data.mdf',   
 ...

I've started using MERGE for updating records because UPDATE just freaks me out. It takes more thinking out but will get faster with practice and it's good to get...

Hello!

I need to run weekly report for each month on Friday, beginning the first day of each month, and ending the last day of the month

Example

·         10-1-2019 thru 10-4-2019

·        ...

Del - just in case you missed it (outside our private messages) - on the link i sent you, just scroll down and you'll find the standalone installer - don't...

what happened to good old fashioned command prompt tools

dir /s *.ldf

none of this fancy SQL malarkey 🙂

the only thing I can think to say is install SSDT - it may install a few DLLs  that he needs - it's not a big install and it's quite...

A neat little script that fits in well with some of the themes we're seeing recently about having clean databases with no customer data inside.

there are 2 other ways I...

most sites just say - reinstall ssms and ssdt

are the paths the same on both servers? I've never seen a dethatch lose a log file

I'd wager that the .ldf file is somewhere