Deploying management tools with profiler
W.a.Sdanou
I believe its possible to record, or to retrieve a script from an sql
installation, and to deploy this to multiple other sql installations.
Can anyone refresh my memory on this.
I actualy would like to use this, Only to deploy the SQL Management
Studio tools, including the needed profiler. All SQL management express
installations lack the profiler. Couldn't find an setup /admin so I have
to come up with something different.
By the way, If this fails there's still an option to install this open
source profiler http://sites.google.com/site/sqlprofiler/. But i'm not
sure this can replace the original profiler.
Thanks for your reply,
Erland Sommarskog
> I believe its possible to record, or to retrieve a script from an sql
> installation, and to deploy this to multiple other sql installations.
> Can anyone refresh my memory on this.
> I actualy would like to use this, Only to deploy the SQL Management
> Studio tools, including the needed profiler. All SQL management express
> installations lack the profiler. Couldn't find an setup /admin so I have
> to come up with something different.
While you could use Profiler for this, I would say that it sounds akward
in my eyes. Why not build a script from the start and keep this script
under version control?
While Express Edition does not include Profiler, you can still run
server-side traces on Express. They take a little more time to set up,
particularly without Profiler. (With Profiler you can define the trace
in the GUI and then export it). Nor is there direct graphic feedback. But
all powers of tracing are still available.
--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx