We will be migrating SQL Server from 2000 to 2005 in near future,we have created the Jobs for automatic emails in sql server 2000.important points regarding data migration with jobs?
View 3 RepliesI am developing ecommerce website and i have some page where to send automatic mails , How to assign mail templates with particular module with mail templates , how to use  dynamic email templates for sending automatic emails in asp.net ?
View 1 RepliesI know it is possible to do this using windows service but I am using a shared hosting and so that choice is out. Also the ms sql stored pocedure is also not ideal for my problem as i dont have administrative previlages in the database. My requirement is to send a url or the data in that particular url to the administrator to notify him about the expiry of registration of the users in the system. I need to do this once in every month and I need to do this frm asp.net.
View 5 RepliesI want to sent automatic mails to my clients to that date, on which they selected reminder. I went through article for window service and using sql server, but I didn't understand its working, any alternate option, is it possible to use google calendar in my website and when calendar date is set to some event then google alert set automatically to client email, and google alert sent to that email automatically...
View 1 RepliesI make a Data Base in SQL Server 2005 in Windows XP Operating System. Now i want to Move in Windows 7. When i Attach that Data Base In Windows 7 SQL Server 2005 then Error Comes that is
Operating system error 5 (Access is Denide)..
I've developed a web app in Visual Studio 2008 using ASP.NET which connects to an Oracle database and a separate SQL Server 2005 database in the same application.
I want to convert this application to use SQL Server only. I have copied the Oracle tables that I need to SQL Server and am in the process of converting the SQL queries from Oracle format to SQL Server format.
I have also modified all the Connection Strings in web.config to point to the SQL Server database now and not the Oracle one.
However I have come across a problem. The TableAdapters are configured to use the OracleClient in the declarations code behind the scenes, i.e. it is "hard coded". But this causes problems of course while modifying/saving queries, because I don't want any trace of Oracle in my new web app.
The only thing I can think of is to delete all my TableAdapters and re-create them all.
I need to transfer SQL Server databse to Oracle database.
View 2 RepliesI been googling a bit and not having a clear picture on this. I have a few database now sitting duck in Express and we planning to migrate to 2005 or 2008 enterprise version. Currently, all the sensitive and important data are stored in the Express. We wanna do the migration but we do not want to impact a single column in a table. E.g. some numbers becomes different format like 234E whatever watever. Is there any good tools out there to do the job with the least efforts ?
View 2 Repliesi want to generate a unique number into a textbox from sql server table everytime when i click a submit or save button ...
View 3 RepliesI have mailboxes in the exchange server and i need to copy the mailboxes data from the exchange server and place it to the other exchange server using c#.Is it possible to access the exchange server using c#.
View 1 RepliesI am trying to "refresh" the license number for the SSMA 2008, but each time I click on the "register for License number" link
I log into windows live then the screen just sits there with the revolving circle dots graphic - what can I do?
I have one asp.net 2.0 application with MS Sql 2005 database.. As i deploy this database with client Machine.. now what i need is i need to take a backup of MS Sql 2004 database.. so is that any free tool is available which take daily backup...
View 16 RepliesI have developed an enterprise application in ASP.NET that sends emails using localhost SMTP server on the same box as the IIS web server for the ASP.NET app.
So right now any email sent from this ASP.NET app would hit internet firewall of the enterprise and then be directed to the right destination email address.
I was hoping to not hit the internet firewall of the enterprise, but hit the Exchange Server of the enterprise.
So the situation I am aiming for is: ASP.NET APP ===> Localhost SMTP SERVER ===>EXCHANGE SEVER 2003 ===>SEND OUT THE EMAIL
rather than ASP.NET APP ===> Localhost SMTP SERVER ===>SEND OUT THE EMAIL
So I still want to use the same mail configuration in my ASP.NET app of localhost as SMTP server, but just want the email to first go through Exchange Server before being sent out.
dataContext.saveSend(true);
SendEmailsToAllMembers();
I have the code above, if after half of the emails were sent out, there is a error in smtp, then how can I avoid resending emails or missing emails in this cases ?
Actually I want to send an automatic mail through sql
server 2005 at 17:00(hr) daily please guide me in detail
I'm using the following code
Declare @MailID varchar(60)
Declare @mailbody varchar(200)
Declare @MailSendTime datetime
set @MailSendTime='2011-02-07 14:15:07.700'
[code]...
Error is :Msg 14636, Level 16, State 1, Procedure sp_send_dbmail, Line 94
No global profile is configured. Specify a profile name in the @profile_name parameter.
I need to write a stored procedure to schedule a job that will send automatic email to customers based on some condition as follows:
1. I have two tables. One table is table1 like the following:
Name Date1 Date2 Date3 Rahim, Khan 29'10 30'11 25'08 Karim,Abedin 12'10 28'11 26'09 Fahad, Alam 26'10 12'11 25'10 Another Table is table 2 like the following:
Name Email Rahim,Khan rahim@yahoo.com Karim,Abedin karim@yahoo.com Fahad, Alam falam@yahoo.com In table 1 the date format is in format where 30'11 mean work week is 30 and 11 means last two digits of the year.
2. Now , I need to write a stored procedure that will check :
a) What is current work week and current year?
b) It will then determine the difference between the current work week (now 37) and work week mentioned in date (Date1, Date2 and Date3) columns from table1 and if for current year(it's 2010) at least one difference in each row is>=8 then it should send an automatic email to the corresponding email address of Name column using the relation between Table1 and table2. For example: For first record in Table1 the three difference is: 37-29=8, 37-30=7 and 37-25=12. There are two differences >=8, but only first difference is for year 2010 and third one is not for current year. But, since at least one difference in this row satisfies condition (That means >=8 for year 2010)hence email message should be sent to the address rahim@yahoo.com using relation of table1 and table2.
I know how to set a schedule job in SQL mail but I need this stored procedure to run this job on daily basis.
i have a asp.net application which is currently working in LAN / intranet my is the development server in which i have all the files , images and other functionalities its confiured thr' IIS so that other clinets in the INTRANET can access the aoolication. i have a email module which works fine . using this e mil modules i sent emails conating images, hyperlinks text etc to the gmail, yahoo etc ids and accessed it from my debelopment system asweel from other systems in the network.all of them work fine but if i sent it to a person who access the email outside the INTRANET the images nor the hyperlinks are displayed.only the text matter is displayed.
View 26 RepliesIn below link
http://www.asp.net/ajaxlibrary/act_faq.ashx it has been mentioned that "Also, the ToolkitScriptManager performs automatic script combining on the server."
I am able to get a token with Windows Live Delegate Authentication samples provided by Microsoft.
Now I want to access emails (New, Read, Unread etc) from live account. How can I achieve it with the help of Windows Live Delegate Authentication? Are there any examples for the same?
The Samples given by Microsoft are not related to emails.
I'm developing a system that should send emails to clients on specified dates. i don't have much idea about it.i have created a simple windows service .how to get the email address from the sql server database and attach to windows service?
View 2 Repliesiam using asp.net 2.0 with c#.net.
in my application when client completes its shopping email will goes to user this works fine when there is internet connection is working fine, if there is some problem in internet connection if one mail stops then all the mails will be stopped even now internet works fine,
how to resend the emails using smtp server, is there any option to resend the emails automatically when internet works fine.
I want to extract emails that are currently being sent to an exchange Server. I want to extract the emails and then take some actions based on their content.
View 7 RepliesI am looking to connect to our mail server and process attachment. The attachments are plain text files. Any DLL / API for this. We have sun communication express.
View 3 RepliesI want to read emails from exchange server 2007 using C# in my webform.
View 1 Repliesmy company is hosting a reception for current / prospective clients, we have a list of invitees in a SQL database, using the following columns (ID, Name, Email, Company, Response). ID is a UID and Response is Int, others are varchar. by default, Response is '0'i want to generate an email that will invite each user in the database to the reception, and provide a link to pages on our website that will update the Response field to1 (attending) or 2 (not attending).
View 5 Replies