Recent content by BlueTube

Hi all, I’m new to Virtualization and Hyper-v. I’m building a new server running Hyper-v 2012 to be used for (host) tow servers: a SQL Server and a Domain Controller/DNS/DHCP server both running Windows Server 2012 guest operating system. My question is about the RAID configuration on the...

Thanks so much for your help

Hi there server experts, We currently have two Windows Server 2003 domain controllers in our network. I’m looking to buy two new servers and install Server 2012 Standard on them and then make these 2 new servers the domain controllers and retire the old 2003 domain controllers. Can I just...

Thanks for your help lameid but I don't think that I can "link" a table using ODBC, I get an error. I don't want to use ado.connection object I was hoping that I can just link to a table using the DoCmd.TransferDatabase acLink or any other method that will get the same result (a linked table in...

Hi all, I’m trying to link to a table in a secure access database from another access database. However, I don’t want the user to be prompted for a password when I link, is there is a way to do this in vba? I’m using DoCmd.TransferDatabase acLink to link to the secure access database table and I...

Thanks SQLSister. But my app cannot create a stored procedure. I guess my question is: how can I include some code in a T-SQL script to open a file and read from it? i.e. let's assume that I have the file C:\somescript.txt with the code " drop database ABC" in that file, how can I write a T-SQL...

Hi all, I’m trying to create a SQL Server T-SQL script that will basically drop and restore certain database on a daily basis. Because the names of databases that need to be restored may vary, the script may also vary. I have a VB Program that creates the script based on some parameters. I would...

Hi All, I need to be able to give a user access to Active Directory Users and Computers. I thought there was a way to install Active Directory on his XP PC and he can manage it from there. I know that I can make him logon to the server remotely using RDP, but I don't want to make him part of the...

Thanks Paul. How do I change the sort order?

I have two instances of SQL Server 2005 running on two different servers on the same network. One of the instances’ sort order is the default sort of SQL Server. The second one is running Latin 1 General Binary sort. I would like to move two of the databases from the first instance to the second...

Hello everyone, In my application, users can select other applications to be added as short cut in my application. When users click on Brows, I open the open file dialogue box and users are then allowed to select the applications they want to add (i.e. Winword.exe). I want to be able to bring...

I need to be able to run a program (exe) as the administrator while the actual user is logged in. Basically I need to mimic the “Run as” in windows explorer when you right click on a program it allows you to click on Run as to run it as a different user. Anyone knows how to do this?

you can try regedit.exe and also try regedt32.exe

Hello everyone, All our users are setup as part of the "users group" on their PCs' to prevent them from downloading and installing any "bad" programs. Now, ADP for windows (payroll software) cannot run unless the user running it has administrative privileges on his/her PC. I need to know how to...

Thanks guys! This is great!