http://www.bing.com:80/search?q=SQL+Server+ProfilerSearch resultshttp://www.bing.com:80/s/a/rsslogo.gifhttp://www.bing.com:80/search?q=SQL+Server+ProfilerCopyright © 2026 Microsoft. All rights reserved. These XML results may not be used, reproduced or transmitted in any manner or for any purpose other than rendering Bing results within an RSS aggregator for your personal, non-commercial use. Any other use of these results requires express written permission from Microsoft Corporation. By accessing this web page or using these results in any manner whatsoever, you agree to be bound by the foregoing restrictions.https://social.msdn.microsoft.com/Forums/sqlserver/en-US/98adcd1e-4433-4f2d-be56-d338904ade80/confusing-output-of-sql-server-profiler?forum=transactsqlThen I decided to use Extended Events graphical user interface in SQL Server Management Studio 2012, because Microsoft is announcing the deprecation of SQL Server Profiler for Database Engine Trace Capture.Thu, 27 Jul 2023 13:05:00 GMThttps://social.msdn.microsoft.com/Forums/vstudio/en-US/5e4edd3f-b831-4352-a799-cb3a122aca1a/linq-query-comparing-execution-time-in-sql-profiler-same-final-query-2-different-execution-times?forum=aspsqlserverWatching on SQL Profiler, I´m observing a duration time about 14 seconds, on the other hand if I just copy query string from Profiler and run it on SSMS, SQL Profiler shows duration time as just 2 seconds.Fri, 24 Feb 2023 01:19:00 GMThttps://social.msdn.microsoft.com/Forums/machinelearning/en-US/1903c442-9b1a-47af-a44c-7a48c13a2072/insert-into-statement-truncating-data-while-inserting-in-sql-server-table?forum=transactsqlHowever, ever since I am using the same SQL statement to insert records into SQL server database (nothing has changed except the connection string and schema information), the INSERT into statement is inserting data of only first three characters into one particular field , instead of 5 or 7Sat, 29 Apr 2023 19:08:00 GMThttps://social.msdn.microsoft.com/Forums/sqlserver/en-US/49b2073d-78e9-4ab0-88f2-abb363256f04/dynamic-sql-running-from-classic-asp-quotes-problem?forum=transactsqlThe sproc accesses a database called Charlie and takes in a string held in the variable @SalesSetup. It uses a select statement to pick all the records from a table where the column name is held in the variable @col and the value in that column is the string in the @SalesSetup string. I call this using the following in SQL Server: use Charlie exec test @SalesSetup= "'Individual Plan - McMaster ...Wed, 19 Jul 2023 14:19:00 GMThttps://social.msdn.microsoft.com/Forums/office/en-US/e4ed0414-cbc2-4a07-8073-ebdaf97c4aa7/odbc-driver-11-for-sql-serverstring-data-right-truncation?forum=sqldataaccessThanks Erland. Is there any way to show the bind variables data and the sql statements being executed in UNIX ODBC drivers. I tried adding some print statements in SQLExecute.c but not really successful to figureout the real issue.Sun, 27 Aug 2023 19:38:00 GMThttps://social.msdn.microsoft.com/Forums/Lync/en-US/09ffc55c-bdac-467c-b920-6daa52a162b1/how-to-identify-and-troubleshoot-slow-sql-statements-within-a-stored-procedure?forum=sqldatabaseengineCertainly agree with both, use the profiler (or on SQL 2012 the extended event monitor), and learn to use the filters to log just what you want. A simple filter of duration > 1000 will report only statements that take at least 1000ms (1 second) to execute. Etc.Tue, 25 Apr 2023 19:13:00 GMThttps://social.msdn.microsoft.com/Forums/Lync/en-US/eaf0e5a0-a7c6-4c6b-9555-265eae8b8430/high-cpu-load-on-biztalk-message-db?forum=biztalkgeneralI was using BizTalk Server 2009, and I didn't install any service packs or hot-fixes. After trying the message box tool and checking the SQL Server profiler and trying to clean up the messagebox tables and still having no luck, I determined it would be much easier to backup everything on the server and reinstall. Now everything is working fine.Tue, 25 Oct 2022 20:47:00 GMThttps://social.msdn.microsoft.com/Forums/sqlserver/en-US/da4f92a8-920b-4183-9271-127ef7326c4b/error-28005-severity-16-state-2an-exception-occurred-while-enqueueing-a-message-in-the?forum=sqlreplicationspid24s An exception occurred while enqueueing a message in the target queue. Error: 15517, State: 1. Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. Edited bySnwskrTuesday, October 23, 2012 2:00 PM Tuesday, October 23, 2012 1:47 PMSat, 26 Aug 2023 23:21:00 GMThttps://social.msdn.microsoft.com/Forums/sqlserver/en-US/a468ab9f-3bc3-440c-a34c-227372019aa5/sql-an-error-was-raised-during-trigger-execution-spmssetartprocs?forum=sqlreplication1. Which release of SQL Server 2008 did you use, have you upgraded it to the latest release? This issue can be caused by some problem of the previous release of SQL Server 2008. 2. The problem of registry, please use Windows Registry Checker Tool to repair it. If you have any other questions, please let me know.Sun, 20 Aug 2023 23:06:00 GMThttps://social.msdn.microsoft.com/Forums/aspnet/en-US/bf2c3b74-0ae2-46a5-9a5a-332d46e8e8cd/how-to-get-table-names-from-query?forum=transactsqlTry to use SQL Profiler and you will see the executed query against your database. I mean before you run your application go to your SQL profiler and run it. then go to your application and play with it. SQL profiler will record any query executed from this application to sql database and you will see your table names. I hope this is helpful.Thu, 23 Feb 2023 19:06:00 GMT