Search results for query: *

Check the following registry keys to see if the policies are still being applied: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Group Policy HKEY_Local_Machine\Software\Microsoft\Windows\CurrentVersion\Group Policy Also check to see if the settings within the policies may still...

Just use "Only allow local user profiles". You don't need both.

System Volume Info folder could be inflated. You cannot see what is in there.

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...

Thanks, That worked out for me. I don't know how the strange data got into the float field, but this worked out.

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'...

Finally I have success..... I was getting errors on the linked tables because I was trying to connect to the SQL 2000 SP4 x32 database from the SQL 2005 x64. MS has an article about how a sql script needs to be run on the 2004 server after installing SP3 or 4 in order to connect with a x64...

The DB is too big to restore to the new server and copy. It has about 10 years worth of data in it and a lot of that needs to be transformed and filtered out which is why I want to use the queries to correct and filter the data. I have been doing some Googling and found some leads on what...

That is kind of the part I am having difficulty with. It was easy to create the SQL to create all the tables, but I would really like to be able to have a script that also: - Connects to the old SQL2000 server - Run a copy query like this for each table: INSERT INTO [My Orders] ( OrderNum...

How about this ... 1. I ran the wizard to extract the structure of the DB into a SQL script (Tables, Views, Users) 2. I altered the SQL to change the fields that needed to increase. So now I have the structure I want ready to import. 3. I go to the SQL 2005 server and run this script which...

Yes, on a few tables there is a ton of junk that I need to leave behind and that would be filtered out with the query on the transfer. There are hundreds of GB in these tables and about 10% is junk data. This is why I cannot do a simple backup, copy, restore and STUFF. The original programmer...

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...

That is not an editable query. You have what appears to be a one to many query so Access cannot edit the records.

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...

Is it the same HAL type as well? Other drivers can interfere. Is it possible to install the Mobo in another computer wint 2003 SP2 fresh and compare the HW changes? Search MS's site for Q249694 on how to install Windows to new hardware. If you disable all non windows service like Exchange...

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...