About xumi

xumi - who has written 27463 posts on it.rss24h.com.

Email This Author | xumi's RSS

Post by xumi

How do i restrict database mail not to send out of specific domain

Question:
Hi,
We are having our QA system and production too. As a part of QA and requirement of system, we do require to test mail sending functionality from QA. Its procedure written on several table’s trigger.
How can i restrict my mails not to go outside my domain. i.e. if my domain is @xyz.com, how can i [...]

from Oracle to sql server 2008

Question:
Hello. Know of any tool that allows me to spend an Oracle 10g database to sql server 2008? as a backup restore
Solution:
the databases aren’t fully compatible in terms of types or procedural code, let alone underlying structures.  So “backup/restore” isn’t possible between the two products.
You can use linked tables or heterogeneous services or gateway products [...]

sql convert date

Question:
I’m having trouble with the following WHERE clause;
WHERE CONVERT(varchar, SessionDateTime, 101) = CONVERT(varchar, #tmdate2#, 101)
The value of tmdate2 is “04/23/2010″ and the value of SessionDateTime is “4/23/2010 8:37:31″.
I generate tmdate2 with the following;
<cfset tmdate2=”#dateformat(DateOfCall,”mm/dd/yyyy hh:mm:ss”)#”>
I just added the time to the end of it and get the following error;
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL [...]

SBS 2003 Backup Problem Stoping and starting Exchange

Question:
I am backing up a 2003 SBS Server. It was backing up without problems until a couple of days ago. I am using Acronis Echo SBS backup. The error I am getting is  “E000400007: Failed to Backup File or folder ‘D:\Program Files\Exchsrvr\MDBDATA\E00.log’.This file or folder is locked by the following process: C:\Program Files\Exchsrvr\bin\store.exe.
There is a [...]

How to Recover Overwritten Word Documents?

Question:
How to recover an accidentally overwritten document in MS Word? I saved a file after making changes instead of changing the file name. Is there an easy way to recover the file I just overwrote?
Solution:
Do you take backups? or have shadow copies running?
If not then you will not be able to recover it.

SSIS error – Argument “SMTP” for option “connection” is not valid

Question:
I have built an SSIS package that works just fine in BIDS.  I would like to schedule the package in SQL Server Agent.  After I set it up I get the following error:
Argument “SMTP” for option “connection” is not valid
I also ran it using using command line DTExec and I get the same error.  Not [...]

Is there a utility that can query a DVD-RW for its firmware revision?

Question:
See title
Solution:
Hello,
“lshal” provides that info
Scroll through the lshal output to find the entry for your drive. This is how it looks here:
udi = ‘/org/freedesktop/Hal/devices/storage_model_DVD_RW_AD_7170S’
block.device = ‘/dev/sr0′  (string)
block.is_volume = false  (bool)
block.major = 11  (0xb)  (int)
block.minor = 0  (0×0)  (int)
block.storage_device = ‘/org/freedesktop/Hal/devices/storage_model_DVD_RW_AD_7170S’  (string)
….
storage.cdrom.write_speeds = {‘8467′, ‘7056′, ‘5645′, ‘4234′, ‘2822′, ‘1411′} (string list)
storage.drive_type = ‘cdrom’  (string)
storage.firmware_version [...]

Lotus connector for outlook 2007

Question:
if these Lotus connector for outlook 2007 available. If not any other solution.
Solution:
Can you pls let me know what do you mean by connector?
Do you want Outlook users to see domino emails (which users Domino as mail server)? Or MS-Exchane emails to be viewed in Lotus Notes?
Check these links for case 1:
http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/Q_20726851.html?sfQueryTermInfo=1+lotu+note+outlook
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/Lotus_SmartSuite/Lotus_Notes/Q_22399948.html?sfQueryTermInfo=1+lotu+note+outlook
For case 2;
Previous links [...]

ASP.NET Required Field Validators

Question:
Hello,
I’m using a asp.net required field validators for various fields in the form and I’m using a master page . I have a search bar above form. I’m unable to use the search form due to the require field validators.
When ever I type search I’m asked for the required fields. How do I make sure [...]

reporting services

Question:
I have a report in reporting services (. Rdl). My question is: how I can call the report from an application in asp.net (eg from a button)
Solution:
http://www.dotnetheaven.com/UploadFile/ursbgiri/106012007065515AM/1.aspx