I guess you're stuck to the exists, because any join could give n-rows because of more than one MT_TABLE qualifies.

How about this ? (check the execution plan)

SELECT pd.pd_pdref,

af.af_pct,

pd.pd_author,

pd.pd_barcode,

bc.bc_name,

pd.pd_can_cons,

ca.ca_name,

CASE WHEN (pd.pd_dsref...

just my 2ct

Maybe you should uncheck the sp as startup-sp before you drop it ?

if exists (select 1 from dbo.sysobjects where id = object_id(N'[dbo].[sp_schedule_status_reset]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)...

I install de minimal client and add the windows-components-installation to be able to use ole-db. ODBC is already available with the minimial instalation.

Ok it took a while , but I finaly got the picture.

case when convert(binary(2),freq_interval ) & 1 = 1 then 'Su-'

          else '..-' end

   + ...

If you know your column is a bitmap-column,how do you decipher it ?

e.g. msdb.dbo.sysjobschedule-table column freq_interval back to Su/Mo/Tu/We/Th/Fr/Sa

I always install the targeted Oracle client-software on the server. Then it works fine.

What I do now in such cases is I determine the average of dependant rows per dependant table for one parent row and adjust the top-statement. I also document this...

thanks for the feedback

Nice article.

What I would like to do is to profile a sqlservers activities, store that trace-info in a table on another sqlserver and viewing only the latest hour of activity...

Is there any advantage of doing so ?

- The avatar is my ntv650 easy riding with a bit of curves-fun.

The blade is like a wet dream with all these speedtraps they are implementing in Belgium(Flanders-part)

Books Online (BOL)

You can also search this site (sqlservercentral.com) for usefull scripts

Don't know where I got it from, but I 've modified it a bit to be suitable for virtual servers.

-- This script will get the listening port of the

--...

Maybe you should take locking into consideration.

Your methode will do fine, but when used with big volumes, the delete might lockout the table. You could avoid this by using...

the double quotes should be single quotes in this query. Then it should work just fine.