The result of A.RetailPrice * F.salesQuantity might be a FLOAT datatype, which won't round properly.

What are the results of:

 

select  sql_variant_Property(round(29.989999999999998,2),'BaseType')

select sql_variant_Property(round(A.RetailPrice * F.salesQuantity,2),'BaseType') 

Well,...

Try...

 

exec sp_msforeachtable 'alter table ? nocheck constraint all' 

and...

 

exec sp_msforeachtable 'alter table ? check constraint all'

Was a new errorlog started?

Was a SQL symptom dump produced in the log directory?

This example uses osql to test for the author 'White' in pubs, returning zero to the client if there otherwise 1. The && bit tests for zero and executes the...

I suggest starting with a regularly scheduled profiler trace, capturing Batch and RPC Completion events and certainly the database amongst the columns.

You could have it scheduled for several...

Is there a possibility that the culprit CPU-hog continued to run throughout and after the 2 hour trace, therefore not registering as a completed event?

Edited by - mccork on 07/27/2003...

Yes, for all jobs, right-click on "jobs" in left pane. For an individual job, right-click on the particular job in right pane.

Viorel,

Can you please clarify...

a) do you want to run a script that has all the decision making in it? ie. 1 round trip, where it goes to the server,...

Dinesh,

Is your problem possibly that you're trying to read the trace file while it's still open and Profiler is writing to it? My understanding is that you can only...

quote:

---

1

how to Backing up Jobs ???

-------------------------

---

Simplest way is by backing up msdb.