Automated Profiler trace import

This stored procedure was written to complement the automated profiler trace create procedure (should be here somewhere - check the scripts).Bascially, given the database (sample script to create the database included, but you may want to personalize it), this stored procedure will import the tracefile content into the table, which is indexed on expected search […]

2005-10-03 (first published: )

354 reads

Automated Profiler trace Create

This stored procedure is created to be invoked (in my case by SQL Server scheduled job), and will then create a tracefile to a specified file location (ensure that if this is NOT local, your SQL Server Agent runs on a domain account that has access to that drive. The Stored procedure will create files […]

2005-03-16 (first published: )

424 reads

Blogs

Distributing Jupyter Notebooks

By

If you’re working with the Microsoft Data Platform, you should be, at the least,...

SQLSaturday Orlando Notes – Large Printed Schedules

By

One of the things we’ve done most years in Orlando is to print poster...

Upgrading Windows 10 Home to Pro

By

I use Hyper-V and a few other things that require Windows 10 Pro. When...

Read the latest Blogs

Forums

changing db owner with always on replication (to fix DB properties window)

By Glen_A

SQL Server 2016 standard edition, with primary databases and one other server set up...

Trouble connecting in single user mode

By jay-h

I have an SQL server which I need to get admin access to. Logged...

BCP utility

By awp

Hi All I am trying to export some data from a SQL server database...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers