Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: How to copy All data from sp_helpdb to some other table

    To save stored procedure values you can do something as follows:

    CREATE TABLE #MYTEST(xNAME sysname, xDB_SIZE nvarchar(13), xOWNER SYSNAME, xDBID smallint, xCREATED nvarchar(11), xStatus nvarchar(600), xCOMPATIBILITY_LEVEL TINYINT)

    INSERT INTO #MYTEST(xNAME, xDB_SIZE, xOWNER,...

  • RE: SSIS Commit problem

    Hi again,

    I just noticed that its an oracle issue, where auto commit is not done when doing a manual update or so.

    This being said, the SQL task is successfully updating...

Viewing 2 posts - 1 through 2 (of 2 total)