Changing database mail account SMTP servers
This will generate a script that drops and recreates existing db mail accounts and change the smpt server.
2013-07-08 (first published: 2013-06-19)
689 reads
This will generate a script that drops and recreates existing db mail accounts and change the smpt server.
2013-07-08 (first published: 2013-06-19)
689 reads
This SSIS package generates XML invoice documents from data stored in SQL Server, then FTPs and/or Emails them to clients.
2012-04-04
6,722 reads
This article demonstrates basic C# code that will enable SSIS package developers to write useful custom SSIS script tasks.
2011-12-12
20,880 reads
This article demonstrates basic VB.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.
2011-11-25
13,872 reads
If you would like to send email from SQL Server, use this CDO method and store proceudre.
2009-08-13 (first published: 2009-07-29)
3,456 reads
This and many more informations on dynamic sql you can find here:http://www.sommarskog.se/dynamic_sql.html
2004-11-25
Use sp_procoption to set stored procedure to autoexection runs every time SQL Server is started. In the stored procedure, run alter database command to set database in full recovery mode.
2004-02-12
sorry, quote: There are some nice comments, in addition to yours, in a paper called ...'The 1995 SQL Reunion'. Btw, the only source I found where it is mentioned why SEQUEL/2 had to be renamed. Frank Wenn Englisch zu schwierig ist? http://www.insidesql.de
2003-09-12
1 reads
Rahul, I think as long as you have sysadm rights, you can perform anything in the database. And user "SA" can do anything in the database.
2003-08-25
1 reads
That was the intent. I want to tell the user that the record was successfully updated, but it does not seem to happen that way.
2003-08-25
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers