Re: Microsoft SQL Server 2008
- From: Jacques Bosch <jfbosch@xxxxxxxxx>
- To: programmingblind@xxxxxxxxxxxxx
- Date: Wed, 18 May 2011 23:12:53 +0200
Hi Rodney.
>I don't like the tracing tool so much... it is a battle to get the
information I need from it.
In SQL Server 2008, the tracing tool is called SQL Profiler. Not sure what
it was called before.
But it has the very useful option of tracing directly into a table. That way
you can interrogate the trace table with standard SQL selects and filter
with WHERE clauses and it makes consumption of the trace data a whole lot
more palatable.
When you start a new trace, just look for the checkbox that is called
something like "Trace to table". Then you must specify a target database and
table into which the trace should be written.
Jacques
On Wed, May 18, 2011 at 3:40 PM, Rodney Haynie <rhaynie@xxxxxxxxxxx> wrote:
> Tony,
>
>
>
> I connect to MS SQL databases from 2000 up to 2008, using SSMS (SQL Server
> Management Studio). I have the Developer version of SQL Server installed on
> my local PC. SSMS is the replacement for Query Analyzer and Enterprise
> Manager.
>
>
>
> I am a Developer, not a DBA... with that said, the things I do every day
> are the following:
>
> Create and modify stored procedures.
>
> Review database schemas
>
> Write and execute TSQL.
>
>
>
> I am currently using JAWS 12, but was using JAWS 11 with the same SSMS
> before.
>
>
>
> I don't like the tracing tool so much... it is a battle to get the
> information I need from it.
>
>
>
> The query analyzer is a bit cumbersome as well.
>
>
>
> Regards.
>
> Rodney
>
>
>
> *From:* programmingblind-bounce@xxxxxxxxxxxxx [mailto:
> programmingblind-bounce@xxxxxxxxxxxxx] *On Behalf Of *Anthony P Schnurr
> *Sent:* Wednesday, May 18, 2011 8:56 AM
> *To:* programmingblind@xxxxxxxxxxxxx
> *Subject:* MicroSoft SQL Server 2008
>
>
>
> Hello,
>
> I have been asked to check into doing some work with Transact SQL and MS
> SQL Server since we are going to be moving from Oracle to SQL server for
> future development.
> I would like to hear from anyone who has successfully worked in this
> environment using a screen reader. What tools worked for you?
> I once tried Enterprise Manager with SQL Analyzer on an older computer
> which I had some good luck with; however, I was told I could not use that
> tool on my newer machine.
> I currently have MS SQL Studio Manager on this Windows 7 64-bit machine.
> I am currently using latest build of JAWS 11 and trying to convince
> management to purchase upgrade to 12. Though we have some SQL Server 2000
> DBs; we are also going to be adding some SQL Server 2008 or newer DBs.
> Any thoughts?
>
> Tony Schnurr
> Programmer Analyst Sr Professional
> CSC
> 6125 E. 21st Street MS 32 Indianapolis IN, USA 46219-2058
> Global Outsourcing Services | p; +1-317.306.3608 | f: +1-317.306.4253 |
> aschnurr@xxxxxxx | www.csc.com
>
>
> This is a PRIVATE message. If you are not the intended recipient, please
> delete without copying and kindly advise us by e-mail of the mistake in
> delivery. NOTE: Regardless of content, this e-mail shall not operate to bind
> CSC to any order or other contract unless pursuant to explicit written
> agreement or government initiative expressly permitting the use of e-mail
> for such purpose.
>
--
Jacques Bosch
Software Architecture and Development
Independent Contractor
Cell: +27 824711807 Fax: +27 86 504 4726
E-Mail: jfbosch@xxxxxxxxx
Other related posts:
