Hi all

Yes, this IS a process problem.

We don't develop in house. Our business partners from time to time provide scripts to the Apps team. Sometimes they are upgrades, other times...

Thank you so much Brian Gale for this detailed description.

I believe the BI Team do address the queries as schema.table.

This is a reporting database created through a number of...

Thank you so much for this, RatBak.

We are WAAAAAY below that 2,147,483,647 number. About 30 on this particular DB.

This server is a VM and the SAN is full only less...

Hi

Thank you for the reply.

The apps all have their versions and we do have stringent change control. However, the scripts we get from suppliers don't always have identifiers, The Apps...

HI Leo

Yes, I can confirm all that now, sadly.

If I create a snapshot on the same 2012 publisher, will it affect the current replication that was set up using backup...

Hi Leo

Once again thank you for your response.

1. I will try and check if allow synchronise from backup option has been set. The current subscription WAS setup from a backup...

Hi Leo

Thanks so much for the quick reply.

1. Will this work break the current replication in place to the on-prem reporting DB?

2. Because the second subscription is an exact copy...

I think you have answered my question, Sue. Thank you.
I had often wondered what it is that the SQL browser might be looking for: UDP port 1434.
So I...

Thank you Sue.
Yes I agree with you that uses a database for ADFS config stuff and being Microsoft it is a SQL server database.
However, there are no visible shared...

Good Morning Lowell (at least it is where I am 🙂 )

You are great, thank you so much!!

I am sure it was the second script that needed to be loaded...

Lowell

Great, many thanks for this.

I did find and try the first powershell script. It didn't work 🙁

I used my domain admin account on the windows server (didn't create a local...

Cheers John, many thanks.

Thanks John.

I am merely concerned for security. That is why I am considering stopping them. All my instances (61 of them) are default.

Thanks Igor, Is there an obvious to keep it running.