If you create Excel worksheets or PivotTables with embedded connections to SQL Server, you may want to consider changing the name of the application so you can tell which spreadsheet template someone is using. That way in Management Studio or in any logging you setup, it will your custom name.
Data Source=SQL_SERVER_OR_IP;Initial Catalog=DATABASE_NAME;Application Name=EXCEL_TEMPLATE_MASTER_REPORT;User ID=USER_NAME;Password=PASSWORD
No comments:
Post a Comment