sql
-
Search Microsoft SQL Server Jobs
Have you ever needed to find a job in Microsoft SQL server and it took forever because there were so many defined jobs that you had to look at one by one? Next time run a query. ;) In the "System Databases" database you will find a database named "msdb" that contains several tables. If you...- Kevin
- Resource
- sql
- Category: Guides & Tutorials
-
Solve sp_OAMethod AddAttachment Error
Well, this one was driving me nuts today at work so in case anybody else out there encounters it, here's the solution. I was working on a sproc to add attachments to an email using CDO in SQL Server 2008. The command for this was easy enough. EXEC sp_OAMethod @iMsg, 'AddAttachment', NULL...- Kevin
- Resource
- sql stored procedure
- Category: Guides & Tutorials
-
SQL Solve sp_OAMethod AddAttachment Error
Well, this one was driving me nuts today at work so in case anybody else out there encounters it, here's the solution. I was working on a sproc to add attachments to an email using CDO in SQL Server 2008. The command for this was easy enough. EXEC sp_OAMethod @iMsg, 'AddAttachment', NULL...- Kevin
- Thread
- sql stored procedure
- Replies: 2
- Forum: Resources & Tutorials
-
SQL Search Microsoft SQL Server Jobs
Have you ever needed to find a job in Microsoft SQL server and it took forever because there were so many defined jobs that you had to look at one by one? Next time run a query. ;) In the "System Databases" database you will find a database named "msdb" that contains several tables. If you...- Kevin
- Thread
- sql
- Replies: 0
- Forum: Resources & Tutorials