Awesome stuff, will defenitely try that out.

Thanks a lot for your assistance

and Thanks to everyone else who contributed much appreciated:-D

Thanks that seems interesting, have never used that before... Will that encryption allow the database to be accessed remotely (eg allowing other instances to write into that db with a...

will try this thanks, the issue is developers require sysadmin role on this specific box but I would like to add my monitoring db there without them havin access to...

Thanks I tried that, but if user has sysadmin role he still has access to the db 🙁

Will that limit the access to the db, or will that allow the 1st user who created a session to that db specific access

Thanks bro using the sp_whoisactive script, can see issues arising with the merge replication. Seems like Clustered indexing issues on the merge system tables.

Thanks for the concern, I am busy monitoring the server, we have server admins who is looking into the VM environment from what I assume forums are there to assist...

Thanks a lot for all the assistance, that book that Gila mentioned is quite useful and not only for accidental DBA's :-D....

Thanks a lot mate

Sorry I'm not sure I understand you. It will be just a version upgrade of SQL 2012 Standard to SQL 2012 Enterprise I don't think any migration is required. It's...

Thanks for the reminder, but will definitely start with backups first...

one more thing do you think the window for downtime will be large or the version upgrade will be quick...

Will any settings of mine be lost, Like replication during the version upgrade

Thanks will do, browsed through the document very informative.

Will read through everything.

Do understand what it is though probably phrased my ques incorrect.

Thanks again

Do you mean for each site I should change the schemas of the tables, it will not work if all the tables on the different sites all belong to the...

Looked at the User Table, and the user does exist in the table.

Changed it to my login as well which exists in the Users table as well but still no...