Copy BLOB to BLOB using TSQL
Is there a way I can copy a BLOB from one column to another using TSQL ?
Answer Question
| November 19, 2010 1:37 AM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2
Is there a way I can copy a BLOB from one column to another using TSQL ?
Answer Question
| November 19, 2010 1:37 AM
BLOB, BLOB TSQL, SQL Server 2008, SQL Server 2008 R2
Is it safe to delete SQL Server Transaction Log?
In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but [...]
Answer Question
| November 18, 2010 11:59 PM
Delete Transaction Log, SQL 2005, SQL Server 2005, SQL Server logs, SQL Server transaction logs, SQL transaction logs, Windows Server 2003
In one point, I create two Transaction Log for a database, and now I want to delete the second Transaction Log in order to free more space. I just want to get ride of the second file. Is it safe to delete it? SQL Server allow me to do it from DATABASE PROPERTIES WINDOW, but [...]
Answer Question
| November 18, 2010 11:59 PM
Delete Transaction Log, SQL 2005, SQL Server 2005, SQL Server logs, SQL Server transaction logs, SQL transaction logs, Windows Server 2003
Mobile user can’t access mapped drives in local area
[html xmlns=""> Hello all. I have an unusual problem. Here is the situation. We have a head office domain with file servers based here in New Zealand. We also have a remote server at our Melbourne, Australia office. We use file sync software to mirror different folders to the remote server so that the Melbourne [...]
Answer Question
| November 22, 2010 9:42 PM
File servers, File Synchronization, IPsec, IPsec VPN, Mapped Drive
[html xmlns=""> Hello all. I have an unusual problem. Here is the situation. We have a head office domain with file servers based here in New Zealand. We also have a remote server at our Melbourne, Australia office. We use file sync software to mirror different folders to the remote server so that the Melbourne [...]
Answer Question
| November 22, 2010 9:42 PM
File servers, File Synchronization, IPsec, IPsec VPN, Mapped Drive
Outlook 2003 cannot connect to the server via HTTP any longer
I set up work laptops with XP and Outlook 2003, the server is Exchange SBS 2003, and using RPC over HTTP to access the mailbox works fine for the guys off site, recently we changed to new laptops with Windows 7, Outlook cannot connect to the server via HTTP any longer, any ideas
Answer Question
| December 13, 2010 9:37 PM
Exchange 2003, HTTP, HTTP access, Outlook 2003, Small Business Server 2003
I set up work laptops with XP and Outlook 2003, the server is Exchange SBS 2003, and using RPC over HTTP to access the mailbox works fine for the guys off site, recently we changed to new laptops with Windows 7, Outlook cannot connect to the server via HTTP any longer, any ideas
Answer Question
| December 13, 2010 9:37 PM
Exchange 2003, HTTP, HTTP access, Outlook 2003, Small Business Server 2003
Crystal Reports 8.5 Cannot insert Field or Text Objects
I have been using 8.5 for years without any problem. Recently I have been unable to create any new reports. I am not allowed to insert any field or text objects. I am also unable to modify any of the existing thousands of reports. I have reinstalled a number of times. It will work for [...]
Answer Question
| November 24, 2011 9:13 PM
Crystal Reports 8.5, Crystal Reports error messages, Crystal Reports Errors, Oracle 10, Windows XP
I have been using 8.5 for years without any problem. Recently I have been unable to create any new reports. I am not allowed to insert any field or text objects. I am also unable to modify any of the existing thousands of reports. I have reinstalled a number of times. It will work for [...]
Answer Question
| November 24, 2011 9:13 PM
Crystal Reports 8.5, Crystal Reports error messages, Crystal Reports Errors, Oracle 10, Windows XP
System i Access Windows 7 V6R1 install error 1713
I’m installing System i Access for Windows V6 R1 M0 on a Windows 7 machine and I’m getting the “Error 1713…cannot install one of its required products” error. I’ve tried deleting the installed objects, cleaning the registry, rebooting and installing. No Luck. This is the first problem in about 100 identical installs. What am I [...]
Answer Question
| July 19, 2011 8:45 PM
Client Access, iSeries error messages, iSeries V6R1, System i, System i Access, V6R1, Windows 7
I’m installing System i Access for Windows V6 R1 M0 on a Windows 7 machine and I’m getting the “Error 1713…cannot install one of its required products” error. I’ve tried deleting the installed objects, cleaning the registry, rebooting and installing. No Luck. This is the first problem in about 100 identical installs. What am I [...]
Answer Question
| July 19, 2011 8:45 PM
Client Access, iSeries error messages, iSeries V6R1, System i, System i Access, V6R1, Windows 7
Can’t open Lotus Domino administrator
Just upgraded my desktop client from 6.5 to 8.5.1 FP4 & now when I try to open the administrator I get the message: No default domain found: Please set your administration preferences to the domains you want to manage. How can I set the administrataor pref’s if I can’t open the administrator? What can I [...]
Answer Question
| November 18, 2010 8:01 PM
AS/400 Client Access, Domino 6, Domino Administrator, Domino error messages, Domino Notes client, Lotus Domino error messages, Lotus Domino upgrade, Lotus Notes 8.x
Just upgraded my desktop client from 6.5 to 8.5.1 FP4 & now when I try to open the administrator I get the message: No default domain found: Please set your administration preferences to the domains you want to manage. How can I set the administrataor pref’s if I can’t open the administrator? What can I [...]
Answer Question
| November 18, 2010 8:01 PM
AS/400 Client Access, Domino 6, Domino Administrator, Domino error messages, Domino Notes client, Lotus Domino error messages, Lotus Domino upgrade, Lotus Notes 8.x
Can an Access 2003 query exclude the results from a previous query?
I have a database with 2 tables: one with name/address info, and another with info on yearly donations to our organization. The 2 tables are linked through an ID number. I have set up a query that will give me name/address info for those who donated in 2010 (where the year field is 2010 and [...]
Answer Question
| November 17, 2010 7:37 PM
Access 2003, Access Database, Access query, Query Parameters
I have a database with 2 tables: one with name/address info, and another with info on yearly donations to our organization. The 2 tables are linked through an ID number. I have set up a query that will give me name/address info for those who donated in 2010 (where the year field is 2010 and [...]
Answer Question
| November 17, 2010 7:37 PM
Access 2003, Access Database, Access query, Query Parameters
Use of Microsoft Office in cloud
Is it possible to use an excell file and upload in the cloud and a collegue to update that file in a different location. Also how big can the file be.And how much would licence cost to use microsoft office 2007 in the cloud?
Answer Question
| June 6, 2011 6:09 PM
Cloud Computing, cloud computing services, Office 2007, Office 2007 deployment, Windows Licenses
Is it possible to use an excell file and upload in the cloud and a collegue to update that file in a different location. Also how big can the file be.And how much would licence cost to use microsoft office 2007 in the cloud?
Answer Question
| June 6, 2011 6:09 PM
Cloud Computing, cloud computing services, Office 2007, Office 2007 deployment, Windows Licenses
Open IT Forum: Where do you fall in the data center buy v. build dilemma?
Building a data center in response to overwhelming data growth comes as an easier decision to some, but what about the rest of us? What are the pros and cons you’ve experienced when either buying servers through a service or building your own data center from the ground up? We love lists and stories, and [...]
Answer Question
| November 23, 2010 3:44 PM
Data center budget considerations, Data Center Build, Data Center in 2010, Data Center management, Data center operations, Open IT Forum
Building a data center in response to overwhelming data growth comes as an easier decision to some, but what about the rest of us? What are the pros and cons you’ve experienced when either buying servers through a service or building your own data center from the ground up? We love lists and stories, and [...]
Answer Question
| November 23, 2010 3:44 PM
Data center budget considerations, Data Center Build, Data Center in 2010, Data Center management, Data center operations, Open IT Forum
Rename Printers in logon for Windows Server 2003, with VBScript
Hi peeps! another question! this has been buggin me for a while. right i have a windows server 2003 SP2 domain (Not R2) and i have about 90 windows xp profesional SP3 clients. now i have at least 3 printers that are being shared. the printer share names are printer2 printer3 printer4 when staff and [...]
Answer Question
| November 17, 2010 2:36 PM
Login scripts, VBScript, Visual Basic Script, Windows Server 2003 R2, Windows XP Professional SP3
Hi peeps! another question! this has been buggin me for a while. right i have a windows server 2003 SP2 domain (Not R2) and i have about 90 windows xp profesional SP3 clients. now i have at least 3 printers that are being shared. the printer share names are printer2 printer3 printer4 when staff and [...]
Answer Question
| November 17, 2010 2:36 PM
Login scripts, VBScript, Visual Basic Script, Windows Server 2003 R2, Windows XP Professional SP3
Changing proxy rights for select users
I work in a company that has a proxy who can limit the people acces into some sites,my question is…what changes can i do to the proxy server to accept these sites for one or more users?(usual changes into one basic proxy server)
Answer Question
| November 18, 2010 1:30 PM
IT Compliance, Proxy Server Configuration, Proxy servers, Server configuration
I work in a company that has a proxy who can limit the people acces into some sites,my question is…what changes can i do to the proxy server to accept these sites for one or more users?(usual changes into one basic proxy server)
Answer Question
| November 18, 2010 1:30 PM
IT Compliance, Proxy Server Configuration, Proxy servers, Server configuration
Updating Signature with image for Outlook versions 1997-2003?
How do I update Signature with image and hyperlink in images for Outlook versions 1997-2003? 1997-2003 Outlook – Step by Step Signature update Open email from me. Save attachment to desktop. Right click zip attachment/ Save as/ Save in: “Desktop”/ SAVE Open “Signature Steps 1997-2003F” folder/ double click “Label World Sig Template” update “Name, [...]
Answer Question
| December 13, 2010 1:29 PM
Outlook, Outlook 2000, Outlook 2003, Outlook Errors, Outlook Signatures
How do I update Signature with image and hyperlink in images for Outlook versions 1997-2003? 1997-2003 Outlook – Step by Step Signature update Open email from me. Save attachment to desktop. Right click zip attachment/ Save as/ Save in: “Desktop”/ SAVE Open “Signature Steps 1997-2003F” folder/ double click “Label World Sig Template” update “Name, [...]
Answer Question
| December 13, 2010 1:29 PM
Outlook, Outlook 2000, Outlook 2003, Outlook Errors, Outlook Signatures
Is there an application for notifying me of harmful emails?
How do I know about phishing / harmful mail without open it? I know there r no of 3rd party SW, (like mail sniffer etc….) but I ask for is there any in-built tool / mechanism…. I am using Firefox and OS is LinuX
Answer Question
| November 30, 2010 12:08 PM
Linux OS, Phishing, Windows Server 2008
How do I know about phishing / harmful mail without open it? I know there r no of 3rd party SW, (like mail sniffer etc….) but I ask for is there any in-built tool / mechanism…. I am using Firefox and OS is LinuX
Answer Question
| November 30, 2010 12:08 PM
Linux OS, Phishing, Windows Server 2008
Career possibilities after IT help desk
i have been selected in ibm gobal for IT help desk Technical associate. so i want to ask that if i go in this job then can i switch to coding department in ibm.i have knowledge of dot net. is there any scope for s/w coding field or not. if i will search jobs in [...]
Answer Question
| March 6, 2012 11:59 AM
.NET, .NET development, Help Desk, IT careers, IT Help Desk, IT professional
i have been selected in ibm gobal for IT help desk Technical associate. so i want to ask that if i go in this job then can i switch to coding department in ibm.i have knowledge of dot net. is there any scope for s/w coding field or not. if i will search jobs in [...]
Answer Question
| March 6, 2012 11:59 AM
.NET, .NET development, Help Desk, IT careers, IT Help Desk, IT professional
How to query Active Directory for all members of a particular group?
Hi All, How to query Active Directory for all members of a particular group lets say all users of the remote desktop Users group Cheers Shane
Answer Question
| November 17, 2010 11:13 AM
Active Directory, Active Directory Administration, Active Directory Groups, Active Directory query, Windows Server 2003, Windows Server 2003 Standard Edition
Hi All, How to query Active Directory for all members of a particular group lets say all users of the remote desktop Users group Cheers Shane
Answer Question
| November 17, 2010 11:13 AM
Active Directory, Active Directory Administration, Active Directory Groups, Active Directory query, Windows Server 2003, Windows Server 2003 Standard Edition
Program copying documents into Lotus Notes database
How to copy documents including doclinks in a notes database to another notes database?
Answer Question
| September 3, 2011 10:19 AM
Domino 8.5, Domino Designer, Lotus Domino 8.5, Lotus Notes Database, LotusScript
How to copy documents including doclinks in a notes database to another notes database?
Answer Question
| September 3, 2011 10:19 AM
Domino 8.5, Domino Designer, Lotus Domino 8.5, Lotus Notes Database, LotusScript
Windows Server 2003 Remote Access
Hi All, I have recently (today) been assigned to give a full technical overview of a new client site, This includes identifing all users that have remote access to all servers. (we are taking over from another IT company) How to I identify all users that have remote access to the servers Thanks for your [...]
Answer Question
| November 23, 2010 10:15 AM
Remote access, Windows Remote Agent, Windows Server 2003, Windows Server Remote Access
Hi All, I have recently (today) been assigned to give a full technical overview of a new client site, This includes identifing all users that have remote access to all servers. (we are taking over from another IT company) How to I identify all users that have remote access to the servers Thanks for your [...]
Answer Question
| November 23, 2010 10:15 AM
Remote access, Windows Remote Agent, Windows Server 2003, Windows Server Remote Access
Markup changes in Word 2003 when attaching to Outlook
Hi, I have a strange problem that I can’t figure out. Using Word 2003 SP3 to edit a document. All the changes have been accepted and the doc is saved on a network share. When it is opened from the share, it looks correct. When it is attached to an email – Outlook 2003 – [...]
Answer Question
| December 13, 2010 8:20 AM
Office 2003, Outlook attachments, Outlook Errors, Windows XP
Hi, I have a strange problem that I can’t figure out. Using Word 2003 SP3 to edit a document. All the changes have been accepted and the doc is saved on a network share. When it is opened from the share, it looks correct. When it is attached to an email – Outlook 2003 – [...]
Answer Question
| December 13, 2010 8:20 AM
Office 2003, Outlook attachments, Outlook Errors, Windows XP
Free LAN messenger
Am in need of free LAN messenger that with remote desktop function. Thank you.
Answer Question
| January 17, 2011 7:04 AM
LAN, LAN Messenger, Local area networks, Network equipment, Network hardware
Am in need of free LAN messenger that with remote desktop function. Thank you.
Answer Question
| January 17, 2011 7:04 AM
LAN, LAN Messenger, Local area networks, Network equipment, Network hardware
