Ivanova (12/21/2015)

---

Slightly off-topic; while working for a large financial institution, I was approached by one of the security team. He was a highly-paid and allegedly very security-savvy contractor. His request...

Linked SQL Servers. All the linked servers authenticate with SA, so anyone with access to one SQL Server has sysadmin rights to others.

Some of the devs know this......

Yes, I can set model to read only on 2008 10.0.2531

thanks for your quick reply!

tempdb 2048.00 MBsa2Jul 8 2008Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=611, Collation=Latin1_General_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics90

tempdev1x:\MSSQL\DATA\tempdb.mdfPRIMARY1048576 KBUnlimited10240 KBdata only

templog2y:\MSSQL\DATA\templog.ldfNULL1048576 KBUnlimited10240 KBlog only