You will need a distribution list creating in the mail server which contains the users you want to send a mail to.

I dont know of any off the top of my head, but I do have a private FTP server on a dyndns lookup to my ISP in the UK if...

Well you learn something new every day.

That was the way I was tought back when I was a young whipper snapper, so I guess it just stuck.

jonathanwbell (2/8/2013)

---

Hello,

I am a novice to SQL, I can do the simple queries but at the moment I struggle with writing complex ones. If someone could help me with creating...

To spread the IO load, but you would usually have them all sized the same.

check what can spawn the service on the local machine and what it is actually trying to do.

Well just change the @counting in the select to your table name

The table variable and insert is to create a testing environment using readily consumable data which someone can just...

Select Distinct

GT.PLAN_CODE As PLANT,

GT.FG_DESCRIPTION As T_SIZE,

GT.PLANNED_QUANTITY As TOTAL_SCH,

GT.PROGRESS_QTY As PROD_MTD,

GT.PLANNED_QUANTITY - GT.PROGRESS_QTY As T_BALANCE,

CASE WHEN GT.FG_DSECRIPTION = IT.FG_DESCRIPTION THEN NULL ELSE IT.FG_DESCRIPTION END AS INCOMING_SIZE,

CASE WHEN GT.FG_DSECRIPTION = IT.FG_DESCRIPTION THEN...

declare @counting table ([date] date, firstname char(10), name char(10), nationality char(2), mode char(3), origine char(1), ID char(2))

INSERT INTO @counting values

('2010-01-01','teste','teste1','fr','in','p','01'),

('2005-07-15','toto','tata','lb','out','L','02'),

('2012-03-01','teste','teste1','fr','in','P','01')

SELECT

ID,

COUNT(ID) MyCount

FROM

@counting

GROUP BY ID

ORDER BY MyCount DESC

what is not working? error message? incorrect data outputted? more information please?

select top 100 ID,

count (ID) myCount

from [database]..

group by id

order by myCount;

You cant use a * in an aggregate query unless you group by every column in the table

select top...

Anything which tries to login as NT AUTHORITY\SYSTEM.

Have you tracked the source of the connection and tried to see what is logging in as the account?

Nope the information is not logged anywhere, so you would have to do custom auditing.

Could check the default trace, but thats it, if its not in the trace your out of luck.

Doh..