Any Service Pack released for SQL Server 2008 R2 is intended for any edition.

Okay to install, IMO.

qh

What data are you wanting to audit? Try these links below.

SQL 2008 R2 Database Audit

View audit log

You can also download a SQL 2008/R2 Compliance Guide.

qh

Hi Wilem,

I like your script and plan to test it on a few VM SQL instances but how different is your script to say Data Collector?

Rgds,

qh

Anyway this worked:

setup.exe /QS /ACTION=INSTALL /FEATURES=Replication /INSTANCENAME=MSSQLSERVER /IACCEPTSQLSERVERLICENSETERMS

qh

Are you using NOT FOR REPLICATION for the table/article with the trigger?

Controlling Constraints, Identities, and Triggers with NOT FOR REPLICATION

qh

Thanks Gail, can't do any harm to recheck but SQL Service account had full control on that drive/paths/etc. SQL was installed by non DBA a while back so once...

I see what your script is doing, have checked the path and ACL (sql service account has full control) but still would not work. I have moved the templog...

bsistla (12/10/2014)

---

1. I want to complete MCSA for 2012. Is this the right certification to be called a DW developer using SQL server 2012?

2. Are the guides provided by Microsoft...

http://sqlperformance.com/2012/11/io-subsystem/minimize-impact-of-checkdb

Argenis Fernandez did an excellent webinar for this back in March, you could ask him for the slides.

qh

What is the size of the snapshot you are generating? Replication can be immensely temperamental when it comes to generating a snapshot of over 2GB (I think, is it...

Thanks Shafat, that's an interesting solution, maybe worth ago, however the instance in question is in UAT testing phase so it's off limits ATM. In the new year it will...

Hi Bill,

I am just about to purchase SQL Complete (have a discount code so good value) but disappointing to hear that they haven't fixed the issues you have mentioned....

Welcome to Microsoft error reporting. 😉

qh

Hi Resender, to get more help you may need to repost (for the t-sql code)

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D

qh

Cheers Gail, I had forgotten about the named/default instance setup.

qh