Menu
Does anyone know if there is some type of bug in the installation of SQL Server 2008 R2? It seems if you have Express edition installed, then upgrade to anything (developer, enterprise, etc.) the SQL Server tools that don't come with Express will never show up because the Express edition is installed on your computer. *Even though you just paid for Enterprise edition
This has happened to me on 3 different computers. I have to copy the binn folder from a computer that actually works. Just today I decided to try to uninstall the Express edition before upgrading - instead of letting Microsoft handling the upgrade and it worked. I'm thinking maybe this is a bug...
206
Click Start, point to Programs, click Microsoft SQL Server 20xx (your version), click Performance Tools, and then click SQL Server Profiler.
You can start SQL Server Profiler from the Windows Start menu, from the Tools menu in Database Engine Tuning Advisor, and from several locations in SQL Server Management Studio.
SQL Server Profiler was announced to be deprecated a long time ago, but it is still in the last versions of SQL Server. However, in Azure Data Studio, is just the name. Behind the Scenes, we are calling extended events.
By default, running SQL Server Profiler requires the same user permissions as the Transact-SQL stored procedures that are used to create traces. To run SQL Server Profiler, users must be granted the ALTER TRACE permission.
When you upgrade from Express version, need to install Management Tools - Complete -
196
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
