Hi Johan,

You are an absolute legend. That worked perfectly. 🙂

I don't want to push the friendship but, what if I wanted to do it for the whole instance rather than...

Hi Michael,

No, they are not all maintenance plans. It's actually irrelevant what the job does. We have maintenance jobs, jobs that pick up csv files and import them. All sorts...

As an example, I have a job the runs nightly index rebuilds on the primary. If  the primary fails over and becomes the secondary then all those jobs fail. I...

Did you not read my error message?

It's transactional push replication. The distributor is on on the publisher. I got to step 6 of To modify a synchronization schedule for a push subscription in Replication Monitor. I...

I've tried to change the server that is the distributor. When I run  the below on the new distributor:

EXEC sp_adddistributor

@distributor = 'Server2',

@password = 'password'

I get the following error:

The server 'Server4'...

Ok. What if I put the distributor on Server2 and the subscriber is Server3

I just wanted to add to this another question. I'm getting conflicting information on the web about this topic. Can you have the distributor in an AAG group? For example...

Thanks everyone for your help

Thanks for that, however I do have a question. If Server3 is only an asynchronous read-only environment, would it not be best to make it the publisher and distributor as...

I'm running it from my local machine. While I imagine it is a poorly written SP I don't know what it is. Is there a way to find out? I...

I get and error similar to

Msg 5074, Level 16, State 1, Line 1

The object 'SAT_DV' is dependent on column 'DV_DATE_TIME'.

Msg 5074, Level 16, State 1, Line 1

The object 'PK_SAT_NAME' is...

I need to change every table with the data type datetime to datetime2 not just one or two tables so that script won't work and I can't drop any tables.

I dropped the clustered index from the audit staging table and recreated a nonclustered index, I then ran the stored procedure and it truncated ALL the data from just the...

I didn't do it. I've just started here and was told they made this change due to performance and that's what broke the partitioning so could it be fixed.