SQLRx Tip of the Month
 
July 2015
______________________________________________________________________________
SQL 2008

SQL Server Administration:  Available in all versions of SQL 2014.   


 

 

 


 

  • CONNECT ANY DATABASE : Using this permission you can allow a login to connect to any database (existing or future) without having to configure connect privileges on every database.

GRANTCONNECTANYDATABASETO sqlrx

GO

 

  • IMPERSONATE ANY LOGIN : This allows a login to impersonate any other login, without giving them sysadmin privileges.

GRANT IMPERSONATE ANYLOGINTO sqlrx

GO

 

  • SELECT ALL USER SECURABLES : Allows SELECT, but not INSERT/UPDATE/DELETE/MERGE permissions on all user tables in all user databases.

GRANTSELECTALLUSER SECURABLES TO sqlrx

GO


 

SQLRx has worked hard to minimize the impact of monitoring SQL Servers to the point that we are able to monitor high transaction systems with little impact (1% load) on the target system. Contact us today to help you monitor your SQL servers!    
 
As always, don't forget to regularly monitor the 11 VitalSigns  used by SQLRx to debug performance bottlenecks.

If you have a SQL question you'd like us to answer, and possibly use for the next SQLRx Tip of the Month, email it to us!  If you missed any of our previous tips, you can view them here.

For assistance or more information on optimizing your SQL Server Environment, visit us at www.sqlrx.com or email Lori Brown at [email protected].



 

Phone: 214.526.7680 x 113

Toll free:  800.85.SQLRx  (x113)

Blog

@SQLRx


 


 

Integrated Services, Inc.                                    
2008 winner logo small
Turning Data Into Profit


 

30 Years of Credibility & Trust


 

Join our email list          Check out our events          SQLRx Downloads