Recent content by Calen

Thank you very much for checking. The version we need is from early 2002. In case that helps someone locate the CDs. Calen Computer Systems Process Engineer

Hi, We have an eight year old network of SCADA PC's that control some manufacturing equipment. At the begining of the month we suffered a hardware failure on the only server. (I didn't design or build the system, I'm just the most recent administrator.) (And, yes, we are planning on a...

Hi, Somehow, my Internet Explorer 7 has become set to Always on Top. This is not just very annoying, it has caused me to miss other windows, when I otherwise expected to see them on top as the most recent one called. How can I turn this "feature" off? I've looked through all of the settings...

Thanks for the reply, DavidMichel. No, without the Tape Engine service the backups don't work. As this is being done on a validated system, I don't have the leeway to experimentally edit the registry. Is there any other way known to get ARCServe 7 to automatically start after a reboot and...

Hi all, We have a validated system running Windows 2k and ARCServe 7, and I've been tasked with making ARCServe restart automaically when the server is rebooted. (Currently someone has to remember to restart ARCServe after the system is restarted.) However, when I set the ARCServe DB, Tape...

Hi all, My company is planning on purchasing SAP, and switching our database to DB2. (Currently we're using a mixture of flat files on Unix boxes and SQL Server.) Can anyone provide me with some links or suggestions to get some DBA training for DB2? This could help me keep my job. All help...

Thanks MDXer, I was searching for the answer to a similar problem, and your solution worked for me. So a thank you star to you. Calen

Thanks markVII, I have a similar task to what batteam described (only I have 14 50 to 100 MB files, with more coming) and have been getting the same error message tyring to import them into a SQL Server database. After breaking each of the flat files into 2 (or more) pieces, I was able to...

Thanks to both of you! I entered a search for a C# to VB.Net converter and found this thread. Thanks redss, the converter you gave the link to, was just about exactly what I was looking for. Do you know of others? I recently inheirited a C# project that needs to be changed and redeployed next...

Thank you very much for replying, Durkin! Yes, I'm trying to use a SQL Agent Job to do this. I tried what you said, and every variation of it I could think of: EXECUTE xp_cmdshell '"C:\Program Files\Internet Explorer\iexplore.exe...

Hi all, I need to have a scheduled job shut down a web community, do a database backup & restore, and then restart it. Something like this: COPY DATABASE... http://mydev/devmgr/CommStart.html?COMMUNITY=MyComm&ACTION=Stop RESTORE DATABASE...

ajacode, To answer your question: C). 12:00:00 AM is the same as 00:00:00 and SQL Server would be happy with either as an input.

Sorry to disagree SQLBill, but 12:00 AM is Midnight. 12:00 PM is Noon. If you set a datetime variable to a date with no time, it will use 00:00.00 as the default time. Try this in Query Analyzer: DECLARE @Time DateTime SET @Time = '1/1/1' PRINT @Time The result is: Jan 1 2001 12:00AM Calen

Does anyone know if the procedure in the MS Knowledge Base article "HOWTO: Put Stored Procedures Under Source Control in Visual InterDev" MSKB # 201240 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;201240) or the MSDN article "Versioning Stored Procedures with Visual...

Does anyone know if the procedure in "HOWTO: Put Stored Procedures Under Source Control in Visual InterDev" MSKB # 201240 (http://support.microsoft.com/default.aspx?scid=kb;EN-US;201240) will work for SQL Server 2000? Thanks Calen