Recent content by Jimmy24

Dear Sir or Madam, Thank you in advance for your assistance. I have 1 table A in Microsoft access. This table contain only 3 columns. In the table the data reads like Here what I have LOGID BTID MESSAGE 25 91 SEQ_MEMB_ID: 7836648; RSTORE_SEQ_ID: 7192656; I need to create a new...

Dear Sir or Madam, I have restored 2 new database into a new server, this new server has not login, I need to run sp_help_revoklogin, do I need to run the sp on the old server or the new server. I am a little confuse how to use the sp. Thanks in advance for your help

Dear Sir or Madam, I need to perform a full database restore to database D1 on Server SQL Server US1. I need to get my backup "D1_backup.dmp" from Server US2. Can you please provide me some assitance with the syntax. I appreciate your assitance in advance. Thanks James RESTORE DATABASE D1...

Mr. Paul, SInce both queries are pointing the same database can I place both queries just the way I described below or I need to add something else at the beginning such as exe etc. I appreciate your advice. UPDATE gltran SET gltran.user1 = apdoc.user1 FROM dbo.APDoc INNER JOIN...

Dear Sir or Madam, Do i need to write a store procedure first or just the queries.... Jimmy

Dear Sir or Madam, I have the following SQL queries that I need to schedule to run every night via SQL Enterprise Manager. Would you please provide me an advise how is the best way to do it? I appreciate your help in advance. Jimmy UPDATE gltran SET gltran.user1 = apdoc.user1 FROM...

Dear Sir or Madam How can I check which users are currenly connected to my IIS server? Thank You in advance. Jimmy

Dear Sir or Madam, I have a field called name that the length is 30, I have some names that a very long over 40. I need to truncate those names that has more than 30 caracters to make them 30. Would you please assist. Thank you in advance James

Dear Sir or Madam, I have an excel spreadsheet, every cell contains the below code under query. Would you please tell me what is the purpose of the code... Regards, james Provider=Microsoft.Jet.OLEDB.4.0; User ID=Admin;Data Source=H:Emp phone directory list.xls;Mode=Share Deny Write...

Dear Sir or Madam, I need to create a calculation in Cognos that provide me with a PTO Accrual. I am wondering if someone be so kind and guide me how to create this calculation... Regards, Jim

Dear Sir or Madam, I have the following excel macro that copyies our employee phone list. We have about 17,000 user that are using this form. The problem I am having is the security tab under tools==> macros==>security is setup to high to all 17,500 user. Would you please be so kind and tell...

Dear Sir or Madam, I have a SQL db that I need to rename from SIVApps to MISIVApps. How would be the best way to do it? Thank you in advance for your assistance. Regards, Jimmy

Dear Sir or Madam, Would you please assist me with the following task. I have the below copydata macro, that refreshes data from another worksheet, I like to be able that after finished refreshing the data to hide the entire column B. Would you please advice. Thank you in advance Sub...

Dear Sir or Madam, I have a current production enviornment of SQL 2000 with about 60 databases on SQL server A. I have finished building a SQL server B for testing and I would like to copy 2 of the databases from production into testing. What would be the best way to do it. Copy 2 (db's)...

Dear sir or madam, I need to setup IIS timeout when the webpage is in idle for more than 30 sec to timeout. WOuld you please advice how to do it. Regards, Jimmy