do I need to stop sql server

no, how would I get ext_PriceClass.Price Thank you

I was giving a new db and multiple quries to run and to check if they running,this query was running from other application and I didn't know what StartDtae means,but...

declare @myDate datetime

set @myDate = '7/9/1998 12:00:00 AM'

select @myDate

this works, but '7/9/1998 12:00:00 AM' just an example of my date format, I have different dates in my dates, do I...

This is a view and I am trying to run from query analyzer.

This is the data:7/9/1998 12:00:00 AM

like this 'STARTDATE'

Thank you

Yes,it is transaction job

No, I don't have maste4IDR set up, I don't see it anywhere and I don't know where it is comming from

It looks that I have 2 traces:

11C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\LOG\log_6.trc20NULL50101212812451840NULL2009-07-08 15:07:24.1732009-07-26 17:12:56.36742918NULL

21C:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\LOG\MyDMLtrace.trc50NULL001002128262144NULL2009-07-26 17:11:51.1502009-07-26 17:12:56.383142NULL

It is in master db:

sp_DMLTrace615673241V 1000002009-07-26 17:23:13.860000V 0202009-07-26 17:23:13.8600000000

In view only shows thing that...

Yes, I ran your code to create the view and then I ran EXEC sp_AddMyTrace and I get:

Cannot create a new trace because the trace file path is found in...

How to see if trace running, and how stop and delete trace?

Thank you

I can't find a view. I get this Invalid object name 'sp_DMLTrace'.

I created sp under master

Thank you,I created sp under master,but don't see the view, where the view should appear? I search for it and can't find it