Encrypted text in Profiler for unencrypted modules

A colleague came up with this situation: ************ I am tracing some SQL activity on a SQL 2008 R2, Enterprise SP2 64-bit server. In the profiler trace, I keep seeing Encrypted Text in the textdata column for procedures that are clearly plain text and are not encrypted. Though, I do notice in certain scenarios, where…

0

Glitch in SMO causes an error when you attempt to create an FTS Catalog/Table Population Schedule under very specific circumstances

If you connect from SQL Server Management Studio (SSMS) to an instance of SQL Server, whether it is named or default, and rather than using the proper machine name (or machine name followed by the instance name, separated by the backslash) you use either an alias (created using SQL Server Configuration Manager, through the corresponding…

0

Launching Database Mirroring Monitor without having to go through SSMS

Yesterday, while co-delivering a seminar on Database Mirroring to a few customers, one of them asked whether it was possible to open Database Mirroring Monitor in an easier, more straight forward way than having to open SQL Server Management Studio, connecting to one instance, expanding the Databases node, right clicking on one of the databases,…

0

SQL Server Profiler 2008 (or 2008 R2) not showing expected columns for given events while setting up the definition of a new trace

This week, while working in a customer, they showed to me a weird (an somehow inconsistent) experience with SQL Server Profiler. The story was like this: In a laptop that was running Windows 7 (x64) when they launched Profiler.exe (the one installed with SQL Server 2008), attempted to create a new trace connecting to an…

0