how to send email from sql server 2008 stored procedure

functionexec sp_configure ' show advanced options ', 1Reconfigureexec sp_configure ' Ad Hoc distributed Queries ', 1Reconfigure--Allow ace.oledb.12 to be used in the processEXEC master.dbo.sp_MSset_oledb_prop n ' microsoft.ace.oledb.12.0 ', n ' allowinprocess ', 1--Allow dynamic parametersEXEC master.dbo.sp_MSset_oledb_prop n ' microsoft.ace.oledb.12.0 ', n ' dynamicparameters ', 1--Import temporary tablesEXEC (' INSERT into Jihua (id,[lot number],right (' ' + @filepath + ', charindex (' ' \ ',

In SQL Server 2008, in order to protect the security of the database, the need for different users to open different access user, then how to simply control the user's permissions? Below we will create a read-only user, for everyone to learn to use. SQL Server

Previous versions of SQL Server did not do a good job of tracking object dependencies. The reason is that all object dependencies are tracked by object IDs, which means that the object must be present at the outset. However, tracking objects by object name, SQL Server 2008 g

Effect: send emails regularly to remind them that they have not logged on for X days. (X is defined by myself) implementation principle: the data used by SQL Server jobs, database emails, and stored procedures is used: the user table is used, and the table name is tb_Admin. The following shows the main fields to be used: field name interpretation Id Primary Key R

permissions, but there may not be a corresponding login or the user associated with the login may not be the same user. This situation is known as "orphaned users". The logon issue cannot be resolved either by creating a new login or by granting the user permission to the corresponding database for a login with the same name, because SQL Server reported "error 15023: User or role already exists in the curr

of type int: I, J, K and simple logical operation of these variables, in management Studio as long as easy to press the F11 key, you can debug the above code block.Then click F11 Debug or F10 Step-by-step debugging code. Do you think this dubug scene is similar to vs?Iv. support for complex stored procedure nesting debug:You may wonder if, in a large system, code such as stored procedure nesting stored pro

Label:1. Manage Database Mail create messages for SMTP servers, such as messages for [email protected] , Server smtp.126.com2. Start "SQL Server Agent", create a new operator in the operator, such as ABC_AM, and provide e-mail address, such as:[email protected]3. Configure t

filegroup to next used4 、--Modifying a partition functionNeed to solve the problem, thank you! Support (0) objection (0)Reply Reference#9楼2016-04-26 16:48 dr_twilightAutomated partitioning scheme jobDECLARE @maxValue INT,@secondMaxValue INT,@differ INT,@fileGroupName VARCHAR (200),@fileNamePath VARCHAR (200),@fileName VARCHAR (200),@sql NVARCHAR (1000)SET @fileGroupName = ' FileGroup ' +replace (replace (CONVERT (varchar, GETDATE (), 120), '-', '), '

Tags: SQL Server1, the thing log is divided into small virtual log VLF, it has a number called LSN2, the checkpoint by default every 1 minutes to save memory data, the failure point occurs after the log redo, the thing according to the submission or not roll forward or rollback.3, in the overall main menu bar of the database to select the properties to set the data file and log file storage location, after the set up to restart the service, you can ri

this policy, and if the policy is violated, roll back the operation. To achieve the effect of the enforcement policy. Update-time record (on Change-log only): SQL Server 2008 uses the event notification mechanism to enforce the compliance of a check operation when an action is subscribed to a target on this policy, and send