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...
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...
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?
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...
Hello everyone,
We have SQL Server 2000 and I need to upgrade to SQL server 2005. We purchased a new server and I installed SQL Server 2005 on it. My question is: can I simply use the Copy Database Wizard to copy all of the Databases from the old (2000) server to the new (2005) server and then...
Hi All,
I would like to open Windows Explorer and go to a specific location (i.e. C:\Myfolder\). I'm basically telling the user that the file he is looking for is on the network at a specific location and I would like to give him the option to open this location. I tried to use the Shell...
Thanks for your help.
On the T1 we have a router (default gateway) and a firewall. On the DSL side, we only have a DSL modem and a Linksys router, no firewall. We’ll be getting a firewall eventually. Is there is anything that I need to do on the Linksys router so that it routs all exchange...
Yes, the parser will call the dialer and the dialer will dial out and terminate itself (i.e. use the End statement at the end of your code). You don't have to use a db, I thought it might be a good idea if you want to keep track of the process (i.e. when was each message created, sent, success...
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.