An Email Is Sent When The Database Is Updated..any Help?
in the database, there is some information about the applicant: his name, his email, his status (accepted or rejected)....etc.
the page that is shown to the administrator displays the applicant name and his status, when he changes any of the applicants status, an email is sent to that applicant.
is there any way to do that?
thanks in advance
View Complete Forum Thread with Replies
Related Forum Messages:
SQL To Email When Table Is Updated?
I want to setup a method to get emailed whenever someone adds an item to a particular table. I'm looking at SP's, and DTS's.. but i'm just not sure what the best path is. http://www.sqldev.net/dts/SMTPTask.htm will create a great Custom DTS Email Task.. but then i don't know what to do next... I don't know how to say.. "If a new row is added, then run this DTS"... or if i should schedule the DTS to run every 30 minutes and then somehow query for new "Created" dates. Please Help!
View Replies !
Send Email When DB Table Is Updated
Hi guys, I am new to reporting services. I want to know how to send email whenever there is an update on TABLE_Customer. I have looked through data-driven subscription, but that is just normal schedulling. When i surf the net, i also found UpdateReportExecutionSnapshot. can i just put UpdateReportExecutionSnapshot inside my application so that when on UPDATE function, i will call UpdateReportExecutionSnapshot to trigger the snapshot to be updated? Help... Thank you very much
View Replies !
Linked Reports Not Being Updated When Master Report Is Updated
Since updating to SQL Server 2005 SP2 I've noticed two things about Linked Reports. 1. I do a lot of 'Snapshot' reports. With SP-1 if I updated a master report and made any changes to the Parameter List - it undid all my custom parameter changes on linked versions (restored to the Master Reports Defaults). While this is no longer happening with SP2 - it is still 'unhiding' the parameters. 2. With SP-1 if I added/deleted columns or made other changes to the report structure - the linked reports would pick up on the changes with their next refresh. With SP-2 I'm finding that I have to 'Re-link' the linked report back to the master report before the changes are refreshed. This is very time consuming especially with each report having 8 or more Snapshot reports pre-set up. Am I missing something - or is this a 'bug'... Any help would be appreciated...
View Replies !
Database Is Not Updated
I am trying to insert data to a simple table using SQL express However , I can see the data saved in the DataSet but not in the actual database. If I try to insert the same user again , I got primary key violation ??? Here is the insert function : string SqlConnection = @"Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|QJ.mdf;Integrated Security=True;User Instance=True"; SqlConnection Conn = new SqlConnection(SqlConnection); SqlDataAdapter DataAdapter = new SqlDataAdapter("SELECT * FROM USERS", Conn); SqlCommandBuilder ComandBuilder = new SqlCommandBuilder(DataAdapter); DataAdapter.InsertCommand = ComandBuilder.GetInsertCommand(); DataAdapter.UpdateCommand = ComandBuilder.GetUpdateCommand(); DataSet DS = new DataSet(); DataAdapter.Fill(DS, "USERS"); DataTable DT = DS.Tables["USERS"]; DataRow DR = DT.NewRow(); DR["NAME"] = txtUserName.Text; DR["Password"] = txtPass.Text; DR["Type"] = 1; DT.Rows.Add(DR); DataAdapter.Update(DS,"USERS"); DS.AcceptChanges(); Conn.Close(); I dont know what I have done wrong Please help Thanks very much
View Replies !
MS SQL Database Doesnt Get Updated
Till yesterday every thing was fine....after i installed visual studio...god knws wat happnd dat it was not working, i did everything again but noe using my asp.net forms i am unable to write/edit/update the database, though i can view the same.....can any one suggest was might b d problem. (i have set permissions for IUSER bot Read and Write)
View Replies !
How To Keep Tables Updated That Are Imported From Other Database
Dear All, I am making web application using Asp.net C#(Visual Studio2005). And Sql server 2000 as a back End. Actually I am fetching data from other database(named as retailexcel but in same server). I have wriiten a view (in retailexcel database) to get required data from four table of other database. My problem is when I fetch those data(about 40000 to 50000 record) It taking to much time. I tried catch feature of asp.net2.0. Time reduced but not significantly. So I am trying to import those tables to my database (named Inventory) from that retailexcel. Now problem is every day or two, record of those tables changes. How can I keep update my tables (which are importing from retailexcel) Please suggest me some idea. Thanks
View Replies !
Need Help To Check When Was Database Last Accessed/updated
I am trying to manage a sql server. In this sql server, I have about 200 databases. Is there any way/suggestions to check to see if some of the database has not been accessed/updated for the last month or longer? I am trying to develop a system to remove the database that's no longer needed. Thank you.
View Replies !
Connection Failure To SQL When Database Updated
Hi, I have very little, to zero, IT configuration knowledge and I am hoping that someone is able to help me out. I am currently writing the SQL scripts and developing the reports in the SQL Server Business Intelligence Development Studio, and then deploying the reports to the server for managers to eventually view. Recently the IT section updated the test database (temp) that is connected to SQL Server 2005, with the live database (production), so that the data and database structure were up to date for me to create the reports. When the update was done, the connection to SQL Server failed, and the newly appointed IT person responsible for SQL does not know how to resolve the problem. Up until yesterday I was getting a message that said that the connection has failed and then today I have the following message (she has been trying very hard to get it working): An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset 'Division'. The SELECT permission was denied on the object 'Dim1', database 'payglobal', schema 'dbo'. The reports that were deployed to the server prior to the update are still accessible however I am unable to review any reports I edit within the Development Studio. It has been out of action now for nearly two weeks. Could someone please give me very detailed instructions on where the IT person should look, and what she should do to fix the problem. I will then pass these onto her. Thanks.
View Replies !
How To Find The Last Updated Tables In A Database
Hi, I am trying to create a data dictionary for a huge application which has aroung 300 tables in the database....when i perform any operation in the application some tables are updated.... can you help me to find out how can we find out the last updated tables in the database ??
View Replies !
Database Not Beeing Updated When Debugging PLEASE HELP
Hello I am developing a windows forms app in Visual C# Express edition, it has a database, and when I am debugging, nothing is being done in the database, and I am sure it is nothing to do with the code. Because all I am doing is creating a database with one table, and just dragging the table (with the datagridview) onto a form, then it runs perfectly, but when I add or delete records, and exit the program, it is not reflected on my DB (which is a SQL Server express DB by the way), I was looking everywhere, and all I could find was to change the "copy to output directory" propierty of the DB to "copy if newer" but still it doesn't work, Any ideas why this may be happening?? thanks a lot Andrés
View Replies !
Java Alert When Database Table Updated
Hello Everyone, I am new to connecting to databases through java and in fact have not done much database programming although I am fairly good at SQL. I have used the MS JDBC driver to connect to a MS SQL server database but I want to update my application every time a record is added to the database and or alert the user. From what I have read, i assume that I can create a Trigger in java but how do I get my trigger to call a method / run java code? Thanks for your time and Help Martin.
View Replies !
Save Updated Date When Row Is Updated
Hi,I want to save the last modification date when the row is updated. I have a column called "LastModification" in the table, every time the row is update I want to set the value of this column to the current date. So far all I know is that I need to use a trigger and the GetDate() function, but could any body help me with how to set the value of the column to getdate()? thanks for your help.
View Replies !
DataSet Rows Being Deleted, But After The Update , The Sql Database Is Not Updated. The Delete Rows Still In The Database.
Stepping thru the code with the debugger shows the dataset rows being deleted. After executing the code, and getting to the page presentation. Then I stop the debug and start the page creation process again ( Page_Load ). The database still has the original deleted dataset rows. Adding rows works, then updating works fine, but deleting rows, does not seem to work. The dataset is configured to send the DataSet updates to the database. Use the standard wizard to create the dataSet. cDependChildTA.Fill(cDependChildDs._ClientDependentChild, UserId); rowCountDb = cDependChildDs._ClientDependentChild.Count; for (row = 0; row < rowCountDb; row++) { dr_dependentChild = cDependChildDs._ClientDependentChild.Rows[0]; dr_dependentChild.Delete(); //cDependChildDs._ClientDependentChild.Rows.RemoveAt(0); //cDependChildDs._ClientDependentChild.Rows.Remove(0); /* update the Client Process Table Adapter*/ // cDependChildTA.Update(cDependChildDs._ClientDependentChild); // cDependChildTA.Update(cDependChildDs._ClientDependentChild); } /* zero rows in the DataSet at this point */ /* update the Child Table Adapter */ cDependChildTA.Update(cDependChildDs._ClientDependentChild);
View Replies !
SQL 2000 To SQL 2005 Upgrade Error - Database Down - Updated - Help Appreciated
SQL 2000 to SQL 2005 Upgrade Error - Database Down - Help Appreciated I am upgrading a SQL 2000 standard database server to SQL 2005 standard on a windows 2003 server I am logged in as domain admin and started the upgrade as 'sa' The upgrade stops with the error: Service MSSQLSERVICE can not be started. Verify you have sufficient privilages to start system services. The error code is (17185) The error log shows: 2007-01-04 15:59:38.77 Server Authentication mode is MIXED. 2007-01-04 15:59:38.79 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1) 2007-01-04 15:59:38.79 Server (c) 2005 Microsoft Corporation. 2007-01-04 15:59:38.79 Server All rights reserved. 2007-01-04 15:59:38.79 Server Server process ID is 4188. 2007-01-04 15:59:38.79 Server Logging SQL Server messages in file 'F:SQLDataMSSQLlogERRORLOG'. 2007-01-04 15:59:38.79 Server This instance of SQL Server last reported using a process ID of 2980 at 1/4/2007 3:56:58 PM (local) 1/4/2007 2:56:58 AM (UTC). This is an informational message only; no user action is required. 2007-01-04 15:59:38.79 Server Registry startup parameters: 2007-01-04 15:59:38.79 Server -d F:SQLDataMSSQLdatamaster.mdf 2007-01-04 15:59:38.79 Server -e F:SQLDataMSSQLlogERRORLOG 2007-01-04 15:59:38.79 Server -l F:SQLDataMSSQLdatamastlog.ldf 2007-01-04 15:59:38.79 Server Command Line Startup Parameters: 2007-01-04 15:59:38.79 Server -s MSSQLSERVER 2007-01-04 15:59:38.79 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2007-01-04 15:59:38.79 Server Detected 4 CPUs. This is an informational message; no user action is required. 2007-01-04 15:59:38.83 Server Set AWE Enabled to 1 in the configuration parameters to allow use of more memory. 2007-01-04 15:59:39.02 Server Using the static lock allocation specified in the locks configuration option. Allocated 20000 Lock blocks and 20000 Lock Owner blocks per node. This is an informational message only. No user action is required. 2007-01-04 15:59:39.02 Server Multinode configuration: node 0: CPU mask: 0x0000000a Active CPU mask: 0x0000000a. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2007-01-04 15:59:39.04 Server Multinode configuration: node 1: CPU mask: 0x00000005 Active CPU mask: 0x00000005. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2007-01-04 15:59:39.04 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. 2007-01-04 15:59:41.04 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required. 2007-01-04 15:59:41.04 Server Database Mirroring Transport is disabled in the endpoint configuration. 2007-01-04 15:59:41.04 spid7s Starting up database 'master'. 2007-01-04 15:59:41.05 spid7s 1 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required. 2007-01-04 15:59:41.07 spid7s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required. 2007-01-04 15:59:41.07 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2007-01-04 15:59:41.08 spid7s SQL Trace ID 1 was started by login "sa". 2007-01-04 15:59:41.08 spid7s Starting up database 'mssqlsystemresource'. 2007-01-04 15:59:41.11 spid7s Using 'dbghelp.dll' version '4.0.5' 2007-01-04 15:59:41.11 spid7s ***Stack Dump being sent to F:SQLDataMSSQLLOGSQLDump0035.txt 2007-01-04 15:59:41.11 spid7s SqlDumpExceptionHandler: Process 7 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. 2007-01-04 15:59:41.11 spid7s * ******************************************************************************* 2007-01-04 15:59:41.11 spid7s * 2007-01-04 15:59:41.11 spid7s * BEGIN STACK DUMP: 2007-01-04 15:59:41.11 spid7s * 01/04/07 15:59:41 spid 7 2007-01-04 15:59:41.11 spid7s * 2007-01-04 15:59:41.11 spid7s * 2007-01-04 15:59:41.11 spid7s * Exception Address = 78144D3A Module(MSVCR80+00014D3A) 2007-01-04 15:59:41.11 spid7s * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION 2007-01-04 15:59:41.11 spid7s * Access Violation occurred reading address 0000001E 2007-01-04 15:59:41.11 spid7s * 2007-01-04 15:59:41.11 spid7s * 2007-01-04 15:59:41.11 spid7s * MODULE BASE END SIZE 2007-01-04 15:59:41.11 spid7s * sqlservr 01000000 02BA7FFF 01ba8000 2007-01-04 15:59:41.11 spid7s * ntdll 7C800000 7C8BFFFF 000c0000 2007-01-04 15:59:41.11 spid7s * kernel32 77E40000 77F41FFF 00102000 2007-01-04 15:59:41.11 spid7s * MSVCR80 78130000 781CAFFF 0009b000 2007-01-04 15:59:41.11 spid7s * msvcrt 77BA0000 77BF9FFF 0005a000 2007-01-04 15:59:41.11 spid7s * MSVCP80 7C420000 7C4A6FFF 00087000 2007-01-04 15:59:41.11 spid7s * ADVAPI32 77F50000 77FEBFFF 0009c000 2007-01-04 15:59:41.11 spid7s * RPCRT4 77C50000 77CEEFFF 0009f000 2007-01-04 15:59:41.11 spid7s * USER32 77380000 77411FFF 00092000 2007-01-04 15:59:41.11 spid7s * GDI32 77C00000 77C47FFF 00048000 2007-01-04 15:59:41.11 spid7s * CRYPT32 761B0000 76242FFF 00093000 2007-01-04 15:59:41.11 spid7s * MSASN1 76190000 761A1FFF 00012000 2007-01-04 15:59:41.11 spid7s * Secur32 76F50000 76F62FFF 00013000 2007-01-04 15:59:41.11 spid7s * MSWSOCK 71B20000 71B60FFF 00041000 2007-01-04 15:59:41.11 spid7s * WS2_32 71C00000 71C16FFF 00017000 2007-01-04 15:59:41.11 spid7s * WS2HELP 71BF0000 71BF7FFF 00008000 2007-01-04 15:59:41.11 spid7s * USERENV 76920000 769E3FFF 000c4000 2007-01-04 15:59:41.11 spid7s * opends60 333E0000 333E6FFF 00007000 2007-01-04 15:59:41.11 spid7s * NETAPI32 71C40000 71C97FFF 00058000 2007-01-04 15:59:41.11 spid7s * SHELL32 7C8D0000 7D0D2FFF 00803000 2007-01-04 15:59:41.11 spid7s * SHLWAPI 77DA0000 77DF1FFF 00052000 2007-01-04 15:59:41.11 spid7s * comctl32 77420000 77522FFF 00103000 2007-01-04 15:59:41.11 spid7s * psapi 76B70000 76B7AFFF 0000b000 2007-01-04 15:59:41.11 spid7s * instapi 48060000 48069FFF 0000a000 2007-01-04 15:59:41.11 spid7s * sqlevn70 4F610000 4F7A0FFF 00191000 2007-01-04 15:59:41.11 spid7s * SQLOS 344D0000 344D4FFF 00005000 2007-01-04 15:59:41.11 spid7s * rsaenh 68000000 6802EFFF 0002f000 2007-01-04 15:59:41.11 spid7s * AUTHZ 76C40000 76C53FFF 00014000 2007-01-04 15:59:41.11 spid7s * MSCOREE 61FB0000 61FF4FFF 00045000 2007-01-04 15:59:41.11 spid7s * ole32 77670000 777A3FFF 00134000 2007-01-04 15:59:41.11 spid7s * msv1_0 76C90000 76CB6FFF 00027000 2007-01-04 15:59:41.11 spid7s * iphlpapi 76CF0000 76D09FFF 0001a000 2007-01-04 15:59:41.11 spid7s * kerberos 62220000 62277FFF 00058000 2007-01-04 15:59:41.11 spid7s * cryptdll 766E0000 766EBFFF 0000c000 2007-01-04 15:59:41.11 spid7s * schannel 76750000 76776FFF 00027000 2007-01-04 15:59:41.11 spid7s * COMRES 77010000 770D5FFF 000c6000 2007-01-04 15:59:41.11 spid7s * XOLEHLP 622E0000 622E5FFF 00006000 2007-01-04 15:59:41.11 spid7s * MSDTCPRX 622F0000 62367FFF 00078000 2007-01-04 15:59:41.11 spid7s * msvcp60 780C0000 78120FFF 00061000 2007-01-04 15:59:41.11 spid7s * MTXCLU 62370000 62388FFF 00019000 2007-01-04 15:59:41.11 spid7s * VERSION 77B90000 77B97FFF 00008000 2007-01-04 15:59:41.11 spid7s * WSOCK32 71BB0000 71BB8FFF 00009000 2007-01-04 15:59:41.11 spid7s * OLEAUT32 77D00000 77D8BFFF 0008c000 2007-01-04 15:59:41.11 spid7s * CLUSAPI 62390000 623A1FFF 00012000 2007-01-04 15:59:41.11 spid7s * RESUTILS 623B0000 623C2FFF 00013000 2007-01-04 15:59:41.11 spid7s * DNSAPI 76ED0000 76EF8FFF 00029000 2007-01-04 15:59:41.11 spid7s * winrnr 76F70000 76F76FFF 00007000 2007-01-04 15:59:41.11 spid7s * WLDAP32 76F10000 76F3DFFF 0002e000 2007-01-04 15:59:41.11 spid7s * rasadhlp 76F80000 76F84FFF 00005000 2007-01-04 15:59:41.11 spid7s * security 62800000 62803FFF 00004000 2007-01-04 15:59:41.11 spid7s * dbghelp 671B0000 672C7FFF 00118000 2007-01-04 15:59:41.11 spid7s * 2007-01-04 15:59:41.11 spid7s * Edi: 62FA0040: 62FA0028 671AFFF0 00000000 00000000 00000000 00000000 2007-01-04 15:59:41.11 spid7s * Esi: 0000001E: 2007-01-04 15:59:41.11 spid7s * Eax: 0416C05E: C0400096 C0400416 00000416 000062FA 00000000 00000000 2007-01-04 15:59:41.11 spid7s * Ebx: 0416C040: 0105F270 00002000 00000005 00000000 3368C1E0 00000000 2007-01-04 15:59:41.11 spid7s * Ecx: 0105B010: 458B0046 01F88348 00D3850F 458B0000 89C23B50 0F342444 2007-01-04 15:59:41.11 spid7s * Edx: 00000000: 2007-01-04 15:59:41.11 spid7s * Eip: 78144D3A: 24FFA5F3 144E5495 C78B9078 000003BA 04E98300 E0830C72 2007-01-04 15:59:41.11 spid7s * Ebp: 33D6E770: 33D6E790 01C65B97 62FA0040 0000001E 0416C040 0416C6DC 2007-01-04 15:59:41.11 spid7s * SegCs: 0000001B: 2007-01-04 15:59:41.11 spid7s * EFlags: 00010212: 0020006D 00690046 0065006C 005C0073 006F0043 006D006D 2007-01-04 15:59:41.11 spid7s * Esp: 33D6E768: 62FA0040 33D6E7A4 33D6E790 01C65B97 62FA0040 0000001E 2007-01-04 15:59:41.11 spid7s * SegSs: 00000023: 2007-01-04 15:59:41.11 spid7s * ******************************************************************************* 2007-01-04 15:59:41.11 spid7s * ------------------------------------------------------------------------------- 2007-01-04 15:59:41.11 spid7s * Short Stack Dump 2007-01-04 15:59:41.13 spid7s 78144D3A Module(MSVCR80+00014D3A) 2007-01-04 15:59:41.13 spid7s 01C65B97 Module(sqlservr+00C65B97) 2007-01-04 15:59:41.13 spid7s 01CA43B5 Module(sqlservr+00CA43B5) 2007-01-04 15:59:41.13 spid7s 01CA452E Module(sqlservr+00CA452E) 2007-01-04 15:59:41.13 spid7s 0217D3BD Module(sqlservr+0117D3BD) 2007-01-04 15:59:41.13 spid7s 0217B896 Module(sqlservr+0117B896) 2007-01-04 15:59:41.13 spid7s 0100889F Module(sqlservr+0000889F) 2007-01-04 15:59:41.13 spid7s 010089C5 Module(sqlservr+000089C5) 2007-01-04 15:59:41.13 spid7s 010086E7 Module(sqlservr+000086E7) 2007-01-04 15:59:41.13 spid7s 010D764A Module(sqlservr+000D764A) 2007-01-04 15:59:41.13 spid7s 010D7B71 Module(sqlservr+000D7B71) 2007-01-04 15:59:41.13 spid7s 010D746E Module(sqlservr+000D746E) 2007-01-04 15:59:41.13 spid7s 010D83F0 Module(sqlservr+000D83F0) 2007-01-04 15:59:41.13 spid7s 781329AA Module(MSVCR80+000029AA) 2007-01-04 15:59:41.13 spid7s 78132A36 Module(MSVCR80+00002A36) 2007-01-04 15:59:41.13 spid7s Stack Signature for the dump is 0x2BEDE9E0 2007-01-04 15:59:41.27 spid7s External dump process return code 0x20000001. External dump process returned no errors. 2007-01-04 15:59:41.27 spid7s Error: 17185, Severity: 16, State: 1. 2007-01-04 15:59:41.27 spid7s Unable to update password policy. 2007-01-04 15:59:41.27 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required. Any clues? Cheers Paul
View Replies !
Ensuring Database Is Updated In Mobile Device When Performing Merging
Hi, I am using web service to synchronize data between SQL Server 2005 on a desktop and a SQL Server Mobile Edition on a mobile device. Initially, when i added the data source to my mobile application, my .sdf only has 3 records. I am then supposed to retrieve 97 more records from the desktop server when my mobile application runs. After performing merging, I clicked (on my device emulator) on the .sdf deployed under my mobile application and the query analyzer showed all 100 records. Does this mean my mobile database has been successfully updated with all 100 records? If not, how do I check that? The reason why I am asking this is that the file size of this .sdf with 100 records is still the same as the initial .sdf with only 3 records. How is this possible? Am I missing anything or getting some concepts wrong? Please enlighten. Thanks.
View Replies !
Email As Csv Using Database Mail
Hi everyone, I'm having problems sending my query results as a csv file. Ideally I would be able to send my results from a sql job every night as a csv but I'm having problems doing it. My code is shown below Code Block EXEC msdb.dbo.sp_send_dbmail @profile_name = 'admin' ,@recipients = m@m.com ,@subject = 'Notification Created Today' ,@attach_query_result_as_file = 1 ,@body_format = 'text' ,@query =' select a1.c#, cli, fe, type, dateReq, p, (select convert(varchar(50),convert(money,amount),1)), (select convert(varchar(50),convert(money,vat),1)),(select convert(varchar(50),convert(money,total),1)), cReq from Disb_1 a1 inner join Details on a1.c#=Details.c# where datediff(day,getdate(),dateReq)=0 and dateReq <= getdate()' I've tried many different things and been through the parameters of sp_send_dbmail but I just cant find anything. Also, how can I use column names for those money conversions? At the moment it just says 'no column name' Thanks, Steve
View Replies !
How To Send An Email If A Database Is Locked
Hi all I have heared that there is way to use SQL SMO (SQL Management Objects), or other third party tools running on a management server to send out an email or some kind of notifications if a database is locked. Anyone knows how to do that in SQL Managment 2005. Thanks -Sarah
View Replies !
Sending Email Without Using Database Mail
I have a website that I want to put a contact form on so I can allow users to send emails from it. I have SQL Server as my db but my hosting co. won't allow me to use the Database Mail procedure to send emails (msdb.dbo.sp_send_dbmail I think it's called). I will have to write my own procedure to do it instead. Can anyone point me in the direction of some good resources where I might get some info on how to do this?
View Replies !
Database Email Fails To Notify
I am havig trouble getting database mail to work. I setup IIS on the same box as sql. I setup SMTP with the relay to 127.0.0.0. In sql server, I setup database mail to point to localhost, with no authentication. After the setup, when I test the email (RMB Send test message) it works fine. I created a job that will fail every time. I setup myself as the notify party on the job. When I run the job, it fails. I get no email. The job log has the following error: Message The job failed. The Job was invoked by User xxxxAdministrator. The last step to run was step 1 (test 1). NOTE: Failed to notify 'Dan Jones' via email. I have spent lots of hours trying to make this simple thing work. What is wrong?
View Replies !
Database Design For Email System
Hello to all out there I want to design a database for an Email system. Two options are coming to my mind 1) Whether I will go with a separate table for each user which will contain in each field information like MSGid, recipient, sender, subject, message. 2) or I will maintain the information in a single table for each user. I am not able to comprehend the pros and cons of each solution above. Please help.
View Replies !
Mass Email: Text Body Keeps Looping In Each Email
First off, my server uses CDO, the updated version of CDONTS, to send mail. The script works however, it sends the emails out and keeps looping the message body within the text of the email. here's an example: I added fake users to my table called REALTORS. this was the result of the email sent out: <!-- START EMAIL MAIL OUT --> I am an realtor in Florida and I found you from surfing around Poop Title http://www.poop.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around Haha titleage http://www.hahaha.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around niclipse . com http://www.niclipse.com I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code."I am an realtor in Florida and I found you from surfing around. I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a "vote" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation. If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories: http://www.realestate321.com/resources/resources.asp Once added you will be placed in a "holding bin" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a "robot" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot. Best Regards, Nick McGirr Real Estate Agent http://www.realestate321.com/ "Buying and Selling Homes in the (321) Area Code." <!--[==-- EMAIL MAIL OUT FINISHED -------> ANY IDEAS ON HOW TO SEND EACH EMAIL TO EACH USER INDIVIDUALLY WHILE USING THE INFORMATION LINKED IN THE DATABASE WITHOUT LOOPING OTHER PEOPLE'S DB INFO IN THE SAME EMAIL? Here's the script below.... <title>Email The List</title> <% nickemail = request.form("sender") subject = request.form("subject") If Len(subject) > 0 Then dsn="Provider=SQLOLEDB;Data Source=sql.string.com, etc ect" Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open dsn Set RS = Server.CreateObject("ADODB.Recordset") SQL = "SELECT title, url, email FROM Realtors" RS.open SQL, conn Do While NOT RS.eof strTXT = strTXT & "I am an realtor in Florida and I found you from surfing around" If Len(RS("title")) > 0 Then strTXT = strTXT & vbcrlf & vbcrlf & RS("title") & vbcrlf strTXT = strTXT & RS("url") & vbcrlf & vbcrlf Else strTXT = strTXT & "." & vbcrlf & vbcrlf End If strTXT = strTXT & "I have a real estate site and I am interested in exchanging links with your site. This is benefitial to you and I because each external website that links to your page counts as a ""vote"" for your website. The more links to your site, the better search engine placement you will recieve in google (it's called Google PageRank)...which ultimately means more exposure. It's a win/win situation." &vbcrlf &vbcrlf strTXT = strTXT & "If you are interested, you may add your website to my link directory at the address below (it's all automated). Make sure to pick your correct category and sub-categories:" &vbcrlf strTXT = strTXT & "http://www.realestate321.com/resources/resources.asp" & vbcrlf strTXT = strTXT & "Once added you will be placed in a ""holding bin"" waiting to be approved. Your site will be approved when I find a link on your website to my website. My website will send out a ""robot"" once a month to make sure that my link is still on your site. If it's not understandably, your link will be removed from my page by that robot." & vbcrlf &vbcrlf strTXT = strTXT & "Best Regards," & vbcrlf & vbcrlf strTXT = strTXT & "Nick McGirr" & vbcrlf strTXT = strTXT & "Real Estate Agent" & vbcrlf strTXT = strTXT & "http://www.realestate321.com/" & vbcrlf strTXT = strTXT & """Buying and Selling Homes in the (321) Area Code.""" set objMessage = createobject("cdo.message") set objConfig = createobject("cdo.configuration") ' Setting the SMTP Server Set Flds = objConfig.Fields Flds.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 Flds.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "localhost" Flds.update Set objMessage.Configuration = objConfig objMessage.To = RS("email") objMessage.From = nickemail objMessage.Subject = subject objMessage.TextBody = strTXT 'objMessage.HtmlBody = strHTML objMessage.fields.update objMessage.Send RS.movenext Loop Conn.close set Conn = nothing set objMessage = nothing set objConfig = nothing ShowThanksMsg Else End If ShowForm Sub ShowForm %> <% Session("department")="home" %> <center> <form action=email.asp method=post> <table border=0 cellpadding=4 cellspacing=2> <table> <tr><td><font class=tbody><b>From:</b></font></td><td><input type=text name=sender value="me@me.com"></td></tr> <tr><td><font class=tbody><b>To:</b></font></td><td><font class=tbody>Brevard County Emails</font></td></tr> <tr><td><font class=tbody><b>Subject:</b></font></td><td><input class=inputfield type=text name=subject size=22></td></tr> <tr><td colspan=2><input type=image align=right src=/_images/submit.gif border=0 name=B1></td></tr> </table> </form></center> <!-- <tr><td colspan=2><font class=tbody><b>Comments:</b></font><br><textarea class=inputfield rows=3 maxlength=100 name=message cols=40></textarea></td></tr> --> <% End Sub Sub ShowThanksMsg() response.write "<center><font size=5><b>Message Sent!</b></font><br><br>" response.write "your message has been delivered to all members." End Sub %>
View Replies !
Help Split List Of Email Add Comma For Evry Email
need help split list of email add comma for evry email i have tabe "tblLogin" and in this table i have field emall like this emall ----------------------------------------- aaa@hhhh.mm nnn@hhhh.mm mmm@hhhh.mm need to do ilke this Code Snippet @list_email = (SELECT emall FROM tblLogin) --------------------------i get this -----------------------@list_email=aaa@hhhh.mm ; nnn@hhhh.mm ; mmm@hhhh.mm @recipients = @list_email Code Snippet IF EXISTS( SELECT * FROM [db_all].[dbo].[taliB] ) BEGIN DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX) SET @xml =CAST(( SELECT FirstName AS 'td','', LastName AS 'td','' , Date_born AS 'td','' , Age AS 'td','' , BirthdayToday AS 'td','' , BirthdayThisWeek AS 'td' FROM [Bakra_all].[dbo].[taliB] ORDER BY LastName FOR XML PATH('tr'), ELEMENTS ) AS NVARCHAR(MAX)) SET @body ='<html><H1 align=center>aaaaaaaaaaaaaaaaaaaaaa</H1><body ><table border = 1 align=center dir=rtl> <tr> <td>name</td> <td>fname</td> <td>date</td> <td>age</td> <td>aaaaaaaaa</td> <td>bbbbbbbbbbbbbbb</td> </tr>' SET @body = @body + @xml +'</table></body></html>' EXEC msdb.dbo.sp_send_dbmail @recipients =N'rrr@iec.co.il', @copy_recipients='rrrrr@iec.co.il', @body = @body, @body_format ='HTML', @subject ='ggggggggggggggggggggg', @profile_name ='ilan' END ELSE print 'no email today'
View Replies !
Hoe To Insert Email Address Into The Database Filed
i ve a filed named "Email" of datatype .i ve created this field to insert email address in this field.but when i insert an email address like "bilal@yahoo.com" from a textbox wh is in an ASP.net webpage then in the filed i see this "System.Web.UI.WebControls.TextBox". can u plz tell me how to fix this Regards Ahmed Bilal Jan
View Replies !
Database Mail - Status Sent But Email Never Received
From SQL Management Studion I go to Management > Database Mail and I am trying to send a test email but I never receive anything. I checked my SMTP Mail Server Logs and I saw no entry of my test email. I also I checked my SQL Database Mail Logs and everything seems fine, no errors are reported. The msdb.dbo.sysmail_allitems shows my email status as "sent". So what am I missing? What steps would you recommend for troubleshooting my problem? Thank you, Ric
View Replies !
Sending Queued Email Using Database Mail
We have a ASP.Net 2.0 web application and need to send out emails. We have an EmailQueue table in our database where email gets stored before it is send out. We are looking at the pros and cons of using Database Mail in SQL Server 2005 to send out our emails. Should we use SQL or our web app to send email???Tips, tricks, articles, experiences, opinions are greatly appreciated. Newbie
View Replies !
Database Mail - Send Test Email
i've got a brand new server and just installed SQL 2005. when i try to send a test email, i get the following error message: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2006-11-23T11:49:34). Exception Message: Could not connect to mail server. (No connection could be made because the target machine actively refused it). ) I have checked all items from troubleshoot and eveything is ok...any help ? thanks
View Replies !
How To Insert Employee Record Along With Multiple Email Ids Into The Sql Database?
Hello Everyone, I am bit confused. I am using vwd2005 express,c# and sql express. I have a webform that registers new employee(title,name,age,address,phone,email) and inserts those data into the sqldatabase. The problem is there might exists 'N' number or email ids and phone nos for a single user. for eg: user A might have 3 email address where has user B might have 5 email address. so in that case its not appropriate to create 5 textboxes in the webform and create 5 column like email1,email2,email3,email4,email5 in the database for both users.. i hope your getting the point. I tried to create a separate table for emails and phone. But i am new to relational database. So if i need to use Relational database then could anyone help me here to :- 1.create a table structure here.(what would be the structure of tbl_employee, tbl_email and tbl_phone) 2.How to write insert query if i am using RD here? plz help explaining the concept with a simple running example. Thanks in advance. Jack.
View Replies !
Generate Reports From Database Information And Email It Weekly
Hello there, Im alittle stuck what im trying to find out is: MS SQL 2000 1. How to Generate Reports from selected Database information 2. then email that report weekly. Ive heard about Visual Studio .NET 2003: Business Intelligence Projects but is there away to create the reports directly in Enterprise manager? any pointers would be great
View Replies !
Question Of Feasibility To Send Email Each Time The Database Size Is Inscreased.
Hi, When we create a DB, we can use FILEGROWTH to specify a growth_increment which is the amount of space added to the file each time new space is needed. CREATE DATABASE database_name ... FILEGROWTH = growth_increment http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_1up1.asp Now, is it possible to send email each time the database size is inscreased? and how?
View Replies !
How To Automated Send Email To Inform The Status Number Of Data In Database Using Stored Procedures?
Hi , I'm just new in this SQL 2005, and I do not reallly sure the subject is right or not but as example in this link below http://msdn2.microsoft.com/en-us/library/ms190307.aspx I want updated to few of person of any changes in database just by sending to their emails in every 2 hours as an example. I go through the example given but I do not know the step how to run stored procedures. The Information that I want to give to them is like as: Date From : 23/02/2008 Date To: 24/02/2008 Number of user : 3 My draft table is like this Sequence_No Submitted_Dt Name -------------------- ------------------- ------------------------ 1 2/21/2008 4:16:45 PM John 2 2/22/2008 4:16:45 PM Dean 3 2/23/2008 4:16:45 PM Rick 4 2/24/2008 4:16:45 PM Van thanks to all of your corcern to help me Regards;
View Replies !
Help Send An Personal Email From Database Mail On Row Update-stored PROCEDURE Multi Update
hi need help how to send an email from database mail on row update from stored PROCEDURE multi update but i need to send a personal email evry employee get an email on row update like send one after one email i use FUNCTION i get on this forum to use split from multi update how to loop for evry update send an single eamil to evry employee ID send one email i update like this Code Snippet : DECLARE @id nvarchar(1000) set @id= '16703, 16704, 16757, 16924, 17041, 17077, 17084, 17103, 17129, 17134, 17186, 17190, 17203, 17205, 17289, 17294, 17295, 17296, 17309, 17316, 17317, 17322, 17325, 17337, 17338, 17339, 17348, 17349, 17350, 17357, 17360, 17361, 17362, 17366, 17367, 17370, 17372, 17373, 17374, 17377, 17380, 17382, 17383, 17385, 17386, 17391, 17392, 17393, 17394, 17395, 17396, 17397, 17398, 17400, 17401, 17402, 17407, 17408, 17409, 17410, 17411, 17412, 17413, 17414, 17415, 17417, 17418, 17419, 17420, 17422, 17423, 17424, 17425, 17426, 17427, 17428, 17430, 17431, 17432, 17442, 17443, 17444, 17447, 17448, 17449, 17450, 17451' UPDATE s SET fld5 = 2 FROM Snha s JOIN dbo.udf_SplitList(@id, ',') split ON split.value = s.na WHERE fld5 = 3 now how to send an EMAIL for evry ROW update but "personal email" to the employee Code Snippet DECLARE @xml NVARCHAR(MAX)DECLARE @body NVARCHAR(MAX) SET @xml =CAST(( SELECT FirstName AS 'td','', LastName AS 'td','' , SET @body = @body + @xml +'</table></body></html>' EXEC msdb.dbo.sp_send_dbmail @recipients ='' @copy_recipients='www@iec.com', @body = @body, @body_format ='HTML', @subject ='test', @profile_name ='bob' END ELSE print 'no email today' TNX
View Replies !
How To Tell If A Row Is Updated
Hi Im doing a simple update in my SP: update users set Name = @Name where id=@userID and password=@password i want to know if a row gets updated. for example if the userID and password dont match then the row will not get updated.so i want some way to tell if a row has been updated. how do i do this?thanks
View Replies !
Updated
Thanks i just re tested again i think i had the database selected on the wrong one and was getting incorrect results. Seems to be working just as i thought. Snapshot got record 1 here then if udpate to 2 then this does not update the 1 to 2 Cheers
View Replies !
SQL Help: Get The Record I Just Updated
Hi - apologies if this is not the right forum for this - I've searched a bit and this seems to be the best fit. I have the following problem: I want to update records in a table that fit certain criteria. The way the insert logic works make sure that there will always be only one record that fits the criteria and I'd like to get the ID value of that record once the update went through. So here is what I tried: 1 UPDATE Timeslot 2 SET StartTime = @StartTime, EndTime = @EndTime 3 WHERE (ProfessionalID = @ProfessionalID) AND (ProviderLocationID = @ProviderLocationID) AND (RequestID IS NULL) AND (StartTime > @StartTime) AND 4 (EndTime < @EndTime); 5 SELECT SCOPE_IDENTITY() My hope was that the select scope_identity would return the Timeslot ID of the row that was affected, but it doesn't. How do I get that row? Thanks!!! Oliver
View Replies !
Query Cannot Be Updated Because The FROM
Hi everybody, I am a total noob conserning ASP, but I am willing to learn We have a sql2005 SRV(hosted by our ISP, so limited access) and a ASP based forum (WEB WIZ) When I try to login I get this error: Support Error Code:- err_SQLServer_loginUser()_update_USR_CodeFile Name:- functions_login.aspError details:-Microsoft OLE DB Provider for ODBC DriversQuery cannot be updated because the FROM clause is not a single simple table name.Can somebody tell me whats wrong? Thanx in advance. Gerry de Bruijn!
View Replies !
Get Last Updated Records?
If I update a recordset a group of records using dynamic SQL where I update the TOP n records, is it possible to get the set of records that was updated? CREATE PROCEDURE usp_Structural_ScheduleComponent @cProject char(7), @cComponentID char(10), @iPour int, @iQuantity int, @iAvailable int OUTPUT, @dtCast datetime OUTPUT AS SET @dtCast = convert(char(10), getdate(), 120) DECLARE @cSql varchar(500) SET @cSql = 'UPDATE tbStructuralComponentSchedule SET PourNumber = ' + CAST (@iPour AS VARCHAR) + ', ScheduledDate = ' + '''' + CAST(@dtCast AS VARCHAR) + '''' + ' WHERE EntryID IN ( SELECT TOP ' + CAST(@iQuantity AS VARCHAR) + ' FROM tbStructuralComponentSchedule ' + ' WHERE fkProjectNumber = ' + '''' + @cProject + '''' + ' AND fkComponentID = ' + '''' + @cComponentID + '''' + ' AND IssueDate IS NOT NULL' + ' AND ScheduledDate IS NULL' + ' ORDER BY EntryID DESC)' EXEC(@cSql) IF(@@ERROR <> 0 OR @@ROWCOUNT < = 0) RAISERROR('Failed to add components to pour!',16,1) SELECT @iAvailable = SUM(CASE WHEN IssueDate IS NOT NULL AND ScheduledDate IS NULL THEN 1 ELSE 0 END) FROM tbStructuralComponentSchedule WHERE fkProjectNumber = @cProject AND fkComponentID = @cComponentID GO -- Is there a way to return the recordset that were modified in the update? Mike B
View Replies !
Index Not Updated.
Hi, We run SQL SERVER 2000 on win2000 I've a question regarding Index on a table. I've a table (1 milj rows) with a extra index ZINDEX1. Now lets say I insert 1000 rows in that table. Now what will happend if I search on these NEW rows in my table. The Index is not updated. //Martin
View Replies !
Log All Updated Tables
We have a third party process that runs and updated several SQL tables. Is there any way to find out what tables are being updated and store it in another table?
View Replies !
When Was Db Object Last Updated?
Guys, Is there a way to find out when a certain DB object (e.g. Stored procedure) was last modified? SYSOBJECTS table contains crdate and refdate fields. None of these, however, appear to tell me when when the object was last updated. Any suggestions? Thanks a lot
View Replies !
|
TRACKER
