Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Running Profiler via a SQL script.
Started 1 month, 1 week ago by Jimbo
Hi, SQL 2005 Enterprise Edition (SP2) I'm having trouble running a SQL script generated via the SQL 2005 Profiler. I've set up a very simple proifle template to look for 'Crystal Report' SQL that runs for over 2 seconds in the mill - the only two filters I have on the template are 'Application name' and 'Duration'. When I run it in the Profile GUI, all is fine, and I receive the expect output....
Site: SQL Server Forum  SQL Server Forum - site profile
Forum: Other SQL Server Topics  Other SQL Server Topics - forum profile
Total authors: 2 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: sqlmonster.com

Other posts in this thread:

Erland Sommarskog replied 1 month, 1 week ago
There was a bug with creating the script in Profiler, so that traces were not exported correctly. I don't remember when it was fixed, but take a look at the calls to sp_trace_setfilter at the end of the script, and verify the calls against the documentation in Books Online. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: ...
Size: 827 bytes
Customize:  Customize "<b>Reply 1</b>: Running Profiler via a SQL script. :: Other SQL Server Topics :: SQL Server Forum"

Jimbo replied 1 month, 1 week ago
Erland, Thank you. I have created scripted profiler SQL myself without using the Profiler to create it for me, so I will have a look at the SQL created. Thanks once again. James.
Size: 223 bytes
Customize:  Customize "<b>Reply 2</b>: Running Profiler via a SQL script. :: Other SQL Server Topics :: SQL Server Forum"

 

Top contributing authors

Name
Posts
Jimbo
2
user's latest post:
Running Profiler via a SQL script.
Published (2009-11-08 18:49:00)
Erland, Thank you. I have created scripted profiler SQL myself without using the Profiler to create it for me, so I will have a look at the SQL created. Thanks once again. James.
Erland Sommarskog
1
user's latest post:
Running Profiler via a SQL script.
Published (2009-11-06 23:38:00)
There was a bug with creating the script in Profiler, so that traces were not exported correctly. I don't remember when it was fixed, but take a look at the calls to sp_trace_setfilter at the end of the script, and verify the calls against the documentation in Books Online. Signature Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx...

Related threads on "SQL Server Forum":

SQL 2005 Profiler - DTA - SQL Server 2000 DB  SQL Server Forum - site profile SQL Server Tools - forum profile SQL 2005 Profiler - DTA - SQL Server 2000 DB
SQL 2005 Profiler - DTA - SQL Server 2000 DB
SQL script does not complete - SQL 2008  SQL Server Forum - site profile SQL - forum profile SQL script does not complete - SQL 2008
SQL script does not complete - SQL 2008
Running Large SQL Script on a Schedule  SQL Server Forum - site profile SQL Server Tools - forum profile Running Large SQL Script on a Schedule
Running Large SQL Script on a Schedule
ISO t-sql script to identify relationhip between two...  SQL Server Forum - site profile SQL - forum profile ISO t-sql script to identify relationhip between two tables (no FK
ISO t-sql script to identify relationhip between two tables (no FK
Delete old Backup files using T-sql script  SQL Server Forum - site profile SQL - forum profile Delete old Backup files using T-sql script
Delete old Backup files using T-sql script
From table to SQL script  SQL Server Forum - site profile SQL Server - forum profile From table to SQL script
From table to SQL script
How to make a SQL script emit a beep  SQL Server Forum - site profile SQL - forum profile How to make a SQL script emit a beep
How to make a SQL script emit a beep
Execute long sql script  SQL Server Forum - site profile SQL Server Tools - forum profile Execute long sql script
Execute long sql script
How can I wait for a restore to complete in a T-SQL script?  SQL Server Forum - site profile SQL Server - forum profile How can I wait for a restore to complete in a T-SQL script?
How can I wait for a restore to complete in a T-SQL script?
T-sql script drop user account DB server  SQL Server Forum - site profile SQL - forum profile T-sql script drop user account DB server
T-sql script drop user account DB server

Related threads on other sites:

Loading tables via SQL script in...  Discussions in microsoft.public.access.gettingstarted - site profile microsoft.public.access.gettingstarted - forum profile Loading tables via SQL script in microsoft.public.access.gettingstarted
Loading tables via SQL script in microsoft.public.access.gettingstarted
UDT: how to fill tables via sql script?  DotNetNuke > Community > Forums - site profile User Defined Table Module [Lead: Sebastian Leupold] - forum profile UDT: how to fill tables via sql script?
UDT: how to fill tables via sql script?
Creating Application Roles via SQL Script  MSDN Forums - site profile SQL Server Security - forum profile Creating Application Roles via SQL Script
Creating Application Roles via SQL Script
How do I drop a stored procedure in Azure (via SQL script)?  MSDN Forums - site profile SQL Data Services (SDS) - Getting Started - forum profile How do I drop a stored procedure in Azure (via SQL script)?
How do I drop a stored procedure in Azure (via SQL script)?
Inactive customer/vendor via SQL script  eggheadcafe community - site profile dynamics gp developer - forum profile Inactive customer/vendor via SQL script
Inactive customer/vendor via SQL script
Loading tables via SQL script  eggheadcafe community - site profile Access gettingstarted - forum profile Loading tables via SQL script
Loading tables via SQL script
Where can I get the tool or sql script which runs against...  Twitter / ZehraNasif - site profile Zehra Nasif - forum profile Where can I get the tool or sql script which runs against SQL box (not the Profiler) and shows trouble areas? 01:07 PM September 16, 2008 from twhirl
Where can I get the tool or sql script which runs against SQL box (not the Profiler) and shows trouble areas? 01:07 PM September 16, 2008 from twhirl
How to track delete/insert/update on a table via SQL...  SQLServerCentral - site profile SQL Server 2005 Security - forum profile How to track delete/insert/update on a table via SQL Profiler 2005
How to track delete/insert/update on a table via SQL Profiler 2005
Run MS SQL Profiler via command line  SQLServerCentral - site profile General - forum profile Run MS SQL Profiler via command line
Run MS SQL Profiler via command line
Pass Insert SQL Statement to MS-SQL DB via BAT script  CodeProject: Discussion Boards. Free source code and programming help - site profile SQL / ADO / ADO.NET - forum profile Pass Insert SQL Statement to MS-SQL DB via BAT script
Pass Insert SQL Statement to MS-SQL DB via BAT script
Thread profile page for "Running Profiler via a SQL script." on http://www.sqlmonster.com. This report page is a snippet summary view from a single thread "Running Profiler via a SQL script.", located on the Message Board at http://www.sqlmonster.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity