Remote access on Windows Server 2008
Is it possible to limit remote access to my windows server 2008 so that you canremote connect only to the console session?
Answer Question
| Jan 6 2009 8:48 PM GMT | asked by ITKE
Windows Server 2008, Remote access, Remote connectivity
Domain group policy to turn off monitors.
We want to apply a domain group policy that turns off users monitorsafter 20 minutes. How can I accomplish this?
Answer Question
| Jan 6 2009 8:45 PM GMT | asked by ITKE
Group Policy, Domain Group Policy
CPYTOIMPF and EXCEL defaults
I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result.Example of data...
Answer Question
| Jan 6 2009 8:39 PM GMT | asked by Sbarnes
CPYTOIMPF, Microsoft Excel, CSV format
Is there a way to retrieve datatypes from stored procedures?
I have used the following simple query to retrieve datatypes from sql 2000 tables. select TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTHfrom <tablename>.information_schema.columnswhere table_name = '<tablename>' and column_name = '<columnname>'Is there a way to...
Answer Question
| Jan 6 2009 8:34 PM GMT | asked by TlogP
Stored Procedures, SQL tables, SQL 2000
restrict user access
for customizing data (spro) how can u restrict the access by company code for a user?
Answer Question
| Jan 6 2009 8:07 PM GMT | asked by Sapdcc
SAP user accounts, SAP user authentication, SAP Basis
RUNRMTCMD RMTUSER length
I am trying to run a batch file on a Network share....but I need to login with DOMAIN/USER which is more characters than the alloted 10 used for RMTUSER. I am trying to get my network people to include the AS/400 as a trusted host, or provide a local user name to avoid having the domain name, but...
Answer Question
| Jan 6 2009 6:52 PM GMT | asked by Jaggity
RUNRMTCMD, RMTUSER
Performance impact by using GUID instead of sequence as primary key
Is there anyone has experience on using GUID as the primary key in the data model of a huge data warehouse? What is the impact of the performance compare with the sequencial surrogate key in Oracle 10g or higher version?
Answer Question
| Jan 6 2009 6:46 PM GMT | asked by Jzliao
GUID, Data Model Primary Key, Data warehouse
Installation of Lotus SmartSuite on Windows Vista.
Using setup.exe, my installation got hung up at the very end with a not responding prompt. Any suggestions?
Answer Question
| Jan 6 2009 6:42 PM GMT | asked by Jdagnew
Lotus SmartSuite, Vista, Lotus SmartSuite Installation
How can I make w2k3 DNS server 'answer' for a given domain?
I want to forward requests for specific external domains to a page hosted locally on my IIS server - how do I set this up in windows 2003 DNS server?thanks
Answer Question
| Jan 6 2009 6:15 PM GMT | asked by Manwpod
DNS, DNS server, Windows Server 2003
EdgeSyncronization Troubles
I have followed multiple examples on how to subscribe my edge transport server to my hub transport server. I can export and import the file appropriately. When I use the cmdlet test-EdgeSyncronization I receive the following text:LeaseType : 0ConnectionResult :...
Answer Question
| Jan 6 2009 5:42 PM GMT | asked by AvAirComGuy
Exchange 2007, EdgeSynchronization, Edge Transport Server
Access Database - Colorize one word or letter
How do I colorize one character in a field in a table? I want the letter "O" to be in red for one customer and blue for another customer in the same column but different rows.
Answer Question
| Jan 6 2009 5:25 PM GMT | asked by BethG
Microsoft Access, Access Database, Access Database Format
Duplicate Record formula in Crystal 11
I have a formula written as such:If onfirstrecord then {CHART_IMPORT_ERROR.ERROR_MESSAGE} elseIf {CHART_IMPORT_ERROR.ERROR_MESSAGE} = previous({CHART_IMPORT_ERROR.ERROR_MESSAGE}) then """" else {CHART_IMPORT_ERROR.ERROR_MESSAGE} Currently " is showing up if the record above is a duplicate. ...
Answer Question
| Jan 6 2009 5:00 PM GMT | asked by Teknotekke
Crystal Reports 11, Crystal Reports Duplicate Records
Windows 2000 Server NICs
I added a second NIC in a new 192.168 ip range. How do I get it to talk nic 1 ( 101 ) to nic 2 (102)? I added a range entry in scope for dhcp but still not working.
View Answer
| Jan 6 2009 4:45 PM GMT | asked by WCM
Windows 2000 Server, DHCP server, NIC
Importing SQL Server 2005 tables from one server to another
My developers want to make a copy of a SQL Server 2005 database from one server to another, but due to company policy, I cannot give them the restore permission. So, as of right now, they are importing each table, one by one, from one server to other. Is there a way to import all of them at once?
Answer Question
| Jan 6 2009 4:44 PM GMT | asked by SQL Server Ask the Experts
SQL Server Table Migration, SQL Server 2005, SQL Server databases
Advantages and disadvantages of clustered indexes
What are the advantages and disadvantages of clustered indexes?
Answer Question
| Jan 6 2009 4:41 PM GMT | asked by SQL Server Ask the Experts
Clustered Index, SQL Server Clustered Index
SCOM Web Client
We monitor several customer environments with SCOM 2007, can I lock down the views on the web client so that each customer can log in and only see data (performance & Alerts) relating to their environment?
Answer Question
| Jan 6 2009 4:37 PM GMT | asked by Chod
scom web client, SCOM, SCOM 2007
How can I set the full path of file archive in outlook 2007 with GPO?
How can I set the full path of file archive in outlook 2007 with GPO?
Answer Question
| Jan 6 2009 4:33 PM GMT | asked by ITKE
GPO, Outlook 2007, File Archive
IP Address reverting back to old address
I have changed the IP address on one of my member servers every hour but itreverts back to an old address. I have 4 DC's and they are theonly DNS machines in my network. I have tried each DC separately buy still have the same issue. Any help
View Answer
| Jan 6 2009 4:31 PM GMT | asked by ITKE
IP address, DNS, Domain Controller
Microsoft Small Business Server 2008 migration error Exchange Server failed to install
While migrating to SBS 2008 i started receiving some installation errors. The main error i received was that the Exchange Server failed to install. How can i just reinstall the exchange server part of SBS 2008.
Answer Question
| Jan 6 2009 4:26 PM GMT | asked by ITKE
SBS 2008 Migration, SBS, SBS 2008
SBS 2003 to SBS 2008 Upgrade missing Update Service Server Computer Policy
We migrated from SBS 2003 to SBS 2008, but the UpdateServices Server Computers Policy is missing. WSUS seems to be working, however it has updates loaded for the old SBS 2003server. However, clicking "change the software update settings" in theconsole gives an error "update services group policy...
Answer Question
| Jan 6 2009 4:22 PM GMT | asked by ITKE
SBS, SBS 2008, SBS 2003
