Forum Replies Created

Viewing 6 posts - 76 through 82 (of 82 total)

  • RE: Emailing in HTML

    At present, that code will just output HTML table rows and cells.

    You need to concatenate the opening and closing table tags along with any column headings inside TH tags....

  • RE: Adding a .NET Reference to a Database Project

    What I have done in my .net app is script out sql jobs from a SQL2000 server. The code changes all calls to ISQL to SQLCommand, change calls to...

  • RE: Adding a .NET Reference to a Database Project

    Thanks for the clarification. So is there any other way to properly script out an MSDB job to a text .sql file? I don't want to have to...

  • RE: The OLE DB connection manager could not be edited.

    If anyone else encounters this, I have found that is caused but a corrupt MDAC installation. Instructions to fix can be found here:

  • RE: SMO Enumerator

    Frank Bazan (4/17/2008)


    Populate a recordset with a query against sys.databases.

    [font="Courier New"]SELECT [name]

    FROM SYS.DATABASES

    WHERE state_desc = 'ONLINE'[/font]

    Then use a for each ADO enumerator to loop through the recordset.

    Thanks, that was...

  • RE: SMO Enumerator

    I have tried setting the Max Number of Errors on the Dataflow task which sits inside the For Each loop but the package still fails.

    Is there anyway to...

Viewing 6 posts - 76 through 82 (of 82 total)