Search results for query: *

Yes "overuse of number of instalations" is the problem, i will just contact MS then. Thanks

Thanks guys, does anyone have any feedback on the freeware version of GFI Mail Essentials?

We have recently had to decommision a number of old machines with Action Pack licences for Office Pro and XP Pro on them. Now to avoid having to pay for new licences i would like to move licences from the now decommsioned PC's to the new PC's. I can get any info from Microsoft on how to do this...

Like all growing networks we have recently become inendated with Spam. Can anyone recomend an easy to configure/auto update filter? Preferably for free, but if not, a free trial program would be great while i convince the bean counters its what we need. Thanks

I have had to truncate quite a few databese recently, but they have always been db's that were updated once a day, from live data. Our live web database log needs truncating (Current size 650MB, Space used 46MB) are there any issues at all with truncating live data? Or can i go ahead as usual...

Thanks NoCoolHandle, i think you are right about a seperate table of just clientnames. That would certainly produce faster results, as our hits table, as you say is getting huge! Thanks for the tips!

Wow that was fast, i can see the logic of what you are saying. However i get the error adding GROUP BY cookiefrom, prodTypeID gives the same message

My query here records how many individual clicks, each affiliate sends us per day. SELECT cookiefrom, prodTypeID, COUNT(DISTINCT ipaddress) as indivclicks, COUNT(*) AS totalclicks FROM applytracking WHERE hitdate >= '20050101' AND hitdate < '20050623' AND prodtypeid IN ('loans', 'Credit...

Why not simply do a full db backup then under db properties, set the recovery model to simple instead of full.

Our nightly SQL backup is broducing BAK and TRN files of 3.9GB. However, under properties the file reads Size 3.9 GB Size on Disk 1.9GB A major headache i am having is that we are exceeding out monthly managed backup size. Is there a way to reduce the size of the backup files from 3.9 to...

Thanks, that worked well !

Additional info I know the BACKUP DATABASE statement can be used to assist in the truncation of log files, however i do not have any space on out Hard Drives in which to backup the database to. Which presents a problem

I am having a slight problem with our webserver. I have inherited a database whose initial configuration was for unrestricted growth. This has resulted in a ldf file of over 9GB and a mdf of around 5GB. This filled our HD space and caused our site to go down for a few minutes I have been able...

As stated, i am sure i have done this before, but i seem to be having a mental block. I want a developer to have full admin rights to our dev-server and just that server, how do i do it? Its not in manage my computer, so where is it? Sorry about the basic question!

Thats great thanks, it found the file alright, but is there a freeware equivelent?

I was badly advised to re-install a program, which copied over a .dat file. I have tried system restore but that hasnt rolled back the file to the previous version. Will this file be somewhere on the disk (hidden from XP)? Is there any program i can use to find this file? Thanks

Thanks for that, i can refine my request a little after a meeting with my director As part of my company's strategy of laying off staff and giving me all the work for no more money. I have been given the task of reporting on our 2 web servers. Unfortunatley i havent been given any brief on...

I have 9 Win 2003 servers on our domain, all providing a variety of roles in a very satisfactory way. Unfortunalty a director is demading weekly statistics on every box to report on "(including availability & bandwidth usage, disk space used/available, memory usage), IIS, SQL etc that will give...

Thats great guys, that worked perfectly. Thanks again

I have to forward someone's email to his home account, no problem i thought its just a case of user properties- exchange general tab- delivery options etc. But it wont connect to an exterior email address, do i need to set up this address in the AD? Thanks for any help