Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
select extract(year from E.EENDDATE) as "Year", (extract(yearday from E.EENDDATE) - extract(weekday from E.EENDDATE-1) + 7) / 7 as "Week", sum(A.AMOUNTCHARGED) as "Value" from CCREVENTS E inner join CCRACC A on (E.CONTRACTNO = A.CONTRACTNO) group by extract(year from E.EENDDATE), (extract(yearday from E.EENDDATE) - extract(weekday from E.EENDDATE-1) + 7) / 7 -- it doesn't like this line having brackets and operators in it!
|Display field if column exists||7||30|
|compare date to getdate()||8||13|
|Problem Backingh Up Transaction Log on Old SQL000 Database||3||19|
|user database (login sql or login windows)||3||17|