Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Using schtasks.exe on Windows 2003 Server
- I am using schtasks.exe to create and run a scheduled task dynamically. My problem is sometime the scheduled task does not get started at all.How can I monitor this problem to resolve this problem?
- Tags: Servers, kaypaul@..., Microsoft Windows 2003, Microsoft Windows Server 2003, Microsoft Windows, server
- Discussion threads 2007-10-04
- SQL DTS to Check for TERADATA password expiry
- How can I check for the TERADATA password expiry 1 week before expiring via SQL DTS?
- Tags: Programming languages, kaypaul@..., SQL DTS, Teradata, SQL, password
- Discussion threads 2007-08-11
- Using "wscript" to send a message
- How can I use "wscript" to send a message from a Windows 2003 server to a specific computer on a network?Hi Kaypauluse a vbs script to call wscript.....wscript.echo "message goes here"save the above line in a file called something.vbs..... this will display a pop up box requiring users to click...
- Tags: Servers, kaypaul@...
- Discussion threads 2007-03-17
- Using Sybase
- What is the same utility in SQL Server 2000 like Enterprise Manger and Query Analyzer in Sybase?Where and how do I invoke these utilities?"Sybase Central" should be on the Sybase install CDs somewhere.You can use MS-Query or almost any SQL query tool to talk to Sybase.
- Tags: Databases, Sybase Inc.
- Q&A 2006-08-20
- Using Sybase
- What is the same utility in SQL Server 2000 like Enterprise Manger and Query Analyzer in Sybase?Where and how do I invoke these utilities?
- Tags: Using Sybase, kaypaul@..., software, Sybase Inc.
- Q&A 2006-08-20
- Using Sybase
- What is the same utility in SQL Server 2000 like Enterprise Manger and Query Analyzer in Sybase?Where and how do I invoke these utilities?
- Tags: Using Sybase, kaypaul@..., software, Sybase Inc.
- Q&A 2006-08-20
- Which SQL tables have access rights?
- I need to know which system tables in SQL 2000 contains the server role and database access rights are stored in.How can I trace the creation of tables, views, etc by users in SQL 2000?You can find out about the objects in your database from sysobjects table. Each database has...
- Tags: SQL, kaypaul@..., software, database, SQL 2000
- Q&A 2006-04-02
- Fast Track MS Project 2002 not working
- I purchased this Fast Track Microsoft Project 98/2000/2002, but the 2002 option is not working.When I click on MS Project 2002 Level 1 after logging in nothing happened.How can I workaround it to make it work?
- Tags: kaypaul@..., Microsoft Corp., Microsoft Project, MS Project 2002, software
- Q&A 2006-03-18
- Software Testing & Quality Assurance
- I need to information on software testing & quality assurance like books or internet sites.Covering area like Test Strategy, Test Plan,Test Design and Test Reports.Try these sites:http://www.softwarecertifications.org/http://www.softwaretestinginstitute.com/http://www.mtsu.edu/~storm/Try www.stickyminds.com
- Tags: software testing, Test, Try, kaypaul@..., programming, software
- Q&A 2006-03-09
- VBA script to delete mail in Outlook
- How can I delete a mail box item for the previous day using VBA script?Why can I get a sample coding or for exaples?This article in MSDN shows how to access messages in a folder and it also has code samples:http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/RulesWizard.aspIf you need more code samples, Sue Mosher's www.slipstick.com and...
- Tags: kaypaul@..., Microsoft Outlook, programming, VBA
- Q&A 2005-11-12
- Reset 'Enabled' to yes in SQL Server EM
- How can I reset the column 'Enabled' in the SQL Server Enterprise Manager screen using T-SQL?
- Tags: Databases, Enabled
- Q&A 2005-09-23
- Remote Desktop Connection
- I am able to use remote desktop connection to access my remote server on W2K. But how can I setup so that I can cut and paste between the remote server and my desktopXP?Unfortunately you can't copy and paste files directly from the remote desktop window to your local environment,...
- Tags: desktop, kaypaul@..., remote desktop, Remote Desktop Connection, remote server, server, window, windows
- Q&A 2005-09-06
- Runaway SQL Server Agent Job
- How can I monitor or stop a SQL Server Agent Jobif it has ran for more than 15 mins.Hello,In order to stop an SQL Server Agent job, just use the Enterprise Manager and go to the Management, SQL Server Agent, Jobs folders. Within the "Jobs" folder, right click on...
- Tags: Answer 2, hardware, job, kaypaul@..., Microsoft SQL Server, Seconds, SQL Server Agent, SQL Server Agent job
- Q&A 2005-09-06
- DTS ActiveX calling Excel Macro
- I have a DTS package ,which used ActiveX to call Excel application macro to update a few worksheets.Each time it execute in the SQL Server Agent, it seem to go on forever. Usually takes around 5 to 7 mins. But, if I execute manually sometime it completed successfully and recently...
- Tags: DTS, DTS ActiveX, hardware, kaypaul@..., MAKE SURE, Microsoft Excel
- Q&A 2005-08-10
- SQL DTS Connection - MS Excel 97-2000
- I am currently DTS with ActiveX to call Excel application to update worksheets by a macro with Excel installed at the server.I am looking for a solution of not to installed Excel at the server and looking for an alternative solution.I was looking at using DTS Connection - MS Excel...
- Tags: DTS, hardware, kaypaul@..., Microsoft Corp., Microsoft Excel, SQL
- Q&A 2005-07-28
- SQL DTS Task - Dynamic Properties Task
- I intend to use DTS task called Dynamic Properties Task. Where can I get more info and examples on how people used in production for batch processing.What are the limitations or FAQ to look out for before implementing?
- Tags: DTS, DTS Task, Dynamic Properties, Dynamic Properties Task, hardware, kaypaul@..., SQL, SQL DTS
- Q&A 2005-07-28
- SQL Backup Error 3266
- My backup are failing daily with these error message:The backup data in 'TRates_BackupToDEV' is incorrectly formatted. Backups cannot be appended, but existing backup sets may still be usable. [SQLSTATE 42000] (Error 3266) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.MS Says http://support.microsoft.com/default.aspx?scid=kb;EN-US;290787Which I've got...
- Tags: backup, hardware, kaypaul@..., SQL
- Q&A 2005-07-21
- SQL Sessions
- How can I logoff user sessions on SQL at a certain time of the day?As I need to run a batch and don't want any usersconnecting to the SQL.Like you here's me looking for sp_kill @spid. No such thing apparently. Haven't tries it but this fella says the solution ishttp://www.developerkb.com/modules/wfsection/article.php?articleid=27I...
- Tags: Programming languages, SQL
- Q&A 2005-07-20
- Restore SQL Server 2000
- When I restore from SQL Server 2000 from a development server to another new server running Windows Server 2003, I received and error message that said "Device offline or Device not available".Dear Sir,my firs questin is with which software you back up and restore your Data Base.It is very important,...
- Tags: Data Base, kaypaul@..., server, software
- Q&A 2005-06-29
- SQL Server Agent - Multi-Server Administration
- Where can I get more information on this topic.As I am going to try using this feature of SQL Server 2000.I need to know the pros and cons of it. Can anyone help!http://msdn.microsoft.com/library/ en-us/adminsql/ad_automate_7ir2.aspI have seen this site. What I needs is more details andexperiences on using this feature of...
- Tags: agent, hardware, kaypaul@..., Microsoft SQL Server, SQL Server Agent
- Q&A 2005-03-07