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: )

355 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: )

425 reads

Blogs

T-SQL Tuesday #137–Notebook Uses

By

It’s actually my month to host T-SQL Tuesday, and I came up with the...

Daily Coping 13 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Converting a SQL Server Docker image to a WSL2 Distribution

By

Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...

Read the latest Blogs

Forums

connect to mdf file of localDB

By snomadj

Potentially dumb question.  There is 1 x ldf & 1 x mdf for DB1. ...

Incorrect update

By marcin89

Hello, I made mistake during updating cells in table.In column that contains int type,...

Log Shipping version upgrade oddity

By matt_murdock

Hi, I've come across an odd situation, and was wondering if anyone can explain...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers