sql

  1. Kevin

    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...
  2. Kevin

    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...
  3. Kevin

    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...
  4. Kevin

    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...
Back
Top