Viewing 15 posts - 1 through 15 (of 27 total)
I had the same problem, I couldn't change the collation and I've learned to do
select * from tableA join tableB on tableA.fieldA collate [....] = tableB.fieldB
or
select * from tableA where...
May 20, 2008 at 1:48 am
I created a distribution list and used that email. As far as I know just one email address.
April 25, 2008 at 3:13 pm
Unfortunately SQL logins, I cannot use Windows login because of the policy of my company. I ended up giving to the user "sysadmin" privileges and it worked. Of course I...
April 19, 2008 at 10:17 am
I specified the mapping, so it should work
userA on dbSQL---> userB on dbOracle
This is my understanding... userA does not exists on dbOracle, but the mapping exists.
Thanks
April 7, 2008 at 2:28 pm
You can use xp_sendmail (available also on 2000)
but you need to configure a MAPI profile
See here http://msdn2.microsoft.com/en-us/library/ms189505.aspx
I hope this helps!
April 1, 2008 at 2:12 pm
I've already tried both (table and file). I really think the issue is related to oracle. I read a lot of post regarding issues when a source is oracle. Thanks...
March 23, 2008 at 8:49 pm
Thank you so much it worked!
Claudia
March 19, 2008 at 9:54 am
Hi John, and thanks for your answer.
I've already enabled the command shell, it runs fine for others job that doesn't involve an FTP.
How can I find out the win account...
March 15, 2008 at 12:50 am
Hi, can you be more specific, I have the same problem. Which is this new XP that doesn't require autentication?
Thanks,
January 30, 2008 at 5:44 pm
How do they decide what to see and what to hide?
You could use a temporary table for this..
On your example let say that I don't want to see city....
Select *...
June 11, 2007 at 5:01 pm
This is one:
CREATE PROCEDURE dbo.sp_test1
@MCI as varchar(12),
@Value as varchar (10),
@FIELDNAME as varchar(50)
AS
exec ('update customer set '+@FIELDNAME +' = '''+@Value +''' where master_customer_id='''+@MCI +'''')
GO
exec sp_test1 @MCI='000000100100', @Value='Yes', @FIELDNAME...
June 11, 2007 at 4:55 pm
Thank you for your advise. At least it is not only my impression (it is too complex)!
June 11, 2007 at 4:46 pm
Not sure if I am not able to implement the script suggested by Jeremy but it doesn't work properly. I'll tryaccessmonster.com thanks.
December 6, 2006 at 3:34 pm
Thank you for all your answer.
I cannot move to vb.net, this is a small piece of a HUGE program.... and it has SQL Server as back end, but this doesn't...
December 6, 2006 at 10:51 am
Try this way
Set @messageToSend= '<HTML><H1>this is some content for the body part object</H1></HTML>'
Execute @rc=master.dbo.xp_smtp_sendmail
@server = 'SERVERNAME',
@from = 'bhushan683@gmail.com',
@to = 'bhushan683@gmail.com',
@subject...
October 27, 2006 at 11:12 am
Viewing 15 posts - 1 through 15 (of 27 total)