Taggs

Please excuse my basic knowledge of SQL. I have two tables on a MS SQL2000 sp4 database Table name - Details id forename Surname dob email Table name - DetailsHistory id forename Surname dob email When somebody changes (Update) a row in Details, I want to create a trigger to : Before the change is made copy the current row to the DetailsHistory table here is my code CREATE TRIGGER savetohistory on [dbo].[Details] for update as BEGIN INSERT into DetailsHistory select * from Details where id = Details.id END; but this copies ALL the rows not just the current row Taggs

That works just great Thanks

Can anyone tell me how to switch on C$ sharing on a W2k server please. Thanks Taggs

Managed to sort now.

OK i've found some things else where on the internet. Not an ideal method but it works to a fashion. I have to run a reg entry on the local pc. HKEY_CLASSES_ROOT called 'myprog' key called 'URL Protocol' sub-keys: \shell\open\command default string Key to: " c:\my prog\prog.exe" On my web page I have a link as: <A HREF="myprog:">run myprog</A> This opens the app great, but i want to pass a parameter as well. ie prog.exe /a:10.10.10.10 I've found default string "c:\my prog\prog.exe %1" <A HREF="myprog: %a %b %c">run myprog</A> but it does not like the "%1" at the end I've also tried "c:\my prog\prog.exe" "%1" but still it does not like it? I hope this makes sense. Any Ideas?

Hi can someone help me please? I want to run a local executable from an asp web page. I dont care about the security issues etc as the site is and only will be, internal. Here is the type of thing i want to do <a href="file:///C:/WINDOWS/system32/mstsc.exe /v <% response.write(servername) %>"> <img align="center" border="0" src=<% response.write("""\images\" & model & ".gif""")%> width="400" height="151"></A> I am runing IIS 5 I want it as simple as possible please. Thanks Taggs

Are you trying to access this site on the local machine? http://<server name>/WSUSAdmin/ You will also need to edit the registry (on every machine) with something like this to get the PC's to connect for updates Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate] "ElevateNonAdmins"=dword:00000000 "TargetGroup"="Servers" "TargetGroupEnabled"=dword:00000001 "WUServer"="http://<server name>:80" "WUStatusServer"="http://<server name>:80" [HKEY_LOCAL_MACHINE\SOFTWARE\Policies\Microsoft\Windows\WindowsUpdate\AU] "AUOptions"=dword:00000004 "AutoInstallMinorUpdates"=dword:00000001 "DetectionFrequencyEnabled"=dword:00000001 "DetectionFrequency"=dword:00000012 "NoAutoRebootWithLoggedOnUsers"=dword:00000001 "NoAutoUpdate"=dword:00000000 "RebootRelaunchTimeout"=dword:00000720 "RebootRelauchnchTimeoutEnabled"=dword:00000001 "RebootWarningTimeoutEnabled"=dword:00000000 "RebootWarningTimeout"=dword:00000030 "RescheduleWaitTime"=dword:00000003 "RescheduleWaitTimeEnabled"=dword:00000001 "ScheduledInstallTime"=dword:00000003 "UseWUServer"=dword:00000001 "ScheduledInstallDay"=dword:00000000 or delivery it from GPO (much easier!) ;-)

Can anyone suggest a piece of software that will allow me to give specific rights to a developer for admin support/development of applications/databases (also revoke rights) but not give them full control over the server. (ie can't change the Kernal, installed drivers, chance OS dll's,start/stop services etc)? Thanks Taggs

I'm no expert so i couldn't tell you how to do it but could you not either get the website script to either email you or send a popup to your IP address?? I can't help with the coding but I'm sure there is code on the web to to do this.

That worked great, thank you!

Can any one help me please. I'm after selecting rows that are blank but I'm having difficulty. row 1 row2 row3 ------------------------ Col1 A A Col2 A A A Col3 A A Col4 A A B Col5 A A B Some of the things I've tried using sql select * from Tablename where row3='' select * from Tablename where row3=null select * from Tablename where len(row3) <1 I would be after the returned record set to consist of Col1 and Col3

Can anybody tell me a command or way of identifying which version of the OS is on the server I remotely connect to? I tried dos VER and Help > About from a window and this only tells me that it is Windows 2000, build number and service pack. The information I am trying to collect is, is the server a Windows 2000 Std, Windows 2000 Adv, Etc... If I click the start button on the server it comes up with the Windows version on the start bar but not if I’m remotely connected and I don’t wont to have to go around several sites collecting data for over 100 servers. Thanks Taggs Don't worry, I've sorted now. Thanks

@nmX.Memnoch Sorry I didn't pick up on the fact about the IIS versions earlier. It now works. Thanks

can anybody else throw any light on this plz?

@nmx.Memnoch I've tried adding the MIME type at both levels. @InTheWayBoy I'm running W2K server SP4, Server Protect (TREND), No firewall, IIS is version 5

Added .bat as a MIME type but still will not download. Tried several different types but still nothing! Checked/tried IIS settings for the main site and the web site.

I have an internal web site which has a link to a batch file. But when you click the link, you get the message "Page can not be found". If I change the extension to a .BOT from .BAT the file is displayed the web browser. There is also other links to an .EXE and .REG and they work fine. My problem is I want people to be able to download the batch file to there PC. I've renamed the file to several different formats, recreated the file but still nothing. I suspect it is a setting in IIS on the server. Any ideas? Taggs

I've had to re-install WSUS on the Master server and all seems to be working OK now. Also had to D/L 3Gb of updates again as when I re-installed using "save updates" the down-stream servers still would not download the files. Also 'retry download' on the down stream servers and hey-presto!

No proxy settings need as it is pointing internal. It has worked fine for the past 4-5 months.

I think I've narrowed it down to error 502 bad gateway but I'm unsure how to fix this? Can anybody help?

I've also tried to decline the download of the files and then retry but still nothing. I've also tried to restart the Update and b.i.t.s. services but still nothing.

My downstream WSUS servers are not downloading the latest approved patches from the Master WSUS server. I have approved several of the updates on the master server and it says it has downloaded them from the WU site ok. I then synchronzied the downstream servers and it is says it was successful on all of the D-S servers. All servers now say they need 17.68Mb for 9 files, to download from the Master Server but it does not start to download these. I have run "wsusutil.exe reset" and it checks the files but stops again needing 17.68Mb. I have two other sites running from this server on port 2000 and port 2001. I have changed the ports and run a sync but still the same. I have also stopped these sites and run a sync but still nothing. Any ideas?

Can anybody point me to where I can find the database schema's for WSUS. I'm after creating some automatic reports for management. I've had a look at the database but I cant find or decipher where is holds the data for clients with errors, clients needing updates etc.... Thanks Taggs

Try running this batch file to get the client checking in. It takes anywhere between 1 - 8 minutes usually to check in with the wsus server. http://support.microsoft.com/?kbid=555453 Can you go to the server and open the SQL Enterprise Manager tool and check that the sql server is running and that there is a SUSBD database. Also Check that Automatic Updates service is running on the PC.

Thanks, that script seems to work when WUAUCLT.exe /detectnow on its own doesn't.