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...
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...
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'...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.