in SQL2K, the full backup does not clean transaction log. So the time between full backup and transaction backup is irrelevant.

Only transaction log backup clean out transaction log.

Add more transaction...

Check on article PSS ID Number: 833305.

I doubt you can do that.

You probably need to fix it in source.

Save the following to multiplesql.wsf.

Get syntax by multiplesql.wsf /?

<package>

<job id="multiplesql">

 <runtime>

  <named

    name="SQLFolder"

    helpstring="sql files folder"

    type="string"

    required="true"

  />

  <named

    name="S"

    helpstring="server"

    type="string"

    required="true"

  />

  <named

    name="U"

    helpstring="login id"

    type="string"

    required="true"

 ...

I had project with similar request about two years ago. The solution was to use WshShell.Exec method to run sql job, check Status, CDO mail if excess a limitation.

check if the group has Deny access setting in Authentication.

EM/Security/Logins, in the details panel, right-click the group and click properties.

sysobjects table has parent_obj column should help you.

Batch job contains multiple osql command lines from the same input inputfile (sql statement or stored procedure) should do the job.

Test code:

create table (id int, col1 char(1), col2 char(2))

insert select 1, 'A', 'kk'

insert select 1, 'B', 'jj'

insert select 1, 'C', 'bb'

insert select 2, 'D', 'qq'

insert...

select * from

(Select ColumnA, Count(ColumnB) as ColB From MyTable Where ColumnA='Something' Group by ColumnA Sort By ColumnA) a

My mistake, it is scalar function.

In the old day, one can DBCC MEMUSAGE. You have to find the replacement.

One of ways to do it:

create scale function (fn_list(budgetid)) list parent, chidren in csv format by passing budgetid.

select budgetid, budgetdesc, fn_list(budgetid) as budgeholdernames from

table.

DECLARE @xx AS nvarChar(128)

SET @xx = (SELECT DB_NAME()) --Pick up current dbname

exec ('ALTER DATABASE '+@xx + 'SET RECURSIVE_TRIGGERS ON')

GO

store the max value into a table (only one row).