Search results for query: *

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

Dear sir or madam, I am trying to restore my database from last night back up. Currently my back up run every hours and is listed as follow: NAVApplication16_00.TRN I need to restore from this specific time,and I do the following steps: 1. Enterprise Manager - right click on the specific...

I have a table under views named vw_members MemberID MemberName MemberAddress I need to add 2 more columns to the table SegoID SegoName How can I update the table with the new columns I really appreciate your assistance. Regards, Jimmy

Dear Sir or Madam,. I have a report group by Division and Department: example Division = 6A Department = Accounting Member= John Doe, Margaret Doe, etc Division = 6A Department = Marketing Member= Pete Doe, Sarah Doe, etc I like to add a security on the report if John Doe only...

I have a report in Cognos for Members Phone List. I want to automate the process and do the following: 1.Write a macro to automaticaly export the report to excel. 2.Create an schedule that run everyday at 9:00 am the automaticaly create the export that goes to excel. Please any help will be...

Dear Sir or Madam, I need to pulled data where that will includes all members that with join_date is greater than specific date. Example: All member with join_date greater than 11/12/2005. Select * From Members Where ????????? Thank you for your assistance Jim