What bike ? (changed the avatar for a couple of minutes to SushiNemo)

I hope the original poster...

identity is related to a numeric datatype so leading zeroes are meaningless.

You can present them anyway with things like this :

DECLARE @I INT

DECLARE @C CHAR(8)

SET @C = ''

SET @I =...

On the other hand, I cannot prevent it !

I can tell my windows-group-administrators, but that is as good as a flyer. You spread the...

you can also change de database-ower (exec sp_changedbowner @loginame = 'theOneAndOnly' ,@map = 'true' ) Then that user by default creates dbo-objects. If he/she wants older existant 'theOneAndOnly' -tables, he/she...

You should run OUI and perform a custom installation. There you can check Windows-components.

Arch ... also the married restrictions

Missing the adrenaline, but having your socks washed every week

Even the...

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...