Tag Info

New answers tagged


You will certainly need the right permissions to view the views definition. This should work for you. Please note that I'm using the undocumented sp_MSforeachdb stored procedure. This means that it could change without notice so is not advisable to include as part of your production/live tsql code as it could fail. Check Aaron comment about it. EXEC ...


Know this is an old question but we've just been working with this, Last month we had to move our distribution server to a brand new machine, (Setup is two machines in AG stand alone distributor and a reporting server) The only real way we found to move distributor server is to completely tear down and rebuild replication, this can be done with right ...

Top 50 recent answers are included