Hi Koen thanks for your thoughts. All of what you have said rings true here on our Data Warehouse. I am still trying to get to grips with the architecture...

Thanks for your reply and recomendation to read your book, i shall most defintely look it up.

I think you're right, i have never had to get so heavily involved with...

Hey, yeah i decided to delete them after all they did not contain any subscriptions. It has allowed me to set the replication back up on the new server.

Thanks Guys...

Hi, thanks for your reply.

the select query shows all my db's tht i have on the server, it does not display the distributor.

The account is a domain account....

Hi,

I wonder if you could clarify for me that if i provide a programmer DDL_Admin on a database does this allow them to execute a stored procedure that they have...

Hi All, can i just ask, i have been challenged by my network manager that i need to be mapped to the actual database i am backing up whilst also...

Hi Raymond, i am having the exact same problem. How and where did you manage to locate the information through the servcie broker? It's doing my nut in!:w00t:

Hi thanks for your post, i havent got that far yet. I was hoping to understand which account it was that would ultimately carry out the execution of the task...

Apologies for the delayed response Bob, thanks for your advice and script i will give it a go 🙂

Great, thanks for all your advice on my queries John, Steve and Gilamonster wish me luck! 🙂

Thanks for that John.

I was thinking of something that i could automate and have it output to a report as apposed to running the query each and every time i...

extremenovice (3/23/2011)

---

Hi All and thanks John this is a great script i will be using this from now on, but is there a way of outputting this in to a...

Hi All and thanks John this is a great script i will be using this from now on, but is there a way of outputting this in to a more...

Hi Bob, thanks for your advice on this. The information i wanted to collect is the server/database level logins/permissions that are assigned to each login. I have used sp_helplogins and...

Hi Bob, thanks for your immediate response to my post. I think i may have misread your original posts and what your script can do.

What is the next step to...