Never mind ....  I found the "problem"   .....  It wasn't replication related.

There are so many variables with replication, I don't think a generic script would help much.  How about scripting one of your existing publications and scripting an existing subscription, and using...

"Right click", then "refresh" only updates your screen with current information. For example, if someone creates a new table (or stored proc etc..) in a database, Enterprise Manager does not dynamically...

I've made some very good beers (all different styles), and I've made some that I freely admit weren't very good.  I think home brewers tend to view their first few...

So, If your query is run once a month, at 3 in the morning, maybe you can afford to have it take 30 seconds and avoid another index.  But if...

Thanks for the link !!

I don't have a "still" out in the yard, sorry   🙁        I just make beer, so I only need a big brewing pot and nice big...

There is a secondary tab in the Manage Roles window that allows you to check and uncheck the cube(s) that the account would have access to.    Edit the...

You can also use

sp_helpdb 'DB_Name'

This will show recovery option in the "status" field, along with all kinds of other info about the database.

You can use sp_who2 as a template & make your own.  I made sp_who2db to sort by database, and sp_who2lock which basically runs sp_who2 and sp_lock together

India Pale Ale