Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JordanCN2
  • Content: Threads
  • Order by date
  1. JordanCN2

    Problem changing PID key on W2003 R2 with SP 2 installed

    The two Windows 2003 servers we have now were purchased as OEMs. We are growing so we purchased some volume licenses so we could virtualize the servers. We cannot legally use the P2V converters on the existing OEMs because this is a change of hardware when we go virtual. We do not want to...
  2. JordanCN2

    Large INSERT query fills C: Drive because of tempdb

    On my C: Drive I have 128GB mirrored drive for the OS (about 90 GB free) and a 3 TB RAID-5 E: Drive for all my SQL Data. The db that I am copying from the old server has several tables in it and one of them is 129 GB with over 5 million records. Long story short, I cannot just backup the old...
  3. JordanCN2

    Make INSERT INTO continue even when an error occurs

    I have a table with about a million records in it. I need to alter the data in one of the columns to add some info to it so I want to just perform a INSERT INTO TABLE-NEW SELECT {MYQUERY} FROM TABLE-OLD When I do this I get the error: OLE DB provider 'SQLNCLI' for linked server 'MYSERVER'...
  4. JordanCN2

    Importing data from SQL 2000 to 2005 and changing a field

    We are upgrading a database that is on a SQL 2000 server up to SQL 2005. The database name on the servers and the table names will be the same, however a field or two in many of the tables will be expanding by a couple of characters to make room for expanded order numbers which is why I cannot...
  5. JordanCN2

    SQL 2005 changed domains - reset security

    Our company purchased another company and created a temporary trust in Active Directory between Company A and Company B. The small Company B had just on server which was their DC and SQL 2005 server. We just took down the Company B domain by using DCPROMO to remove this server as the last DC...
  6. JordanCN2

    Merging our domain and exchange 2003 into a new company's forest

    Our company was recently purchase by another and they want to merge our exchange server into their domain so we will all be on the central GAL and we can have access to each other's calendars. We have a single 2003 domain "mydomain.com" and a single Exchange 2003 server. They have a forest of...
  7. JordanCN2

    Check if logged in user has RW permission to a table

    I am using MS Access as a front end to a SQL 2000 (Soon to be 2008) back end. Is there a simple way for me to check if the current logged in user has read/write access to a table. I secure the back end tables with Windows Integrated security. Currently we are small so users do not usually try...
  8. JordanCN2

    Use varilable to reference control name

    I am trying to loop through the controls on a subform and take all the values from the text boxes and set the same named text boxes on the main form to the same value. I would like to do it by using a variable The code below gives me an error referencing Me.Parent!strParentControlName because...
  9. JordanCN2

    Get vbscript to extract last pwdLastReset from AD

    I have a pretty good script I downloaded that extracts a lot of good info about users from Active Directory and puts it into and Excel file, however I am having trouble getting the last change date property. I believe it is how pwdLastSet is stored in AD as an 8 binary or something. Right now...
  10. JordanCN2

    Need Access 2003 to edit SQL tables that have BigInt

    I am kind of in a pickle here. I really only know Access to do my update queries however the developer of one of our software packages updated a lot of the tables to include a BigInt column in a lot of the key tables. This is not something that I can change. I know I can do views easy enough...
  11. JordanCN2

    Strange error on MSComCtl2.DTPicker.2 ActiveX control

    I am getting some odd behavior from the DTPicker control (MSComCtl2.DTPicker.2) on one of my Access 2003 forms. I did make a couple of changes to this form to add a frame control, a drop box and a combo box, however I can't see why I am getting the following errors: The first and only first...
  12. JordanCN2

    Excel Pivot Tables - Don't group row headings

    I have a pivot table like this in Excel 2003: Q1 Q2 Q3 Q4 Rep Customer -------------------------------------- DJ | IBM Corp 200 400 200 100 | XYZ Corp 300 500 100 300 | Lotus 600 700 200 200 SV | IBM Corp 100 300 100 100 |...
  13. JordanCN2

    Fiscal calendars not at normal end of months

    Our company switched from standard end of months (1/31, 2/28, etc) to a quarterly fiscal calander where the months are divided up into 5-4-4 weeks (13 weeks each) for the 4 quarters. Here is an End Of Month table: Table Name = EOM Year Month Quarter StartDate EndDate 2011 Jan 1 1/1/2011...
  14. JordanCN2

    Local Delivery SMTP queue filling, mobile device errors

    All of a sudden today we started to have a major issue on our Exchange 2003 Enterprise SP2 server running on a Windows 2003 box. It is behind a firewall with HTTP/HTTPS, POP3, and SMTP open. Our MX records point to our Anti-spam service off site and they send us the mail after. SMTP on...
  15. JordanCN2

    Export report - Crystal 8 and VBA (Access 2003)

    I have an old project that used the GLOBAL32.BAS module in an Access 2003 project to run a Crystal 8 report and display to the screen. I want to change the code below to automatically export this to a file instead of printing to a screen. I have not decided if I want it to be an XLS, DOC, or...
  16. JordanCN2

    WDS / RIS legacy - RIS does not create PNF files

    I replaced my old Windows 2000 RIS server with a new Windows 2003 R2 x64 Server using WDS and RIS Legacy mode. My legacy RIS images have been working fine except I can not get new NIC drivers on any of my images to work any longer for the text portion of XP setup. On the old Windows 2000 I...
  17. JordanCN2

    Changing location of GPO software installation

    I read that we can use the Migration Table Editor to mass replace our GPOs Software Installation settings share names from \\Server1\Share\ to \\Server2\Share\. When we do this, would the software in those GPOs attempt to redeploy? We deploy at least 50 different packages via GPO and do not...

Part and Inventory Search

Back
Top