Search results for query: *

I need to produce a query in cross-tab format that displays the column data as the first day of the week for every week for a given date range dynamically. This date range would normally be 1 year. i.e. for August 4 Aug 03 | 11 Aug 03 | 18 Aug 03 | 25 Aug 03 Row1 Row2 etc... Any pointer...

Up/down time first but bandwidth/usage/client connections would be handy.

Can anybody recommend a good online monitoring service that could monitor a website, smtp server and sql server?

Oh I see. Could my AD be working OK because I'm using the external DNS service by ZoneEdit.com?

... are there any tests I can do to establish wether AD and DNS is working correctly?

I have got AD running and everything seems to work OK??

or NOT tblCustomers.SoldTo LIKE 'LZB%'

I use this http://www.lockwoodtech.com/index_sqldiff.htm it's very fast.

You could use DBCC CHECKIDENT('tablename', RESEED, 0) Tim

Sorry, been away for a while. You are correct ZoneEdit has nothing to do with AD, what they do for me is handle the DNS for my domain (coz I got a dynamic IP from ISP). I have setup ZE with several "A" records (ftp.mydomain.com, mail.mydomain.com etc. etc.) and 2 MX records one of...

Steve, Zoneedit - before I got my server I used www.zoneedit.com to handle my domain etc. They provide a "Managed DNS Service".

stevehewitt, my router is also a 4 port switch and firewall with NAT. I've been playing and everything seems ok except that the client machines (when trying to joint my Win2K server domain) report that there are no domain controllers available. Could this be something to do with my ZoneEdit...

I've been playing about with my setup below but cannot get any reliable connectivity between my lan machines and the net. Would anybody be able to advice me on setting up my networt properly? 1 x W2K Server, IIS, Exchange Server 2000 1 x 2600wi 1 x Desktop PC 1 x Laptop 1 x BTBroadband with...

I've been playing about with my setup below but cannot get any reliable connectivity between my lan machines and the net. Would anybody be able to advice me on setting up my networt properly? 1 x W2K3 Server, IIS, Exchange Server 2000 1 x 2600wi 1 x Desktop PC 1 x Laptop 1 x BTBroadband with...

matt, Done eveything you said but i get a message on the desktop saying dns server does not exist and cannot find domain controller.

My setup is as follows:- Win2K3 Server DC WinXP Desktop DHCP enabled Draytek 2600we Router When trying to logon to my home Win2K3 domain the client machine (after login credentials are authorised) takes several minutes to display the desktop. It seems as if the desktop pc is trying to resolve...

ChildID 6 has a parentid of 4 (Room 2) which inturn has a parentid of 3 (section) which inturn has a parentid of 2 (ground floor) which has a parentid of 1 which is the parent of them all.

Hi I have the following table:- childid parentid description --------------------------------------------- 1 1 Company 1 2 1 Office 1 3 2 Ground Floor 4 3 Section 5 4 Room 1 6 4 Room 2 7 4 Room 3 8 1 Office 2 9 1 Office 3 If I want the details of childid 6 I would like to...