Thank you very much.

LMT

SELECT

t_Retail.Pcde6P,

Count(*) AS Total

into #temp

FROM t_Retail

WHERE

LEN (TRIM(t_Retail.Pcde6P)) = 6

GROUP BY

t_Retail.Pcde6P

HAVING

Count(t_Retail.Pcde6P) > 2

ORDER BY

Count(*) DESC

SELECT *

from t_Retail R

WHERE exists

( select *

from #temp TR

where R.Pcde6P = TR.Pcde6P)

drop table #temp

🙂

...

actually I made a small mistake there :

select count(*) from uu_resume_ses_dummy_dummy

where exists (select substring(col018_dominio,1,20)+substring(col018_dominio,20,10)

from iis_uu_diario_resume where substring(col018_dominio,1,20)+substring(col018_dominio,20,10)

= substring(uu_resume_ses_dummy_dummy.dominio,1,20)+substring(uu_resume_ses_dummy_dummy.dominio,20,10))

option (maxdop 1)

try this:

select count(*) from uu_resume_ses_dummy_dummy

where substring(dominio,1,30)

not in (select substring(col018_dominio,1,20)+substring(col018_dominio,20,10)

from iis_uu_diario_resume where substring(col018_dominio,1,20)+substring(col018_dominio,20,10)

= substring(uu_resume_ses_dummy_dummy.dominio,1,20)+substring(uu_resume_ses_dummy_dummy.dominio,20,10))

option (maxdop 1)

I am running SQL 2000 SP3

MDAC 2.7 SP1 on both servers

yes, I know which query produced the error.Last nite it runned ...

I agree 100%

I have a data warehouse and I had to reorganise all datafile and log files , plus move msdb, tempdb from D into a less OS drive

Now, ...

I found the sysmonlog and I will have a talk with my sysadmin about permissions.

Thank you very much

LMT

very good articles in:

http://www.sql-serverperformance.com/performance_monitor_counters.asp

...

on their Home page you ca find a range of articles regarding perfmon in relation with SQL server

One suggestion:

why don't you make a scale of values, applicable to all packages.When DBA's test they will have a guideline as what to look for in every package

as a small...

how I do it:

for the users you think they do not access =>>>>>>>>take them out from the database(maintain them in security just in case)

If nobody cries, then...

Sorry for confusion.I want to run a script that must start jobs in function of a trigger in another database.

That is if job is not alive then start...

yes

I have a huge data warehouse and I make sure that after big loading processes I wil,cheal up my log.

I am sure it is a bug.Especially because this type of...