Tip of the Day #1 (Connection Strings)

You can add the Application Name to the connection string for SQL Server so that it becomes easier to debug problems when you use a tool like SQL Profiler as it will be much easier to identify the commands being issued by your application.

For more information see Ben Hall‘s blog: SQL Connection – Application Name

Published by Colin Mackay

I blog at ColinMackay.scot. I also talk at software development conferences.

Join the Conversation

1 Comment

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: